Happy Codings - Programming Code Examples
Html Css Web Design Sample Codes CPlusPlus Programming Sample Codes JavaScript Programming Sample Codes C Programming Sample Codes CSharp Programming Sample Codes Java Programming Sample Codes Php Programming Sample Codes Visual Basic Programming Sample Codes

Php Programming Code Examples

Php > Databases Code Examples

A very simple postgreSQL guestbook script

A very simple postgreSQL guestbook script //this is a very simple guestbook example, i found that tere are not that many //postgreSQL examples out there for the very beginners, so here is one //it does not limit number of records per page, it does not give ou administration //features(for this i have another script - maybe i'll post it here as well later) //the table is: /*CREATE TABLE gb_record ( id int4, name varchar, email varchar, location varchar, comments varchar, url varchar ) ; */ <? //we do want a proper header for our file, don't we?! echo "<HTML><HEAD><TITLE>Guestbook Example</TITLE></HEAD><BODY>"; // connect to the database, since each part of this uses //the connection, we can just connect once at the beginning $connection=pg_connect("host=yourhos dbname=dbname user=user password=**** port=5432"); if (!$connection) { echo "Could not connect to the database"; exit; } // if the query string (guestbook.php3?stuff) is add, then present the form to add entries if ($argv[0] == "add"): ?> <P>Please take a moment to share your comments with us.</p> <P> <FORM NAME="guestbook" ACTION="<?echo $PHP_SELF?>" METHOD=POST> <INPUT TYPE=hidden NAME=cmd VALUE=send> Your Name: <INPUT TYPE=text NAME=name> <BR>Your E-mail address: <INPUT TYPE=text NAME=email> <BR>Your Web Page address: <INPUT TYPE=text NAME=url> <BR>Where are you from: <INPUT TYPE=text NAME=location> <BR>Comments: <BR><TEXTAREA NAME=comments COLS=60 ROWS=6></TEXTAREA> <CENTER><INPUT TYPE=submit VALUE=Submit><INPUT TYPE=reset VALUE=Clear></CENTER> </FORM> <? // if the query string is view, the fetch the guestbook entries elseif ($argv[0] == "view"): echo "<H2>View Guestbook Entries</H2>"; $sql='select name, email,url,location, comments from gb_record order by id desc'; // get stuff from the database // $result = mysql_query( "select name, email, url, job, location, comments from guestbook"); $result=pg_exec($connection, $sql); if (!$result) { echo "Got no results"; exit; } // fetch the rows one at atime, and then echo the data to the page //we also want to know the number of the records in the database, so that we could //display the exact number, and it didn't give us a warning: can not get to the next //record message $r1 = pg_exec($connection, "select max(id) from gb_record"); $row1 = pg_fetch_row($r1,0); $num1 = $row1[0]; pg_freeresult(r1); $r=0; while ($r<$num1) { $row = pg_fetch_array($result,$r); echo "<HR>"; //we could have these fields in the echo already, but it does not access // array elements correctly from within "" $mto=$row[1]; $nam=$row[0]; $urrl=$row[2]; $loc=$row[3]; echo "<p align=justify><BR><B>Message by:</B> <A HREF="mailto:$mto\">$nam</A>"; echo "<BR><B>Web Page:</B> <A HREF=\"$urrl\">$urrl</A>"; echo "<BR><B>From:</B> $loc"; echo "<BR><B>Comments:</B>"; echo "<BR></p>"; echo $row[4]; $r++; } echo "<br><H3><A HREF=\"$PHP_SELF?add\">Add an entry to the guestbook</A></H3>"; pg_freeresult($result); // if we're submitting a guestbook entry elseif (isset($cmd) && $cmd == "send"): // mail guestbook entry to the webmaster mail ("[email protected]", "guestbook entry", "Comment: $comments\nURL: $url \nLocation: $location \n", "From: $name <$email>"); // postgreSQL really hates it when you try to put things with ' or " // characters into a database $result = pg_exec($connection, "select max(id) from gb_record"); $row = pg_fetch_row($result,0); $num = $row[0]; $num++; $comments = addslashes("$comments"); pg_freeresult($result); //we want to increment the id by 1 pg_exec($connection, "insert into gb_record values ($num,'$name', '$email', '$location', '$comments', '$url');"); // insert the data into the database ?> <h1>Thank you!</h1><br>We really appreciate your cooperation, to continue browsing the web-site <a href="index.html">click here</a>.<br> <? else: // lastly, we must be at the main page. Get the number of entries in the guestbook //so we can tell the visitor how many there are $result = pg_exec($connection, "select max(id) from gb_record"); $row = pg_fetch_row($result,0); $num = $row[0]; if ($num == "") { $entry = "There are currently no entries"; } elseif ($num == "1") { $entry = "There is currently 1 entry"; } else { $entry = "There are currently $num entries"; } echo "<h1>Welcome to the <I>Count Zero</I> guestbook.<br> $entry in the guestbook.</h1>"; echo "<H3><A HREF=\"$PHP_SELF?add\">Add an entry to the guestbook</A></H3>"; echo "<H3><A HREF=\"$PHP_SELF?view\">View entries in the guestbook</A></H3>"; endif; pg_freeresult($result); pg_close($connection); ?> </BODY> </HTML>