Phoenix Network Forums

Well I gues it's usefull for starting to learn.But there are many opensource guestbooks outhere.Look at this one: http://nrg88.4ya.us/page_8_1.html
One of my friends has made it.
It's good if you're a newby in php.

how could i view the queries?

lyndz wrote:how could i view the queries?

What queries do you mean?

Code: Select all

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('','$first','$last','$email','$web','$comment')";
mysql_query($query);


Rommaster wrote:

lyndz wrote:how could i view the queries?

What queries do you mean?

Code: Select all

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('','$first','$last','$email','$web','$comment')";
mysql_query($query);


I mean, how can I view the Signees to the page? I already tried it but, process.php return nothing

lyndz wrote:

Rommaster wrote:

lyndz wrote:how could i view the queries?

What queries do you mean?

Code: Select all

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('','$first','$last','$email','$web','$comment')";
mysql_query($query);


I mean, how can I view the Signees to the page? I already tried it but, process.php return nothing

You will have to create your own query for that.
Example:

SELECT * FROM VALUES;

This will list all the information from the table 'VALUES'. You have to save it into a variable. And print it.(in tables)

[edit] Also process.php is for the user to input data into the guestbook, not for showing the list of messages the guests left behind.

Your forgetting about the people without access to MySQL. Flat file databases are the way foward.

Code: Select all


<form action="guestbook.php" method="post">
Name: <input type="text" name="name"><br>
E-mail: <input type="text" name="email"><br>
Comments: <textarea rows="6" name="comments" cols="27"></textarea>
<input type="Submit" name="submit">
</form>
<br>

<?php

isset($_POST['submit']) ? WriteEntry() : DisplayEntries();

function WriteEntry() {
   if (isset($_POST['name']) && isset($_POST['email']) && isset($_POST['comments'])) {

      str_replace("!", "!", $_POST);
      $string = $_POST['name'] . "!" . $_POST['email'] . "!" . $_POST['comments'] . "\r\n";
      $handle = fopen("guestbook.txt", "ab");
         fwrite($handle, $string);
         fclose($handle);
      DisplayEntries();
   } else {
      print "Please fill in all fields<br>";
      DisplayEntries();
   }
}

function DisplayEntries() {
   $string = @file("guestbook.txt");
   if (!$string) {
      die();
   }
   foreach ($string as $i) {
      trim($i);
      list($name, $email, $comments) = explode("!", $i);
         print "<hr><br><b>Name:</b> " . $name . "<br><b>Email:</b> " . $email . "<br><b>Comments:</b> " . $comments . "<br>";
   }
}

?>   


chiron wrote:Your forgetting about the people without access to MySQL. Flat file databases are the way foward.

Code: Select all


<form action="guestbook.php" method="post">
Name: <input type="text" name="name"><br>
E-mail: <input type="text" name="email"><br>
Comments: <textarea rows="6" name="comments" cols="27"></textarea>
<input type="Submit" name="submit">
</form>
<br>

<?php

isset($_POST['submit']) ? WriteEntry() : DisplayEntries();

function WriteEntry() {
   if (isset($_POST['name']) && isset($_POST['email']) && isset($_POST['comments'])) {

      str_replace("!", "!", $_POST);
      $string = $_POST['name'] . "!" . $_POST['email'] . "!" . $_POST['comments'] . "\r\n";
      $handle = fopen("guestbook.txt", "ab");
         fwrite($handle, $string);
         fclose($handle);
      DisplayEntries();
   } else {
      print "Please fill in all fields<br>";
      DisplayEntries();
   }
}

function DisplayEntries() {
   $string = @file("guestbook.txt");
   if (!$string) {
      die();
   }
   foreach ($string as $i) {
      trim($i);
      list($name, $email, $comments) = explode("!", $i);
         print "<hr><br><b>Name:</b> " . $name . "<br><b>Email:</b> " . $email . "<br><b>Comments:</b> " . $comments . "<br>";
   }
}

?>   


..ok.. I'll try it (no mysql needed..)..

Thanks for the help it is great for beginer like i am in php