PHP SQL - Ensuring records are written to the MySQL database

Author

Ensuring records are written to the MySQL database

cover

2005-05-07, 3:55 am

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($sqlquery);
mysql_close();

TIA for any help.

Philip Olson

2005-05-07, 8:56 am

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.m...fected-rows.php
http://php.net/manual/en/function.m...fected-rows.php

cover

2005-05-11, 3:58 am

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@gmail.com>
wrote:

>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.m...fected-rows.php
>http://php.net/manual/en/function.m...fected-rows.php

Peter

2005-05-11, 3:58 pm

mysqli is used in php5 ONLY

> 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.

Sponsored Links