www.webdeveloper.com
Results 1 to 3 of 3

Thread: [RESOLVED] Really need help on a Guestbook

  1. #1
    Join Date
    Jul 2012
    Location
    Scotland
    Posts
    6

    resolved [RESOLVED] Really need help on a Guestbook

    Hi. I just started to learn about PHP and MySQL and I've recently been trying to code my own guestbook from this tutorial "http://www.phpeasystep.com/workshopview.php?id=15".

    The tutorial's actually been going fine until I hit this problem that a newbie like can't fix... If you go onto the guestbook here and try to submit text in the fields, you'll notice that if you view the guestbook afterwards, then no text will have been submitted. What's weird is that but the datetime and ID have been submitted...

    Not a clue why that's happening...

    Anyway, what I've done is that I ran this sql query from the tutorial on sqlbuddy
    and exported it using this http://mysqlexport.zymichost.com/

    Code:
    CREATE TABLE `guestbook` (
    `id` int(4) NOT NULL auto_increment,
    `name` varchar(65) NOT NULL default '',
    `email` varchar(65) NOT NULL default '',
    `comment` longtext NOT NULL,
    `datetime` varchar(65) NOT NULL default '',
    PRIMARY KEY (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    I then loaded the .sql file onto my site using Filezilla.

    After that I made the php files.

    guestbook.php
    Code:
    <table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
    <tr>
    <td><strong>Test Sign Guestbook </strong></td>
    </tr>
    </table>
    <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
    <tr>
    <form id="form1" name="form1" method="post" action="addguestbook.php">
    <td>
    <table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
    <tr>
    <td width="117">Name</td>
    <td width="14">:</td>
    <td width="357"><input name="name" type="text" id="name" size="40" /></td>
    </tr>
    <tr>
    <td>Email</td>
    <td>:</td>
    <td><input name="email" type="text" id="email" size="40" /></td>
    </tr>
    <tr>
    <td valign="top">Comment</td>
    <td valign="top">:</td>
    <td><textarea name="comment" cols="40" rows="3" id="comment"></textarea></td>
    </tr>
    <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td><input type="submit" name="Submit" value="Submit" /> <input type="reset" name="Submit2" value="Reset" /></td>
    </tr>
    </table>
    </td>
    </form>
    </tr>
    </table>
    <table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
    <tr>
    <td><strong><a href="viewguestbook.php">View Guestbook</a> </strong></td>
    </tr>
    </table>
    addguestbook.php
    Code:
    <?php
    $host="localhost"; // Host name 
    $username=""; // Mysql username 
    $password=""; // Mysql password 
    $db_name="test"; // Database name 
    $tbl_name="guestbook"; // Table name 
    
    // Connect to server and select database.
    mysql_connect("$host", "$username", "$password")or die("cannot connect server "); 
    mysql_select_db("$db_name")or die("cannot select DB");
    
    $datetime=date("y-m-d h:i:s"); //date time
    
    $sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name', '$email', '$comment', '$datetime')";
    $result=mysql_query($sql);
    
    //check if query successful 
    if($result){
    echo "Successful";
    echo "<BR>";
    
    // link to view guestbook page
    echo "<a href='viewguestbook.php'>View guestbook</a>";
    }
    
    else {
    echo "ERROR";
    }
    mysql_close();
    ?>
    And viewguestbook.php

    Code:
    <table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
    <tr>
    <td><strong>View Guestbook | <a href="guestbook.php">Sign Guestbook</a> </strong></td>
    </tr>
    </table>
    <br>
    
    <?php
    
    $host="localhost"; // Host name 
    $username=""; // Mysql username 
    $password=""; // Mysql password 
    $db_name="test"; // Database name 
    $tbl_name="guestbook"; // Table name 
    
    // Connect to server and select database.
    mysql_connect("$host", "$username", "$password")or die("cannot connect server "); 
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * FROM $tbl_name";
    $result=mysql_query($sql);
    while($rows=mysql_fetch_array($result)){
    ?>
    
    <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
    <tr>
    <td><table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
    <tr>
    <td>ID</td>
    <td>:</td>
    <td><? echo $rows['id']; ?></td>
    </tr>
    <tr>
    <td width="117">Name</td>
    <td width="14">:</td>
    <td width="357"><? echo $rows['name']; ?></td>
    </tr>
    <tr>
    <td>Email</td>
    <td>:</td>
    <td><? echo $rows['email']; ?></td>
    </tr>
    <tr>
    <td valign="top">Comment</td>
    <td valign="top">:</td>
    <td><? echo $rows['comment']; ?></td>
    </tr>
    <tr>
    <td valign="top">Date/Time </td>
    <td valign="top">:</td>
    <td><? echo $rows['datetime']; ?></td>
    </tr>
    </table></td>
    </tr>
    </table>
    
    <?php
    }
    mysql_close(); //close database
    ?>
    Is it something that I've done wrong or has the tutorial author made a mistake somewhere?

    Any help or advice will be much appreciated.

    Thank you in advance

  2. #2
    Join Date
    Jul 2012
    Location
    Scotland
    Posts
    6

    resolved

    Hi, I'm just updating that I found the problem and used this person's solution http://www.zymic.com/forum/index.php...t=#entry112794 and now it works a treat

  3. #3
    Join Date
    Jul 2012
    Posts
    2
    OMG! OMG! Your a King. thank you *

    I had one foot out the window about to jump
    and you save me, So I thx you for this

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles