Jump to content
Larry Ullman's Book Forums

Recommended Posts

code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8" />
    <title>Add a Blog Entry</title>
</head>
<body>
<h1>Add a Blog Entry</h1>
<?php // Script 12.5 - add_entry.php
/* This script adds a blog entry to the database. */

if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Handle the form.

    // Connect and select:
    $dbc = mysql_connect('localhost', 'root', 'musica');
    mysql_select_db('myblog', $dbc);
   
    // Validate the form data:
    $problem = FALSE;
    if (!empty($_POST['title']) && !empty($_POST['entry'])) {
        $title = trim(strip_tags($_POST['title']));
        $entry = trim(strip_tags($_POST['entry']));
    } else {
        print '<p style="color: red;">Please submit both a title and an entry.</p>';
        $problem = TRUE;
    }

    if (!$problem) {

        // Define the query:
        $query = "INSERT INTO entries (entry_id, title, entry, date_entered) VALUES (0, '$title', '$entry', NOW())";
       
        // Execute the query:
        if (@mysql_query($query, $dbc)) {
            print '<p>The blog entry has been added!</p>';
        } else {
            print '<p style="color: red;">Could not add the entry because:<br />' . mysql_error($dbc) . '.</p><p>The query being run was: ' . $query . '</p>';
        }
   
    } // No problem!

    mysql_close($dbc); // Close the connection.
   
} // End of form submission IF.

// Display the form:
?>
<form action="add_entry.php" method="post">
    <p>Entry Title: <input type="text" name="title" size="40" maxsize="100" /></p>
    <p>Entry Text: <textarea name="entry" cols="40" rows="5"></textarea></p>
    <input type="submit" name="submit" value="Post This Entry!" />
</form>
</body>
</html>

 

iI'm getting the folowing output, what am i doing wrong?

Add a Blog Entry

Please submit both a title and an entry.'; $problem = TRUE; } if (!$problem) { // Define the query: $query = "INSERT INTO entries (entry_id, title, entry, date_entered) VALUES (0, '$title', '$entry', NOW())"; // Execute the query: if (@mysql_query($query, $dbc)) { print '

The blog entry has been added!

'; } else { print '

Could not add the entry because:
' . mysql_error($dbc) . '.

The query being run was: ' . $query . '

'; } } // No problem! mysql_close($dbc); // Close the connection. } // End of form submission IF. // Display the form: ?>

Entry Title:

Entry Text:

Share this post


Link to post
Share on other sites

Hi

 

I cut and pasted your code and ran it on my localhost and it worked fine. What's your host set up?

 

Incidentally, the functions you're using are outdated. Look up the the mysqli extensions for interacting with the database. They are very similar to the mysql functions you're using but you'll be learning something that is current.

 

Also you want to separate the styling from the html - but perhaps that is your next project.

 

Share this post


Link to post
Share on other sites

You can start by looking in the php manual. You can use the procedural or the object oriented functions. Basically every mysql function you've used can be replaced by mysqli e.g. for mysql_query use mysqli_query. The main differences are the parameters each takes so you'll need to confirm what parameters are required and in what order.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...