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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151
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>