Search for a tutorial

[DanW-MHTN]

Could someone point me to a tutorial for using PHP with PostgreSQL?

I have tried the ones at:

http://pgsql.designmagick.com/

and

http://www-it.hive.no/database/pgsql/postgresql-tutorial/index.html

And I can't get the forms in the tutorial's to post data into the database.

Thanks!

[sarahk]

Think carefully about where you are needing the help.

1. The forms just send the data to php <-- there are lots of tutorials for that

2. PHP sends the data to postgres <-- if you can't find a form find a class which does it and learn from the code - even if you rewrite it.

One good trick is to build you sql statement into a variable eg

$sql = "insert into mytable (id, name, age) values (null, '$name', '$age')";

then you can echo out $sql and copy into the postgres front end and check that your code will work.

That proven you can then use php to run the sql statement - using the class, your code etc.