Ensuring records are written to the MySQL database

[cover]

Is there any basic, sure fire 'if - else' script that will ensure that
records entered into my form will actually be written to the database?
I noticed when debugging one day that records would show up when using
the print command as though they'd been entered but hadn't actually
been written to the database. I'm hoping to find some sort of if/else
script that can be easily used with 'insert into' in my PHP. Am using
MySQL 4.1.11nt and PHP 5.04

A sample code I'm working on...
mysql_connect($ DBhost,$DBuser, $DBpass) or die("Unable to connect to
database"); // make connection to database
mysql_select_db ($DBName) or die("Unable to select database $DBName");
// select database
if (mysqli_connect _errno())
{
echo 'Error: Could not connect to database. Please report this
problem';
exit;
}
$sqlquery = "INSERT INTO $table VALUES('$id', '$money', '$treats',
'$date')";
$results = mysql_query($sq lquery);
mysql_close();

TIA for any help.

[Tom Thackrey]

Re: Ensuring records are written to the MySQL database



On 6-May-2005, cover <coverland914 @ yahoo.com> wrote:
[color=blue]
> Is there any basic, sure fire 'if - else' script that will ensure that
> records entered into my form will actually be written to the database?
> I noticed when debugging one day that records would show up when using
> the print command as though they'd been entered but hadn't actually
> been written to the database. I'm hoping to find some sort of if/else
> script that can be easily used with 'insert into' in my PHP. Am using
> MySQL 4.1.11nt and PHP 5.04[/color]

mysql_query() returns TRUE or FALSE to indicate the success of the query.
You can test it with an if.

Look at example 1 in the manual:

http://www.php.net/manual/en/function.mysql-db-query.php

--
Tom Thackrey

https://www.creative-light.com

tom (at) creative (dash) light (dot) com
do NOT send email to jamesbutler@wil lglen.net (it's reserved for spammers)

[Philip Olson]

Re: Ensuring records are written to the MySQL database

Yes. I can't tell if you're using mysql or mysqli so first pick one and
then use one of the following:

http://php.net/manual/en/function.mysql-affected-rows.php

http://php.net/manual/en/function.mysqli-affected-rows.php

[cover]

Re: Ensuring records are written to the MySQL database

Isn't mysqli the one that is preferred? If so, I'll probably just use
that one exclusively. Thanks very much guys - appreciate your
replies.


On 6 May 2005 23:45:53 -0700, "Philip Olson" <philipolson@gm ail.com>
wrote:
[color=blue]
>Yes. I can't tell if you're using mysql or mysqli so first pick one and
>then use one of the following:
>
>http://php.net/manual/en/function.my...ected-rows.php
>http://php.net/manual/en/function.my...ected-rows.php[/color]

[cover]

Re: Ensuring records are written to the MySQL database

Isn't mysqli the one that is preferred? If so, I'll probably just use
that one exclusively. Thanks very much guys - appreciate your
replies.


On 6 May 2005 23:45:53 -0700, "Philip Olson" <philipolson@gm ail.com>
wrote:
[color=blue]
>Yes. I can't tell if you're using mysql or mysqli so first pick one and
>then use one of the following:
>
>http://php.net/manual/en/function.my...ected-rows.php
>http://php.net/manual/en/function.my...ected-rows.php[/color]

[Peter]

Re: Ensuring records are written to the MySQL database

mysqli is used in php5 ONLY
[color=blue]
> Isn't mysqli the one that is preferred? If so, I'll probably just use
> that one exclusively. Thanks very much guys - appreciate your
> replies.[/color]