Return to Snippet

Revision: 40718
at February 6, 2011 03:09 by AzNGTX2


Initial Code
<?php 

//mysql database connection 
$dbhost='Database Host'; 
$dbuser='Your Username'; 
$dbpass='Your Password'; 
$dbtable='Your Table Name'; 

mysql_connect("$dbhost", "$dbuser", "$dbpass") or die("Could not connect."); 
mysql_select_db("$dbtable") or die("Table could not be selected."); 

//Submit Form 
if(isset($_POST['submit'])) 
{ 
   $yourpost=$_POST['yourpost']; 
   $blogid=$_POST['blogid']; 

   if(strlen($yourpost)<1) 
   { 
      print "You did not enter a message."; //no message entered 
   } 
      elseif($blogid != '') { 
        $qry = "SELECT * FROM kyproject_blog WHERE blogid='$blogid'"; 
        $result = mysql_query($qry); 
        if($result) { 
            if(mysql_num_rows($result) > 0) { 
                 
                echo 'Blog ID is already in use.'; 
            } 
            @mysql_free_result($result); 
        } 
        else { 
            die("Query failed"); 
        } 
   }else{ 

      $displaytime=date("F j, Y, g:i A"); 
       
      //SQL Queries 
      $insertpost="INSERT INTO kyproject_blog(blogid, message, date) values('$blogid','$yourpost','$displaytime')"; 
      mysql_query($insertpost) or die("Could not insert post"); //insert post       
      print "Blog entry added. View it <a href='blog.php?id=$blogid'>here</a>."; 
   } 

}else{ 
    
   print "<fieldset> 
             <form action='' method='post' id='ticketform'> 
          <p><label>Blog ID(Identifier Name):</label> 
          <input name='blogid' id='textarea' type='text' /></p> 
          <p><label>Blog Entry:</label> 
          <textarea cols='50' rows='11' name='yourpost' id='message' class='bbeditor'></textarea></p> 
          <p><input name='submit' class='formbutton' value='Submit' type='submit' /></p> 
          </form>"; 
} 
print "</td></tr></tbody></table> 
        </fieldset>"; 
?>

Initial URL

                                

Initial Description

                                

Initial Title
PHP Blog: Insert2.php

Initial Tags

                                

Initial Language
PHP