[PHP-DB] Re: checkboxes names & values in mySQL (newbie)
Here's a nifty trick.
Name your check boxes like this.
Then when it posts back to php, you will have a nice array. Lets say that
they tick all but value2, then you will have:
$myarray == array("value1", "value3", "value4");
I guess the order in which they appear is arbitrary, but that makes no
matter for a MySQL enum. So just do an implode on the array to put it in
the database.
Cheers,
Owen Prime
http://www.noggin.com.au
John wrote:
> I'm new at using PHP and mySQL, so please forgive my potentially naive
> question.
>
> I have a series of checkboxes with different values. The user can select
> any number of checkboxes, and I need to store this information in a mySQL
> table.
>
> 2 questions:
> Should I have a unique form name for each checkbox, and store it's boolean
> value in the database, OR (is it more streamlined) ..
> To create an array with
> the same name but different value for each checkbox.
>
> Finally, how do I construct the query to store the array of values? Do I
> need a separate column (enum('n','y') for each value, or should I store
> all the true values as a long text string?
>
> If anyone has some code snippets, that would help very much.
>
> Thanks very much!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] checkboxes names & values in mySQL (newbie)
Hello, John.
You wrote 10 îêòÿáðÿ 2002 ã., 23:40:10:
J> 2 questions:
J> Should I have a unique form name for each checkbox, and store it's
J> boolean value in the database, OR (is it more streamlined) ..
J> To create an array=myarray[$i]> with the same name but different value for each
J> checkbox.
Yes, you are right. This is a good way, to create an array.
J> Finally, how do I construct the query to store the array of values?
J> Do I need a separate column (enum('n','y') for each value, or
J> should I store all the true values as a long text string?
It'll be nice to store values separetly each in row.
Smth like this
INSERT INTO table (apps, value) VALUES ('apps', '$value[1]');
INSERT INTO table (apps, value) VALUES ('apps', '$value[2]');
etc.
Then, you can manupulate those values as you want.
www.pskov.ruwebmaster|programmer|DBA
www.invest.pskov.ru
www.education.pskov.ru
--
Best Regards,
Andrey mailto:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: easier way to do this? (time interval)
In article
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> Hello,
>
> Curious if there is an easier way to do this (using just SQL and not PHP).
> SQL seems powerful enough to do this but can't think of the synatx. Note, I
> am using MySQL so no sub-selects (or other useful items). Basically trying
> to pull all records for a 24 hour period but instead of ->2400,
> 0700->0700 (next day).
>
> if (date("H")>7){
>
> $query=mysql_query("
> SELECT dtg
> FROM techs
> WHERE
> tech='$user'
> AND
> DAYOFMONTH(NOW())=DAYOFMONTH(dtg)
> AND
> HOUR(dtg)>=7
> ");
>
> } else {
>
> $query=mysql_query("
> SELECT dtg
> FROM techs
> WHERE
> tech='$user'
> AND
> (
> (DAYOFMONTH(NOW())=DAYOFMONTH(dtg) AND HOUR(dtg)<7)
> OR
> ((DAYOFMONTH(NOW())-1)=DAYOFMONTH(dtg) AND HOUR(dtg)>=7)
> )
> ");
>
> }
>
> Cheers,
>
> -peter
I'd imagine that with a judicious use of mysql's IF statement and
HOUR(NOW()) you could do pretty much what you want. I can't be hanged
going through the docs right now, or I'd have a try at the syntax for you
:-)
--
David Robley
Temporary Kiwi!
Quod subigo farinam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] easier way to do this? (time interval)
Hello,
Curious if there is an easier way to do this (using just SQL and not PHP).
SQL seems powerful enough to do this but can't think of the synatx. Note, I
am using MySQL so no sub-selects (or other useful items). Basically trying
to pull all records for a 24 hour period but instead of ->2400,
0700->0700 (next day).
if (date("H")>7){
$query=mysql_query("
SELECT dtg
FROM techs
WHERE
tech='$user'
AND
DAYOFMONTH(NOW())=DAYOFMONTH(dtg)
AND
HOUR(dtg)>=7
");
} else {
$query=mysql_query("
SELECT dtg
FROM techs
WHERE
tech='$user'
AND
(
(DAYOFMONTH(NOW())=DAYOFMONTH(dtg) AND HOUR(dtg)<7)
OR
((DAYOFMONTH(NOW())-1)=DAYOFMONTH(dtg) AND HOUR(dtg)>=7)
)
");
}
Cheers,
-peter
##
Peter Thoenen - Systems Programmer
Commercial Communications
Camp Bondsteel, Kosovo
##
"Stumbled Upon"...heh (Score:5, Funny) /.
by $carab on 23:00 23 August 2002 (#4131637)
"ForensicTec officials said they stumbled upon the military networks about
two months ago, while checking on network security for a private-sector
client."
Someone new to a Dvorak probably tried to type in "lynx
http://www.google.com"; but instead got "nmap -v -p 1-1024 -sS -P0 army.mil
-T paranoid".
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sessions tutorial
This is a very good tutorial about authentication using PHP and MySQL. If you don't use database, you may still learn some thing about sessions from there: http://phpcomplete.com/content.php?id=72 Ruth - Original Message - From: "Edward Peloke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 11, 2002 3:54 AM Subject: [PHP-DB] sessions tutorial > Sorry, Michael, I meant to send this to the list, not just to you. I > apologize. > > > > > Hello all, > > I am a php newbie and am currently developing my first php page. My page > will allow several people to log in at the same time sharing access to the > mysql db. SO, I need to use sessions. Does anyone know of a good tutorial > on sessions to get me started? > > Thanks, > Eddie > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Multi-Dimensional Arrays
Perfect, thank you very much Owen!!
"Owen Prime" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Sounds like what your trying to do is:
>
> $cartArray[] = array("ItemNumber" => $itemnumber,
> "Brand" => $brand,
> "Quantity" => $itemqty,
> "ItemName" => $itemname);
>
> This will give you:
>
> $cartArray[0]["ItemNumber"] = $itemnumber;
> $cartArray[0]["Brand"] = $brand;
> $cartArray[0]["Quantity"] = $itemqty;
> $cartArray[0]["ItemName"] = $itemname;
>
> Running the very top statement again will give you:
>
> $cartArray[1]["ItemNumber"] = $itemnumber;
> $cartArray[1]["Brand"] = $brand;
> $cartArray[1]["Quantity"] = $itemqty;
> $cartArray[1]["ItemName"] = $itemname;
>
> Note that $cartArray[] = $val is just a short hand way of doing
> array_push($cartArray, $val);
>
> Cheers,
>
> Owen Prime
> http://www.noggin.com.au
>
>
>
> Jonathan Duncan wrote:
>
> > I am trying to create an array to hold shopping cart information. The
> > array
> > I am using is called "cartArray". What I want to do is to define a
> > sub-array of cartArray with the information from one product. Then the
> > next time a product is added it appends then new information as a second
> > sub-array to cartArray and so forth. Following is some code I have been
> > using to test with and so far PHP will let me use ".=" to append but
when
> > I try to call it back with "print_r" or echo array[][] only the first
> > entry is
> > returned. Any ideas what I am doing wrong?
> >
> >
> > $brand="Brand1";
> > $itemnumber="456789";
> > $itemname="Some Item Name";
> > $itemqty=3;
> > $cartArray[] .= array(0=>array($itemnumber=>"$brand", "$itemqty",
> > "$itemname"));
> > print_r($cartArray)."";
> > $brand="Brand2";
> > $itemnumber="123456";
> > $itemname="Another Item Name";
> > $itemqty=9;
> > array_push($cartArray, array($itemnumber=>"$brand", "$itemqty",
> > "$itemname"));
> > print_r($cartArray)."";
> > echo $cartArray[0][0]."";
> >
> >
> > Thank you,
> > Jonathan Duncan
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Selecting PASSWORD() value in MySQL
> I'm trying to retrieve data from a MySQL table which contains data
> encrypted with the MySQL "PASSWORD()" function from a PHP script but I
> can't seem to get it to work. Below is the query I'm trying:
>
> SELECT * FROM user_data WHERE username = 'thaak' AND password =
> PASSWORD('thaak');
>
> I then tried the following subquery/subselect:
>
> SELECT * FROM user_data WHERE username = 'thaak' AND password IN
(SELECT
> PASSWORD('thaak') FROM user_data);
>
> ...which also didn't work.
How do you know it "didn't work"? The first query is what you want to
use. If you are using PHP variables, make sure they actually have the
values you expect in them.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] update and join?
> Quick questionis it possible to do an update query w/ a join yet? If > not, what is your preferred method? Would you take care of it on the PHP > side? Probably depends on your database, but MySQL doesn't support it. I think MySQL 4.0 might. > I need to update a table w/ data from another table if certain conditions > are true, i.e the fields in the table to be joined are "NULL" You'll have to use a scripting language, or something outside of the database. Or maybe a INSERT INTO ... SELECT ... will help? ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] update and join?
Cory Hicks [mailto:[EMAIL PROTECTED]] wrote:
> Hello to all!
>
> Quick questionis it possible to do an update query w/ a
> join yet? If not, what is your preferred method? Would you
> take care of it on the PHP side?
No, it's not possible, at least not with MySQL 3.x. MySQL 4.1, currently in
development, will feature nested subqueries and multi-table-updates.
>
> I need to update a table w/ data from another table if
> certain conditions are true, i.e the fields in the table to
> be joined are "NULL"
>
I have to do that a couple of times, and always do it this way:
Build a SELECT statement, selecting all the data you will need in the
updates, and the primary key for the table which needs updates.
Fetch all the data in a nested array, like this:
$a = array( => array ("col1"=>"data1","col3"=>"data3"),
=> array ("col2"=>"data2","col3"=>"data3"),
);
and then, do the updates in a neat foreach loop:
foreach ($a as $pkey=>$data) {
[ build update stmt from $data array ]
dbquery ($stmt)
}
Hope this helps.
Thomas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] space in query
nevermind, stupid me, I got it working...
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 5:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] space in query
forgive the basic question but how do I add a space in my query
$result=mysql_query("SELECT * from ".$dbname.".grades WHERE user_id=".$uid.
" and subject=".$subject,$db);
I need to force a space between $uid and 'and' and I don't think simply
pressing the space bar does it.
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] space in query
forgive the basic question but how do I add a space in my query
$result=mysql_query("SELECT * from ".$dbname.".grades WHERE user_id=".$uid.
" and subject=".$subject,$db);
I need to force a space between $uid and 'and' and I don't think simply
pressing the space bar does it.
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] update and join?
Hello to all! Quick questionis it possible to do an update query w/ a join yet? If not, what is your preferred method? Would you take care of it on the PHP side? I need to update a table w/ data from another table if certain conditions are true, i.e the fields in the table to be joined are "NULL" Any help as always is greatly appreciated Thanks, Cory -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Selecting PASSWORD() value in MySQL
Hello,
I'm trying to retrieve data from a MySQL table which contains data encrypted with the
MySQL "PASSWORD()" function from a PHP script but I can't seem to get it to work.
Below is the query I'm trying:
SELECT * FROM user_data WHERE username = 'thaak' AND password = PASSWORD('thaak');
I then tried the following subquery/subselect:
SELECT * FROM user_data WHERE username = 'thaak' AND password IN (SELECT
PASSWORD('thaak') FROM user_data);
...which also didn't work.
If I just execute "SELECT PASSWORD('thaak')" from the MySQL command line it returns
the same value stored in the password column of my user_data table. I verified these
queries at the MySQL command line so I don't think it's a PHP problem.
I need to compare the password the user enters to log in against the password stored
in the DB. In addition to the "PASSWORD()" function, I also tried "MD5()" and
"ENCRYPT()" but they also failed. Can someone please help me accomplish this or point
me to some resources that might help?
Thanks!
Tim Haak
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] checkboxes names & values in mySQL (newbie)
I'm new at using PHP and mySQL, so please forgive my potentially naive question.
I have a series of checkboxes with different values. The user can select any number
of checkboxes, and I need to store this information in a mySQL table.
2 questions:
Should I have a unique form name for each checkbox, and store it's boolean value in
the database,
OR (is it more streamlined) ..
To create an array with the same
name but different value for each checkbox.
Finally, how do I construct the query to store the array of values? Do I need a
separate column (enum('n','y') for each value, or should I store all the true values
as a long text string?
If anyone has some code snippets, that would help very much.
Thanks very much!
[PHP-DB] sessions tutorial
Sorry, Michael, I meant to send this to the list, not just to you. I apologize. Hello all, I am a php newbie and am currently developing my first php page. My page will allow several people to log in at the same time sharing access to the mysql db. SO, I need to use sessions. Does anyone know of a good tutorial on sessions to get me started? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: AW: [PHP-DB] OT...where do I go for this......?
This is what I have in my config file: # The following is for PHP4 (conficts with PHP/FI, below): # AddType application/x-httpd-php .php4 .php3 .phtml .php AddType application/x-httpd-php-source .phps # # The following is for PHP3: # AddType application/x-httpd-php3 .php3 AddType application/x-httpd-php3-source .phps # # The following is for PHP/FI (PHP2): AddType application/x-httpd-php .phtml You can probably tell that I have commented out some of my Have you checked apache's config file for: > > AddType application/x-httpd-php .php > AddType application/x-httpd-php .php4 > AddType application/x-httpd-php-source.phps > > > BTW... I am trying to use the POST method in my php scripts. > > > > On 10 Oct 2002 at 10:20, Naved, Masroor wrote: > > > > > -Original Message- > > > > > > I am working on a simple inventory program and am running > > into the following > > > messageMethod > > > Not Allowed > > > The requested method POST is not allowed for the > > > URL/cafe_inventory/choose.php. Apache/1.3.23 Server at > > (domain.net) Port 80 > > > > > > If anyone can think of a mailing list, chat room, or even > > paid tech support > > > to help me with this > > > problem, I would greatly appreciate it. Michael Cortes Fort LeBoeuf School District 34 East 9th Street PO Box 810 Waterford PA 16411-0810 814.796.4795 Fax1 814.796.3358 Fax2 978-389-1258 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP-DB] OT...where do I go for this......?
Have you checked apache's config file for: AddType application/x-httpd-php .php AddType application/x-httpd-php .php4 AddType application/x-httpd-php-source .phps ? IIRC Apache denies POST to file types not registered for... Also it may be possible that your OS upgrade has overwritten your (old, maybe handcrafted) httpd.conf. Thomas Michael Cortes [mailto:[EMAIL PROTECTED]] wrote: > Gesendet: Donnerstag, 10. Oktober 2002 18:52 > An: [EMAIL PROTECTED] > Betreff: RE: [PHP-DB] OT...where do I go for this..? > > > I just checked and register_globals are on in php.ini. I > have also previously been in the > httpd.conf in my previous attempts to fix this problem. I > have googled my fingers off and all > fixes have mentioned the conf file for apache. I have played > with "options ExecCGI" as well as > other options as per google search results. > > BTW... I am trying to use the POST method in my php scripts. > > > > On 10 Oct 2002 at 10:20, Naved, Masroor wrote: > > > Michael, > > > > The easist way of fixing this is to turn register_globals on. It is > > defaulted to off since a few versions ago, I believe. > However, there are > > some security concerns you should be aware of with this > option. Google > > around for some discuss about this. > > On 10 Oct 2002 at 12:09, John W. Holmes wrote: > > > That would be an Apache configuration issue. Somewhere in > http.conf, I > > think, you can choose whether or not to allow GET/POST operations. > > > > -Original Message- > > > > I am working on a simple inventory program and am running > into the following > > messageMethod > > Not Allowed > > The requested method POST is not allowed for the > > URL/cafe_inventory/choose.php. Apache/1.3.23 Server at > (domain.net) Port 80 > > > > If anyone can think of a mailing list, chat room, or even > paid tech support > > to help me with this > > problem, I would greatly appreciate it. > > > Michael Cortes > Fort LeBoeuf School District > 34 East 9th Street > PO Box 810 > Waterford PA 16411-0810 > 814.796.4795 > Fax1 814.796.3358 > Fax2 978-389-1258 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] OT...where do I go for this......?
I just checked and register_globals are on in php.ini. I have also previously been in the httpd.conf in my previous attempts to fix this problem. I have googled my fingers off and all fixes have mentioned the conf file for apache. I have played with "options ExecCGI" as well as other options as per google search results. BTW... I am trying to use the POST method in my php scripts. On 10 Oct 2002 at 10:20, Naved, Masroor wrote: > Michael, > > The easist way of fixing this is to turn register_globals on. It is > defaulted to off since a few versions ago, I believe. However, there are > some security concerns you should be aware of with this option. Google > around for some discuss about this. On 10 Oct 2002 at 12:09, John W. Holmes wrote: > That would be an Apache configuration issue. Somewhere in http.conf, I > think, you can choose whether or not to allow GET/POST operations. > > -Original Message- > > I am working on a simple inventory program and am running into the following > messageMethod > Not Allowed > The requested method POST is not allowed for the > URL/cafe_inventory/choose.php. Apache/1.3.23 Server at (domain.net) Port 80 > > If anyone can think of a mailing list, chat room, or even paid tech support > to help me with this > problem, I would greatly appreciate it. Michael Cortes Fort LeBoeuf School District 34 East 9th Street PO Box 810 Waterford PA 16411-0810 814.796.4795 Fax1 814.796.3358 Fax2 978-389-1258 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem after upgrading to PHP 4.2.3
I recently upgrade to PHP 4.2.3 and started having problems with one of my applications. I have a PHP application that interfaces to a MySQL DB (version 3.23) all running on an Apache web server (1.3) under Linux 7. Up until doing the upgrade, everything had been working fine. Now on a daily basis, the MySQL server has started exceeding the max_connections. I doubled the number and again exceeded it. Being somewhat of a novice with all of this, I am somewhat at a loss as to where to look to identify the problem. Any suggestions that anyone can give me would be greatly appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] OT...where do I go for this......?
That would be an Apache configuration issue. Somewhere in http.conf, I think, you can choose whether or not to allow GET/POST operations. ---John Holmes... > -Original Message- > From: Michael Cortes [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 10:25 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] OT...where do I go for this..? > > I realize this is off topic, not php db interfacing. However, it is php > and I am hoping someone > can point me to a mailing list that would cover this question. So here > goes > > > I am working on a simple inventory program and am running into the > following messageMethod > Not Allowed > The requested method POST is not allowed for the > URL/cafe_inventory/choose.php. > Apache/1.3.23 Server at (domain.net) Port 80 > > I have been researching this and cannot get it fixed. I believe it may > have to do with Bastille. > I used Bastille about 2 years ago and 3 versions ago. I've updated the RH > on this server several > times but just recently added php and we plan to use it as our application > server, if I can get > this problem solved. > > If anyone can think of a mailing list, chat room, or even paid tech > support to help me with this > problem, I would greatly appreciate it. > > Thank you, > > > > Michael Cortes > Fort LeBoeuf School District > 34 East 9th Street > PO Box 810 > Waterford PA 16411-0810 > 814.796.4795 > Fax1 814.796.3358 > Fax2 978-389-1258 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] OT...where do I go for this......?
I realize this is off topic, not php db interfacing. However, it is php and I am hoping someone can point me to a mailing list that would cover this question. So here goes I am working on a simple inventory program and am running into the following messageMethod Not Allowed The requested method POST is not allowed for the URL/cafe_inventory/choose.php. Apache/1.3.23 Server at (domain.net) Port 80 I have been researching this and cannot get it fixed. I believe it may have to do with Bastille. I used Bastille about 2 years ago and 3 versions ago. I've updated the RH on this server several times but just recently added php and we plan to use it as our application server, if I can get this problem solved. If anyone can think of a mailing list, chat room, or even paid tech support to help me with this problem, I would greatly appreciate it. Thank you, Michael Cortes Fort LeBoeuf School District 34 East 9th Street PO Box 810 Waterford PA 16411-0810 814.796.4795 Fax1 814.796.3358 Fax2 978-389-1258 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Multi-Table Insert and gettin' data from auto-inc coloumn in one to the other
No, you have to use two queries to do two inserts into different tables... ---John Holmes... > -Original Message- > From: Noodle Snacks [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 7:07 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: Multi-Table Insert and gettin' data from auto-inc > coloumn in one to the other > > I can get the previous insert auto-increment id via mysql_insert_id(). it > will solve my problem. but if you know a soloution that will work in one > query please share it with me/everyone! > > > -- > JJ Harrison > [EMAIL PROTECTED] > > "Noodle Snacks" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I have table A with an auto increment coloumn called tid. during the > same > > query I need to get that value and stick it in a related record in > anouther > > table. > > > > I have two doubts. > > > > A: What is the way to do a multitable insert? guess is: INSERT INTO > > table(fields) VALUES (fields), table1(fields) VALUES (fields) etc... is > it > > even possible in one query? > > > > B: how can I get the auto increment value from one into the record on > the > > other table? > > > > > > -- > > JJ Harrison > > [EMAIL PROTECTED] > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Error query : mysql_result
This usually means your query failed. Check for errors using
mysql_error().
---John Holmes...
> -Original Message-
> From: Burgess [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 10, 2002 5:14 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Error query : mysql_result
>
> Hi
>
> I have used the mysql_result function to return some specific
information
> from database. The information is returned as it should but I keep
> getting
> this error message:
>
> Warning: Unable to jump to row 0 on MySQL result index 4 in
> /u1.bath/s31/eh842/public_html/SCR/register/process.php on line 140
>
>
>
> I'm relatively new to PHP and am unable to solve the problem so I
wondered
> if someone would mind spending a couple of minutes to help me.
>
> My script, in part, reads as below:
>
> // check to see if company exists in db
>
> $CompanyQuery = mysql_query("SELECT coid FROM co_details WHERE
co_name
> =
> '$company' AND co_city = '$city' AND co_country = '$co_country'");
>
> $CompanyExist = mysql_num_rows($CompanyQuery);
> $company_id= mysql_result($CompanyQuery,0,0);
>
> if ($CompanyExist > 0) {
>
> //if company exists add workplace details
>$confirmkey = md5(uniqid(rand()));
> $signup_id = signup_details($username, $title, $fname, $lname,
> $email,
> $country, $job_title, $user_notes, $agree_terms,
$confirmkey,$password);
> addworkplace($signup_id, $company_id, $department, $start_month,
> $start_year, $end_month, $end_year );
>
add_cons_info($signup_id,$functional,$technical,$mysap,$industry);
>
> } //END if statement
>
> else { //add company and workplace details
>
>// Add new member to table signup
> $confirmkey = md5(uniqid(rand()));
>$signup_id = signup_details($username, $title, $fname, $lname,
> $email, $country, $job_title, $user_notes, $agree_terms, $confirmkey,
> $password);
> $company_id = company_details($company, $city, $co_country);
> addworkplace($signup_id, $company_id, $department, $start_month,
> $start_year, $end_month, $end_year );
>
add_cons_info($signup_id,$functional,$technical,$mysap,$industry);
>
> } // END else statement
>
> }
>
> // if successful in adding to vAuthenticate, send confirmation
email
> if (mysql_errno() == 0){
>
>$emailerMessage .= "\n\n"; // 2 Line Breaks
>$emailerMessage .= $confirm; // URL to confirm.php -> see email.inc
>$emailerMessage .= "?confirmkey=" . $confirmkey; // add confirm key
to
> message
>$emailerMessage .= "\n\n"; // 2 Line Breaks
>$sent = @mail($email, $emailerSubject, $emailerMessage,
> "From:$emailerName<$emailerEmail>\nReply-to:$emailerEmail");
> } // END if statement
>
> }
>
>
>
>
> function signup_details($username, $title, $fname, $lname, $email,
> $country,
> $job_title, $user_notes, $agree_terms, $confirmkey, $password) {
>
> if ($user_notes == '') {
>
> $user_notes = "Member chose not to include a profile";
> $sql = "INSERT INTO signup VALUES
>
('','$username','$title','$fname','$lname','$email','$country','$job_tit
le
> ',
> '$user_notes','$agree_terms',NOW(),'$confirmkey')";
> $addmember = mysql_query($sql);
> $memberid=mysql_insert_id();
>
> // If SUCCESSFUL, add to vAuthenticate tables too
> if (mysql_errno() == 0){
> $AddToAuth = new auth();
> $add =
> $AddToAuth->add_user($username,$password,"Ungrouped","999","inactive",
'',
> 0);
> }
> else{
> print "this is the signup details sql statement\n ";
> print $sql."\n";
> print mysql_errno() . ": " . mysql_error() . "\n";
> exit;
> }
> return $memberid;
>
> }// END if
>
> else {
>
> $user_notes = addslashes($user_notes);
>
> $sql = "INSERT INTO signup VALUES
>
('','$username','$title','$fname','$lname','$email','$country','$job_tit
le
> ',
> '$user_notes','$agree_terms',NOW(),'$confirmkey')";
> $addmember = mysql_query($sql);
> $memberid=mysql_insert_id();
>
> // If SUCCESSFUL, add to vAuthenticate tables too
> if (mysql_errno() == 0){
> $AddToAuth = new auth();
> $add =
> $AddToAuth->add_user($username,$password,"Ungrouped","999","inactive",
'',
> 0);
> }
> else{
> print "this is the signup details sql statement\n ";
> print $sql."\n";
> print mysql_errno() . ": " . mysql_error() . "\n";
> exit;
> }
> return $memberid;
> }// END else
>
> } // END function
>
> function company_details($company, $city, $co_country)
> {
> $newcompanysql = "INSERT INTO co_details VALUES
> ('','$company','$city','$co_country')";
> $add_company= mysql_query($newcompanysql);
> if (mysql_errno() > 0){
> print "add compnay details \n";
> print $newcompanysql. "\n";
> print mysql_errno() . ": ".mysql_error() . "\n";
> exit;
> }
> else
> return mysql_insert_id();
> }
>
>
>
> function addworkplace ($signup_id, $company_id, $department,
$start_month,
> $start_year, $end_month, $end_year)
> {
> //start date in correct format
> $start_date= $start_y
[PHP-DB] Re: Multi-Table Insert and gettin' data from auto-inc coloumn in one to the other
I can get the previous insert auto-increment id via mysql_insert_id(). it will solve my problem. but if you know a soloution that will work in one query please share it with me/everyone! -- JJ Harrison [EMAIL PROTECTED] "Noodle Snacks" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have table A with an auto increment coloumn called tid. during the same > query I need to get that value and stick it in a related record in anouther > table. > > I have two doubts. > > A: What is the way to do a multitable insert? guess is: INSERT INTO > table(fields) VALUES (fields), table1(fields) VALUES (fields) etc... is it > even possible in one query? > > B: how can I get the auto increment value from one into the record on the > other table? > > > -- > JJ Harrison > [EMAIL PROTECTED] > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Multi-Table Insert and gettin' data from auto-inc coloumn in one to the other
I have table A with an auto increment coloumn called tid. during the same query I need to get that value and stick it in a related record in anouther table. I have two doubts. A: What is the way to do a multitable insert? guess is: INSERT INTO table(fields) VALUES (fields), table1(fields) VALUES (fields) etc... is it even possible in one query? B: how can I get the auto increment value from one into the record on the other table? -- JJ Harrison [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Error query : mysql_result
Burgess [mailto:[EMAIL PROTECTED]] wrote:
> Hi
>
> I have used the mysql_result function to return some specific
> information
> from database. The information is returned as it should but
> I keep getting
> this error message:
>
> Warning: Unable to jump to row 0 on MySQL result index 4 in
> /u1.bath/s31/eh842/public_html/SCR/register/process.php on line 140
>
> My script, in part, reads as below:
>
>133 // check to see if company exists in db
>134
>135 $CompanyQuery = mysql_query("SELECT coid FROM co_details
>136 WHERE co_name =
>137 '$company' AND co_city = '$city' AND co_country = '$co_country'");
>138
>139 $CompanyExist = mysql_num_rows($CompanyQuery);
>140 $company_id= mysql_result($CompanyQuery,0,0);
>141
>142 if ($CompanyExist > 0) {
>143
>144//if company exists add workplace details
>145 $confirmkey = md5(uniqid(rand()));
>146$signup_id = signup_details($username, $title, $fname,
> []
>
I have inserted the line numers where I think they are right, please correct
me...
This seems to be a common trivial error: in 139, you get the number of rows
found, but if there are none, you try to retrieve data in line 140, where
you get the error message. Exchange line 140 with 142, and the error message
will go away.
And please, the next time you ask here, post only code snippets (e.g.
beginning of function to 2-5 lines from where you get the error), and
include line numbers. Thanks.
Thomas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Error query : mysql_result
would be nice if you would tell which line is 140
-Original Message-
From: Burgess [mailto:[EMAIL PROTECTED]]
Sent: donderdag 10 oktober 2002 11:14
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error query : mysql_result
Hi
I have used the mysql_result function to return some specific information
from database. The information is returned as it should but I keep getting
this error message:
Warning: Unable to jump to row 0 on MySQL result index 4 in
/u1.bath/s31/eh842/public_html/SCR/register/process.php on line 140
I'm relatively new to PHP and am unable to solve the problem so I wondered
if someone would mind spending a couple of minutes to help me.
My script, in part, reads as below:
// check to see if company exists in db
$CompanyQuery = mysql_query("SELECT coid FROM co_details WHERE co_name =
'$company' AND co_city = '$city' AND co_country = '$co_country'");
$CompanyExist = mysql_num_rows($CompanyQuery);
$company_id= mysql_result($CompanyQuery,0,0);
if ($CompanyExist > 0) {
//if company exists add workplace details
$confirmkey = md5(uniqid(rand()));
$signup_id = signup_details($username, $title, $fname, $lname, $email,
$country, $job_title, $user_notes, $agree_terms, $confirmkey,$password);
addworkplace($signup_id, $company_id, $department, $start_month,
$start_year, $end_month, $end_year );
add_cons_info($signup_id,$functional,$technical,$mysap,$industry);
} //END if statement
else { //add company and workplace details
// Add new member to table signup
$confirmkey = md5(uniqid(rand()));
$signup_id = signup_details($username, $title, $fname, $lname,
$email, $country, $job_title, $user_notes, $agree_terms, $confirmkey,
$password);
$company_id = company_details($company, $city, $co_country);
addworkplace($signup_id, $company_id, $department, $start_month,
$start_year, $end_month, $end_year );
add_cons_info($signup_id,$functional,$technical,$mysap,$industry);
} // END else statement
}
// if successful in adding to vAuthenticate, send confirmation email
if (mysql_errno() == 0){
$emailerMessage .= "\n\n"; // 2 Line Breaks
$emailerMessage .= $confirm; // URL to confirm.php -> see email.inc
$emailerMessage .= "?confirmkey=" . $confirmkey; // add confirm key to
message
$emailerMessage .= "\n\n"; // 2 Line Breaks
$sent = @mail($email, $emailerSubject, $emailerMessage,
"From:$emailerName<$emailerEmail>\nReply-to:$emailerEmail");
} // END if statement
}
function signup_details($username, $title, $fname, $lname, $email, $country,
$job_title, $user_notes, $agree_terms, $confirmkey, $password) {
if ($user_notes == '') {
$user_notes = "Member chose not to include a profile";
$sql = "INSERT INTO signup VALUES
('','$username','$title','$fname','$lname','$email','$country','$job_title',
'$user_notes','$agree_terms',NOW(),'$confirmkey')";
$addmember = mysql_query($sql);
$memberid=mysql_insert_id();
// If SUCCESSFUL, add to vAuthenticate tables too
if (mysql_errno() == 0){
$AddToAuth = new auth();
$add =
$AddToAuth->add_user($username,$password,"Ungrouped","999","inactive", '',
0);
}
else{
print "this is the signup details sql statement\n ";
print $sql."\n";
print mysql_errno() . ": " . mysql_error() . "\n";
exit;
}
return $memberid;
}// END if
else {
$user_notes = addslashes($user_notes);
$sql = "INSERT INTO signup VALUES
('','$username','$title','$fname','$lname','$email','$country','$job_title',
'$user_notes','$agree_terms',NOW(),'$confirmkey')";
$addmember = mysql_query($sql);
$memberid=mysql_insert_id();
// If SUCCESSFUL, add to vAuthenticate tables too
if (mysql_errno() == 0){
$AddToAuth = new auth();
$add =
$AddToAuth->add_user($username,$password,"Ungrouped","999","inactive", '',
0);
}
else{
print "this is the signup details sql statement\n ";
print $sql."\n";
print mysql_errno() . ": " . mysql_error() . "\n";
exit;
}
return $memberid;
}// END else
} // END function
function company_details($company, $city, $co_country)
{
$newcompanysql = "INSERT INTO co_details VALUES
('','$company','$city','$co_country')";
$add_company= mysql_query($newcompanysql);
if (mysql_errno() > 0){
print "add compnay details \n";
print $newcompanysql. "\n";
print mysql_errno() . ": ".mysql_error() . "\n";
exit;
}
else
return mysql_insert_id();
}
function addworkplace ($signup_id, $company_id, $department, $start_month,
$start_year, $end_month, $end_year)
{
//start date in correct format
$start_date= $start_year."-".$start_month."-01";
//end date in correct format
$end_date = $end_year."-".$end_month."-01";
/* if ($end_month || $end_year == "Present")
$end_date="NULL";
else
$end_date=$end_year."-".$end_month."-01";
*/
$worksql = "INSERT INTO workplace VALUES
('','$signup_id','$company_id','$end_date','$start_date','$department')";
mysql_
[PHP-DB] Error query : mysql_result
Hi
I have used the mysql_result function to return some specific information
from database. The information is returned as it should but I keep getting
this error message:
Warning: Unable to jump to row 0 on MySQL result index 4 in
/u1.bath/s31/eh842/public_html/SCR/register/process.php on line 140
I'm relatively new to PHP and am unable to solve the problem so I wondered
if someone would mind spending a couple of minutes to help me.
My script, in part, reads as below:
// check to see if company exists in db
$CompanyQuery = mysql_query("SELECT coid FROM co_details WHERE co_name =
'$company' AND co_city = '$city' AND co_country = '$co_country'");
$CompanyExist = mysql_num_rows($CompanyQuery);
$company_id= mysql_result($CompanyQuery,0,0);
if ($CompanyExist > 0) {
//if company exists add workplace details
$confirmkey = md5(uniqid(rand()));
$signup_id = signup_details($username, $title, $fname, $lname, $email,
$country, $job_title, $user_notes, $agree_terms, $confirmkey,$password);
addworkplace($signup_id, $company_id, $department, $start_month,
$start_year, $end_month, $end_year );
add_cons_info($signup_id,$functional,$technical,$mysap,$industry);
} //END if statement
else { //add company and workplace details
// Add new member to table signup
$confirmkey = md5(uniqid(rand()));
$signup_id = signup_details($username, $title, $fname, $lname,
$email, $country, $job_title, $user_notes, $agree_terms, $confirmkey,
$password);
$company_id = company_details($company, $city, $co_country);
addworkplace($signup_id, $company_id, $department, $start_month,
$start_year, $end_month, $end_year );
add_cons_info($signup_id,$functional,$technical,$mysap,$industry);
} // END else statement
}
// if successful in adding to vAuthenticate, send confirmation email
if (mysql_errno() == 0){
$emailerMessage .= "\n\n"; // 2 Line Breaks
$emailerMessage .= $confirm; // URL to confirm.php -> see email.inc
$emailerMessage .= "?confirmkey=" . $confirmkey; // add confirm key to
message
$emailerMessage .= "\n\n"; // 2 Line Breaks
$sent = @mail($email, $emailerSubject, $emailerMessage,
"From:$emailerName<$emailerEmail>\nReply-to:$emailerEmail");
} // END if statement
}
function signup_details($username, $title, $fname, $lname, $email, $country,
$job_title, $user_notes, $agree_terms, $confirmkey, $password) {
if ($user_notes == '') {
$user_notes = "Member chose not to include a profile";
$sql = "INSERT INTO signup VALUES
('','$username','$title','$fname','$lname','$email','$country','$job_title',
'$user_notes','$agree_terms',NOW(),'$confirmkey')";
$addmember = mysql_query($sql);
$memberid=mysql_insert_id();
// If SUCCESSFUL, add to vAuthenticate tables too
if (mysql_errno() == 0){
$AddToAuth = new auth();
$add =
$AddToAuth->add_user($username,$password,"Ungrouped","999","inactive", '',
0);
}
else{
print "this is the signup details sql statement\n ";
print $sql."\n";
print mysql_errno() . ": " . mysql_error() . "\n";
exit;
}
return $memberid;
}// END if
else {
$user_notes = addslashes($user_notes);
$sql = "INSERT INTO signup VALUES
('','$username','$title','$fname','$lname','$email','$country','$job_title',
'$user_notes','$agree_terms',NOW(),'$confirmkey')";
$addmember = mysql_query($sql);
$memberid=mysql_insert_id();
// If SUCCESSFUL, add to vAuthenticate tables too
if (mysql_errno() == 0){
$AddToAuth = new auth();
$add =
$AddToAuth->add_user($username,$password,"Ungrouped","999","inactive", '',
0);
}
else{
print "this is the signup details sql statement\n ";
print $sql."\n";
print mysql_errno() . ": " . mysql_error() . "\n";
exit;
}
return $memberid;
}// END else
} // END function
function company_details($company, $city, $co_country)
{
$newcompanysql = "INSERT INTO co_details VALUES
('','$company','$city','$co_country')";
$add_company= mysql_query($newcompanysql);
if (mysql_errno() > 0){
print "add compnay details \n";
print $newcompanysql. "\n";
print mysql_errno() . ": ".mysql_error() . "\n";
exit;
}
else
return mysql_insert_id();
}
function addworkplace ($signup_id, $company_id, $department, $start_month,
$start_year, $end_month, $end_year)
{
//start date in correct format
$start_date= $start_year."-".$start_month."-01";
//end date in correct format
$end_date = $end_year."-".$end_month."-01";
/* if ($end_month || $end_year == "Present")
$end_date="NULL";
else
$end_date=$end_year."-".$end_month."-01";
*/
$worksql = "INSERT INTO workplace VALUES
('','$signup_id','$company_id','$end_date','$start_date','$department')";
mysql_query($worksql);
// need to meddle with date to get correct format
if (mysql_errno() > 0){
print "add workplace details";
print "" . $worksql. "";
print mysql_errno() . ": ".mysql_error() ;
exit;
}
Please
Re: [PHP-DB] MySQL REGEXP functionality... any way to make this easier?
Hi,
unfortunately i can't help you much, but listen
you can make your pattern more readable if you
delete "[]" there's no need for classes in your pattern
SELECT * FROM ospd WHERE word REGEXP
'^a?p?e?$|^a?e?p?$|^p?e?a?$|^p?a?e?$|^e?a?p?$|^e?p?a?$';
? = one or none but if you need each letter then omit "?"
SELECT * FROM ospd WHERE word REGEXP '^ape$|^aep$|^pea$|^pae$|^eap$|^epa$';
this is the simplest way but it also matches aae, aaa, ppe, ppp ... and
probably not what you need
SELECT * FROM ospd WHERE word REGEXP '^[aep]{3}$';
I thnk you don't have another choice then to write each combination by
yourself
greet
martin
- Original Message -
From: "Xepherys" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 8:26 AM
Subject: [PHP-DB] MySQL REGEXP functionality... any way to make this easier?
> Right now, a sample query I might have would be...
>
> SELECT * FROM ospd WHERE word REGEXP '^([a]?[p]?[e]?)$|^[p]?[a]?[e]?$|^[a
> ]?[e]?[p]?$|^[p]?[e]?[a]?$|^[e]?[p]?[a]?$|^[e]?[a]?[p]?$';
>
>
> where basically I need to query every combination of a, p and e. This is
a
> pain, but for only three letter is not so bad. As you can see, this could
> become unruly with larger numbers of letters. Each instance of a letter
can
> only occur once. However, a letter may be duplicated and used once for
each
> instance. Hence the statement steps through... it could also be something
> like...
>
> SELECT * FROM ospd WHERE word REGEXP
> '^[a]?[a]?[e]?$|^[a]?[e]?[a]?$||^[e]?[a]?[a]?$';
>
> more easily written because one letter is used twice and can occure once
for
> each instance. Please let me know if you have any ideas.
>
>
> Jesse
> [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
