Re: [PHP] PHP Udate MySQL command Success
""Gary"" wrote in message
news:a9.ea.07323.381e8...@pb1.pair.com...
>
> "Ashley Sheridan" wrote in message
> news:1275649100.2217.45.ca...@localhost...
>> On Fri, 2010-06-04 at 06:46 -0400, Gary wrote:
>>
>>> I am trying to get an update command to work in PHP. I am able to
>>> update
>>> records going directly to phpmyadmin command line. I have even let it
>>> produce the php code to insert, but have not been able to get it to
>>> work.
>>>
>>> I have it stripped down to one command hoping to get it to work then
>>> replicate entire forms for clients to use direct.I get no error codes, I
>>> only get my message "It did not enter into DB";
>>>
>>> Anyone see where I am going wrong?
>>>
>>> Gary
>>>
>>> >> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
>>> http://www.w3.org/1999/xhtml";>
>>>
>>>
>>> Untitled Document
>>>
>>>
>>>
>>>
>>> test
>>>
>>>
>>>
>>> >>
>>>
>>> $batchconnetion = mysql_connect(host, 'un', 'pw', 'db')//sanatized for
>>> board
>>> or die('Error connecting with MySQL Database');
>>>
>>> $test=$_POST['test'];
>>>
>>> //$sql="update contact set type = \'$test\' where item_id = \'164\'";
>>> //this
>>> is the code created by phpmyadmin
>>>
>>> $sql = "INSERT INTO contact comments, VALUES = $test WHERE contact_id
>>> =
>>> 33";
>>>
>>> mysql_query($sql,$batchconnetion);
>>>
>>> $result = mysql_query($sql,$batchconnetion);
>>>
>>> if($result == true) {
>>>echo "Successfully Inserted Records";
>>>} else {
>>>echo "It did not enter into DB";
>>> }
>>>
>>> mysql_close($batchconnetion);
>>>
>>> ?>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> __ Information from ESET Smart Security, version of virus
>>> signature database 5171 (20100604) __
>>>
>>> The message was checked by ESET Smart Security.
>>>
>>> http://www.eset.com
>>>
>>>
>>>
>>>
>>>
>>
>> Your problem is the way you're trying to connect to the DB:
>>
>> $batchconnetion = mysql_connect(host, 'un', 'pw', 'db')//sanatized for
>> board
>> or die('Error connecting with MySQL Database');
>>
>> The 4th argument to this function isn't a database name, it's a boolean
>> value for whether PHP should create a new link or reuse the old one. You
>> have to use the mysql_select_db() function to select the database to use
>> on that connection in order for your queries to run the way you have
>> them.
>>
>> There does seem to be a bit of an inconsistency with the way you're
>> using quotation marks on your query strings as well. Your first
>> commented out query is escaping the single quotes within a double quoted
>> string (which isn't necessary), you've omitted the single quotes on your
>> insert line, and then on your amended email you've omitted the double
>> quotes. If this is your actual code and not a mistake made when copying
>> it into an email, then it would also be a second reason why things
>> aren't working as expected even once you get PHP to connect properly.
>>
>> Thanks,
>> Ash
>> http://www.ashleysheridan.co.uk
>>
>>
>>
>>
>>
>> __ Information from ESET Smart Security, version of virus
>> signature database 5171 (20100604) __
>>
>> The message was checked by ESET Smart Security.
>>
>> http://www.eset.com
>>
>>
>
> Ashley
>
> Thank you for your quick reply.
>
> The $batchconnection works fine in numerous other files (the insert files)
> and is a c/p from one of those files. The db noted in my post was just to
> specify that the name of the database at this point, I thought it was a
> standard practice. I will try your suggestion.
>
> I will admit that I dont have the full grasp of the quotes, single or
> double. Typically in a mysql command I start with a ", however if I get a
> script that is not working, I will try to resolve the issue with switching
> up the singles with the doubles as well and adding parenthsis.
>
> The mistake in the copying the code was I was trying to see if the insert
> command would work in place of the update.it did not..
>
> Aside from that, do you see a problem with my update commands?
>
> Thanks for your help.
>
> gary
>
>
>
>
> __ Information from ESET Smart Security, version of virus
> signature database 5171 (20100604) __
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
>
Ashley
Thanks for your input, I think what corrected the problem was I added single
qoutes to the $test variable.
I did also change to your suggestion.
The working code is
test
__ Information from ESET Smart Security, version of virus signature
database 5171 (20100604) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP Udate MySQL command
"Ashley Sheridan" wrote in message
news:1275649100.2217.45.ca...@localhost...
> On Fri, 2010-06-04 at 06:46 -0400, Gary wrote:
>
>> I am trying to get an update command to work in PHP. I am able to update
>> records going directly to phpmyadmin command line. I have even let it
>> produce the php code to insert, but have not been able to get it to work.
>>
>> I have it stripped down to one command hoping to get it to work then
>> replicate entire forms for clients to use direct.I get no error codes, I
>> only get my message "It did not enter into DB";
>>
>> Anyone see where I am going wrong?
>>
>> Gary
>>
>> > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
>> http://www.w3.org/1999/xhtml";>
>>
>>
>> Untitled Document
>>
>>
>>
>>
>> test
>>
>>
>>
>> >
>>
>> $batchconnetion = mysql_connect(host, 'un', 'pw', 'db')//sanatized for
>> board
>> or die('Error connecting with MySQL Database');
>>
>> $test=$_POST['test'];
>>
>> //$sql="update contact set type = \'$test\' where item_id = \'164\'";
>> //this
>> is the code created by phpmyadmin
>>
>> $sql = "INSERT INTO contact comments, VALUES = $test WHERE contact_id =
>> 33";
>>
>> mysql_query($sql,$batchconnetion);
>>
>> $result = mysql_query($sql,$batchconnetion);
>>
>> if($result == true) {
>>echo "Successfully Inserted Records";
>>} else {
>>echo "It did not enter into DB";
>> }
>>
>> mysql_close($batchconnetion);
>>
>> ?>
>>
>>
>>
>>
>>
>>
>>
>> __ Information from ESET Smart Security, version of virus
>> signature database 5171 (20100604) __
>>
>> The message was checked by ESET Smart Security.
>>
>> http://www.eset.com
>>
>>
>>
>>
>>
>
> Your problem is the way you're trying to connect to the DB:
>
> $batchconnetion = mysql_connect(host, 'un', 'pw', 'db')//sanatized for
> board
> or die('Error connecting with MySQL Database');
>
> The 4th argument to this function isn't a database name, it's a boolean
> value for whether PHP should create a new link or reuse the old one. You
> have to use the mysql_select_db() function to select the database to use
> on that connection in order for your queries to run the way you have
> them.
>
> There does seem to be a bit of an inconsistency with the way you're
> using quotation marks on your query strings as well. Your first
> commented out query is escaping the single quotes within a double quoted
> string (which isn't necessary), you've omitted the single quotes on your
> insert line, and then on your amended email you've omitted the double
> quotes. If this is your actual code and not a mistake made when copying
> it into an email, then it would also be a second reason why things
> aren't working as expected even once you get PHP to connect properly.
>
> Thanks,
> Ash
> http://www.ashleysheridan.co.uk
>
>
>
>
>
> __ Information from ESET Smart Security, version of virus
> signature database 5171 (20100604) __
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
Ashley
Thank you for your quick reply.
The $batchconnection works fine in numerous other files (the insert files)
and is a c/p from one of those files. The db noted in my post was just to
specify that the name of the database at this point, I thought it was a
standard practice. I will try your suggestion.
I will admit that I dont have the full grasp of the quotes, single or
double. Typically in a mysql command I start with a ", however if I get a
script that is not working, I will try to resolve the issue with switching
up the singles with the doubles as well and adding parenthsis.
The mistake in the copying the code was I was trying to see if the insert
command would work in place of the update.it did not..
Aside from that, do you see a problem with my update commands?
Thanks for your help.
gary
__ Information from ESET Smart Security, version of virus signature
database 5171 (20100604) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP Udate MySQL command
On Fri, 2010-06-04 at 06:46 -0400, Gary wrote:
> I am trying to get an update command to work in PHP. I am able to update
> records going directly to phpmyadmin command line. I have even let it
> produce the php code to insert, but have not been able to get it to work.
>
> I have it stripped down to one command hoping to get it to work then
> replicate entire forms for clients to use direct.I get no error codes, I
> only get my message "It did not enter into DB";
>
> Anyone see where I am going wrong?
>
> Gary
>
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
> http://www.w3.org/1999/xhtml";>
>
>
> Untitled Document
>
>
>
>
> test
>
>
>
>
>
> $batchconnetion = mysql_connect(host, 'un', 'pw', 'db')//sanatized for board
> or die('Error connecting with MySQL Database');
>
> $test=$_POST['test'];
>
> //$sql="update contact set type = \'$test\' where item_id = \'164\'"; //this
> is the code created by phpmyadmin
>
> $sql = "INSERT INTO contact comments, VALUES = $test WHERE contact_id =
> 33";
>
> mysql_query($sql,$batchconnetion);
>
> $result = mysql_query($sql,$batchconnetion);
>
> if($result == true) {
>echo "Successfully Inserted Records";
>} else {
>echo "It did not enter into DB";
> }
>
> mysql_close($batchconnetion);
>
> ?>
>
>
>
>
>
>
>
> __ Information from ESET Smart Security, version of virus signature
> database 5171 (20100604) __
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
>
>
Your problem is the way you're trying to connect to the DB:
$batchconnetion = mysql_connect(host, 'un', 'pw', 'db')//sanatized for
board
or die('Error connecting with MySQL Database');
The 4th argument to this function isn't a database name, it's a boolean
value for whether PHP should create a new link or reuse the old one. You
have to use the mysql_select_db() function to select the database to use
on that connection in order for your queries to run the way you have
them.
There does seem to be a bit of an inconsistency with the way you're
using quotation marks on your query strings as well. Your first
commented out query is escaping the single quotes within a double quoted
string (which isn't necessary), you've omitted the single quotes on your
insert line, and then on your amended email you've omitted the double
quotes. If this is your actual code and not a mistake made when copying
it into an email, then it would also be a second reason why things
aren't working as expected even once you get PHP to connect properly.
Thanks,
Ash
http://www.ashleysheridan.co.uk
[PHP] PHP Udate MySQL command
I am trying to get an update command to work in PHP. I am able to update records going directly to phpmyadmin command line. I have even let it produce the php code to insert, but have not been able to get it to work. I have it stripped down to one command hoping to get it to work then replicate entire forms for clients to use direct.I get no error codes, I only get my message "It did not enter into DB"; Anyone see where I am going wrong? Gary http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> http://www.w3.org/1999/xhtml";> Untitled Document test __ Information from ESET Smart Security, version of virus signature database 5171 (20100604) __ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
