Welcome to Database-Talk!

Anon

The discussion of MySQL and PostgreSQL certainly inspired a lot of opinions.

You can talk about database here and how to make them work with PHP.

Anon

After mind a lot of comparisons and thinking on this topic I came to this conclusion:

Read Only DB & simple stuff like guestbooks: MySQL

It's fast and simple. For reasons why not to go further, see: http://openacs.org/why-not-mysql.html

Serious Stuff (OpenSource): Interbase and PostgreSQL

Deep Pockets: Oracle & Solid

Both Interbase and Postgre still need some development. IB awaits it's v6.0 OpenSource release and PostgreSQL will be after a debugged 7.1 release and development of some important maintenance tools a good choice for transaction based applications. Those are commented as banking/accounting stuff in the article (will say: most people don't need this). Well, I believe transactions are the core of ANY database backed application. I encourage anyone serious about databases to go to http://photo.net and dig this stuff. I think there are many talented developers out there, but some (too many for my taste) lack a serious attitude in terms of reliability and security of their deployed applications, especially in the PHP enviroment (flame on). Maybe it's that those people come from a different background. I don't suggest that developers with an MIT grade are smarter, but maybe better educated. Anyway, thanks to the web everyone who's willing can learn what it takes to be on top.

I will use myself PHP and Interbase running on a BSD box, and hope that Interbase will become for the PHP community what MySQL is today: The number one choice (though I don't really believe it will happen).

Anon

C'est une bonne idee!

Anon

I agree on all counts.

I actually like Postgres in a lot of ways - but I do think it runs into corruption occasionally, and I hate that. It takes a lot of time to rebuild large databases.

MySQL is trying to beef up and become a real database. The 3.23 serious sounds like a good first step.

I wish I could get some people to write about MS SQL and Oracle, as a lot of people want some info. Unfortunately, I know nothing about either one.

Anon

Hi,

I hope this is the right forum for this. If not, my apologies. I am currently working on a multi-page signup form with lots of database access. Everything was fine until we upgraded to PHP 4.01 and MySQL 3.23.21.

Now, I can no longer add a new row without getting a warning. A quick query of the table shows that the data was actually added.

I don't know if I am doing something wrong (i.e. configuration of PHP, MySQL or a coding error) or it is a bug in PHP. Same error also occurs when you try to add a row using phpMyAdmin. It doesn't seem like an MySQL problem because I can add rows to the the table outside of php.

Here is a sample code snippet to illustrate the problem:

//Connect to MySQL

$connection = mysql_connect($host,$user,$password) or die("No Connection");

//Select the Database

mysql_select_db($database, $connection) or die("Can't Select Database");

//Query Database and add a row into the TEST table.

$addrow = "INSERT INTO test VALUES ('$name1', '$name2')";
$result= mysql_query($addrow, $connection) or die("Can't Add Selections to Test Table");

$row = mysql_fetch_array($result);
echo($row["name1"] . " " . $row["name2"]);

The variables "name1" and "name2 are submitted from a form. Running a script with containing this code, I get the following error:

Warning: MySQL: Unable to save result set in /home/httpd/web/new/dbtest.php3 on line 35
Can't Add Selections to Test Table

Note: Line 35 is the line containing the query. Also, if I remove the "die" function, I get an additional error on the mysql_fetch_array line. This seems to indicate that the $result variable returned false. As mentioned above, the row is actually added to the database. This also does not work if I use mysql_db_query instead of mysql_query.

Any help would greatly be appreciated.

--Alan Flum
Celestial Graphics Inc.

Anon

Without looking at the manual, I think you are passing the wrong params into mysql_query().

Also, look at the "get started" pages here for info on how to handle error checking with databases.

Anon

Thanks for the reply. Actually, the original query was more like:

$addrow = "INSERT INTO test (name1, name2) VALUES ('$name1', '$name2')";
$result= mysql_query($addrow, $connection) or die("Can't Add Selections to Test Table");

As I indicated, its not only a problem in my script. Other php scripts running on the same server also have this problem. PhpMyAdmin will also create a similar error within its script. Everything worked fine until we did the upgrade.

--Alan

Anon

I have a hard time to rollback transaction
I'm using Access 97 database

$connection_id=odbc_connection("DSN","","");
//(succed)

$result=$odbc_exec($connection_id,"Select * from table");
odbc_result_all($connection_id);
//It prints contents of my table 5 rows

$result=$odbc_exec($connection_id,"Delete * from table where....");
//it deletes 1 row

odbc_rollback($connection_id);
//it has to abort my transaction
//also if $suc=odbc_rollback($connection_id);
//then echo "$suc";
//it prints 1

$result=$odbc_exec($connection_id,"Select * from table");
//I have only 4 rows not 5

Any help.