Home arrow PHP arrow Page 8 - PHP and PostgreSQL

A Well-Formed Idea - PHP

When you talk about PHP and databases, people tend to assumeyou're talking about MySQL. But hang on to your horses - difficultthough it may be to believe, PHP does include support for a number ofother databases. One of them is PostgreSQL, the *other* open-sourcedatabase - and this article tells you everything you need to know aboutusing it with PHP.

  1. PHP and PostgreSQL
  2. Getting Started
  3. First Steps
  4. Digging Deeper
  5. Different Strokes
  6. Rolling Around
  7. Catching Mistakes
  8. A Well-Formed Idea
  9. Surfing The Web
By: Vikram Vaswani, (c) Melonfire
Rating: starstarstarstarstar / 52
May 01, 2002

print this article


Finally, how about one more example to wrap things up? This next script contains a form which can be used to enter new addresses into the table, together with a form processor that actually creates and executes the INSERT statement.

<html> <head><basefont face="Arial"></head> <body> <h2>Address Book</h2> <? // form not yet submitted // display form if (!$submit) { ?> <form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST"> Name:<br> <input name="name" type="text" size="50"> <p> Address:<br> <textarea name="address" rows="6" cols="40"></textarea> <p> Tel:<br> <input name="tel" type="text" size="10"> <p> Email:<br> <input name="email" type="text" size="30"> <p> <input type="submit" name="submit" value="Add"> </form> <? } else { // form submitted // prepare to insert data // database access parameters // alter this as per your configuration $host = "localhost"; $user = "postgres"; $pass = "postgres"; $db = "test"; // open a connection to the database server $connection = pg_connect("host=$host dbname=$db user=$user password=$pass"); if (!$connection) { die("Could not open connection to database server"); } // error checks on form submission go here // generate and execute a query $query = "INSERT INTO addressbook VALUES (nextval('addressbook_id_seq'), '$name', '$address', '$tel', '$email')"; $result = pg_query($connection, $query) or die("Error in query: $query. " . pg_last_error($connection)); echo "Data successfully added."; // close database connection pg_close($connection); } ?> </body> </html>
As you can see, this script is broken up into two main sections - the appropriate section is displayed depending on whether or not the form has been submitted.

The first part merely displays an HTML form, with fields corresponding to the columns in the "addressbook" table. Once the user enters data into these fields, the same script is called again; this time, the second half will get executed. An SQL query is generated from the data entered into the form, and this query is executed using the pg_query() function you've become familiar with. A success message is displayed once the data has been successfully INSERTed.

If you're familiar with building MySQL-based Web applications with PHP, the procedure above should be familiar to you - the only difference lies in the functions used to communicate with the database server.

>>> More PHP Articles          >>> More By Vikram Vaswani, (c) Melonfire

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates


Dev Shed Tutorial Topics: