EditLive! 9 Documentation : xt_add.php

<?
 
/******************************************************
 
 xt_add.php -- add a record to the database
 
 Copyright (c) 2005 Ephox Corporation. All rights reserved.
 See license.txt for license agreement
 
******************************************************/
 
// include the database wrapper functions
require_once("./i_database.php");
 
// redirect variable, we don't want to redirect if we have errors
$redirect = TRUE;
 
//Attempt to establish a connection with the database
if (!DBConnect()) {
       print DBError();
       $redirect = FALSE;
} else {
   // Get the POSTed data from the form and escape it for SQL using the function in i_database
   $articleTitle = escape_string($HTTP_POST_VARS["article_title"]);
   $articleStyleElementText = escape_string($HTTP_POST_VARS["ELJApplet1_styles"]);
   $articleBody = escape_string($HTTP_POST_VARS["ELJApplet1"]);
 
   // Insert the POSTed data into the database
   $query = "INSERT INTO articles ( article_title, article_styleElementText, article_body ) "
          . "VALUES ( '$articleTitle', '$articleStyleElementText', '$articleBody' )";
   DBQuery($query);
   if (DBError() != "") {
           print DBError();
           $redirect = FALSE;
   }
 
   // Disconnect is required when updating
   DBDisconnect();
}
 
// redirect if no errors
if($redirect){
    Header("Location: start.php");
}
?>