In C API, I want to insert 1 sql.
I must have one strSql= insert into tables hello id ,blob
values(?,?),(?,?),(?,?)..。
then bind every pos with mysql_stmt_bind_param（）.
then to exec.
In C API don't have batchexec。
if I can have strSQL = inset into tables hello id,blob values1
> Being rather new to all this, I understood from the MySql manual that
> the auto_increment is to b e used immediately after an insertion not
> intermittently. My application is for administrators (the site owner &
> designates) to update the database from and administration directory,
> accessed
Ashley Sheridan wrote:
> On Thu, 2009-02-26 at 14:15 -0500, PJ wrote:
>
>> Ashley Sheridan wrote:
>>
>>> On Thu, 2009-02-26 at 13:56 -0500, PJ wrote:
>>>
>>>
Ashley Sheridan wrote:
> On Thu, 2009-02-26 at 13:34 -0500, Darryle Steplight wrote:
>
Sorry, I should know better.
>-Original Message-
>From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk]
>Sent: Thursday, February 26, 2009 1:51 PM
>To: Jerry Schwartz
>Cc: 'PJ'; 'Gary W. Smith'; 'MySql'; php-gene...@lists.php.net
>Subject: RE: [PHP] RE: non-auto increment question
>
>On
Ashley Sheridan wrote:
> On Thu, 2009-02-26 at 13:56 -0500, PJ wrote:
>
>> Ashley Sheridan wrote:
>>
>>> On Thu, 2009-02-26 at 13:34 -0500, Darryle Steplight wrote:
>>>
>>>
Hi PJ,
$db_host = 'biggie';
$db_user = 'root';
$db_pass = 'gu...@#$';
$db_name =
Gentlemen,
my opinion is that this post is OFF TOPIC, let's don't wade into the PHP
world here, let's keep this list clean and focused on MySQL.
If the insert works from console and not from PHP probably is PHP
related problem and there are thousands of lists on PHP.
This is the most professio
Ashley Sheridan wrote:
> On Thu, 2009-02-26 at 13:44 -0500, Jerry Schwartz wrote:
>
>>> Here's how I mostly do it (albeit simplified):
>>>
>>> $query = "INSERT INTO `sometable`(`title`,`content`)
>>> VALUES('$title','$content')";
>>> $result = mysql_query($query);
>>> $autoId = mysql_insert_id($
Here's the working code...
Error performing 3st query: " .
mysql_error() . "");
}
echo $sql1;
echo "";
echo $db_select;
exit();
?>
This works fine either as is or using the include... :-)
9el wrote:
> But the question is PJ, have you got it out of errors yet? :)
>
> www.twitter.com/nine_
Ashley Sheridan wrote:
> On Thu, 2009-02-26 at 13:34 -0500, Darryle Steplight wrote:
>
>> Hi PJ,
>>$db_host = 'biggie';
>> $db_user = 'root';
>> $db_pass = 'gu...@#$';
>> $db_name = 'biblane';
>>
>>
>>
>> Everyone here is trying to help you and that's cool, but EVERYONE on
>> this list may n
Jerry Schwartz wrote:
>
>> -Original Message-
>> From: PJ [mailto:af.gour...@videotron.ca]
>> Sent: Thursday, February 26, 2009 12:28 PM
>> To: php-gene...@lists.php.net; MySql
>> Subject: catch the error
>>
>> What is wrond with this file? same identical insert works from console
>> but
Additionally regarding the error handling , add this to the op of your script.
ini_set("display_errors","true");
error_reporting(E_STRICT|E_ALL);
and post the output of your error message.
On Thu, Feb 26, 2009 at 1:40 PM, Ashley Sheridan
wrote:
> On Thu, 2009-02-26 at 13:34 -0500, Darryle Stepl
>Here's how I mostly do it (albeit simplified):
>
>$query = "INSERT INTO `sometable`(`title`,`content`)
>VALUES('$title','$content')";
>$result = mysql_query($query);
>$autoId = mysql_insert_id($result);
>
>$query = "INSERT INTO `another_table`(`link_id`,`value`)
>VALUES($autoId,'$value');
>$result
>-Original Message-
>From: PJ [mailto:af.gour...@videotron.ca]
>Sent: Thursday, February 26, 2009 12:28 PM
>To: php-gene...@lists.php.net; MySql
>Subject: catch the error
>
>What is wrond with this file? same identical insert works from console
>but not from this file :-(
>
>
>
>Untit
>-Original Message-
>From: PJ [mailto:af.gour...@videotron.ca]
>Sent: Thursday, February 26, 2009 11:27 AM
>To: Jerry Schwartz
>Cc: a...@ashleysheridan.co.uk; 'Gary W. Smith'; 'MySql'; php-
>gene...@lists.php.net
>Subject: Re: [PHP] RE: non-auto increment question
>
>Jerry Schwartz wrote:
Hi PJ,
$db_host = 'biggie';
$db_user = 'root';
$db_pass = 'gu...@#$';
$db_name = 'biblane';
Everyone here is trying to help you and that's cool, but EVERYONE on
this list may not be so nice. The above credentials is definitely the
type of information you want to keep private, unless you don't
Darryle Steplight wrote:
> ok, well if that's the case then do this
>
> $db = mysql_connect('biggie', 'user', 'password', 'test');
>
Ashley pointed out that the 4th parameter is not right - belongs in
mysql_select_db. Here it is corrected: (but it still does not work)
Error performing 1st query
Ricardo Dias Marques wrote:
> Hi PJ,
>
> On Thu, Feb 26, 2009 at 17:28, PJ wrote:
>
>
>> What is wrond with this file? same identical insert works from console
>> but not from this file :-(
>>
>> [snip]
>>
>> > //include ("lib/db1.php");// Connect to database
>> mysql_connect('biggie', 'use
Jim Lyons wrote:
> what's the error message?
it's in the script/// Error performing query: of Error performing 1st
query: - whatever I input.
But I had an error in the include location... that's fixed and it works,
but not the rest as corrected:
Error performing 1st query: " .
mysql_error()
Ashley Sheridan wrote:
> On Thu, 2009-02-26 at 12:28 -0500, PJ wrote:
>> What is wrond with this file? same identical insert works from console
>> but not from this file :-(
>>
>>
>>
>> Untitled
>>
>>
>>
>> > //include ("lib/db1.php"); // Connect to database
>> mysql_connect('biggie', 'user', '
ok, well if that's the case then do this
$db = mysql_connect('biggie', 'user', 'password', 'test');
That should fix the problem.
On Thu, Feb 26, 2009 at 12:46 PM, PJ wrote:
> It is commented out because I am using "mysql_connect"
> I don't think it would be good to use both, since the db1
Hi PJ,
On Thu, Feb 26, 2009 at 17:28, PJ wrote:
> What is wrond with this file? same identical insert works from console
> but not from this file :-(
>
> [snip]
>
> //include ("lib/db1.php"); // Connect to database
> mysql_connect('biggie', 'user', 'password', 'test');
> $sql1 = "INSERT INTO
>-Original Message-
>From: walterh...@gmail.com [mailto:walterh...@gmail.com] On Behalf Of
>Walter Heck
>Sent: Wednesday, February 25, 2009 11:43 PM
>To: Jerry Schwartz
>Cc: Gary W. Smith; Claudio Nanni; MySql
>Subject: Re: Upgrade story / request for insight
>
>Maybe this could help you:
>
what's the error message?
On Thu, Feb 26, 2009 at 11:46 AM, PJ wrote:
> It is commented out because I am using "mysql_connect"
> I don't think it would be good to use both, since the db1 references
> another db. But even when I use the db1.php and change the database and
> table, I get the s
It is commented out because I am using "mysql_connect"
I don't think it would be good to use both, since the db1 references
another db. But even when I use the db1.php and change the database and
table, I get the same error message.
But what I did miss is my typo in "What is wrond with this fi
Hi PJ,
Could it be that you have "//include ("lib/db1.php"); " commented
out? Try uncommenting that line and see what happens. The error
message will always print because the query is never executing
properly if you have the db connections file commented out.
On Thu, Feb 26, 2009 at 12:28 PM,
What is wrond with this file? same identical insert works from console
but not from this file :-(
Untitled
Error performing 1st query: " .
mysql_error() . "");
exit();
}
?>
Seems to be good to print out the error message, but that's all. db not
written.
--
Phil Jourdan ---
Jerry Schwartz wrote:
>> Being rather new to all this, I understood from the MySql manual that
>> the auto_increment is to b e used immediately after an insertion not
>> intermittently. My application is for administrators (the site owner &
>> designates) to update the database from and administra
27 matches
Mail list logo
