Jump to content

PHP and mySQL issue


lucasd

Recommended Posts

Ive been given an existing website created in PHP which need to be connect to a mySQL database.

 

So far i have created the table and field in phpmyadmin and editing the setting.php file with the database information

when i test the site at www.5thgrader.com.au  i get the error "Could not query:Table '5thgrader_dbbackup._applicants_applicants' doesn't exist". The page is a registration form, from which all the fields are filled out and the infomation saved to a mySQL database for future reference.

 

I did not write this site and am reasonably new to PHP and SQL, from what i can see the backup database is causing the issue.

 

I have added the code from the functions.php and setting.php files. Feel free to login to phpmyadmin and check the database for yourself as im not sure where i im going wrong.

 

The server uses mySQL 5 and php 5.

 

the fuctions.php code as follows:

 

<?php
function textField($fieldName, $fieldTitle, $required = 0, $fieldValue = "") {
   $result = '';
   $result .= '<p><label for="';
   $result .= $fieldName . '-field"';
   $result .= '>';
   $result .= $fieldTitle;
   if ($required > 0) {
         $result .= '*';
      }
   $result .= '</label> <input id="';
   $result .= $fieldName . '-field" name="';
   $result .= $fieldName . '" title="';
   $result .= $fieldTitle . '" value="';
   $result .= $fieldValue . '" /></p>';
   
   return $result;
}

function textarea($fieldName, $fieldTitle, $required = 0, $fieldValue = "") {
   $result = '';
   $result .= '<p><label for="';
   $result .= $fieldName . '-field"';
   $result .= '>';
   $result .= $fieldTitle;
   if ($required > 0) {
         $result .= '*';
      }
   $result .= '</label> <textarea id="';
   $result .= $fieldName . '-field" name="';
   $result .= $fieldName . '" title="';
   $result .= $fieldTitle . '" ';
   $result .= 'rows="3" cols="20">';
   $result .= $fieldValue;
   $result .= '</textarea></p>';
   
   return $result;
}

function yesNo($fieldName, $fieldTitle, $required = 0, $fieldValue = "") {
   $result = '';
   $result .= '<p><label for="';
   $result .= $fieldName . '-field" ';
   $result .= '>';
   $result .= $fieldTitle;
   if ($required > 0) {
         $result .= '*';
      }
   $result .= '</label> <select name="';
   $result .= $fieldName . '" ';
   $result .= 'id="';
   $result .= $fieldName . '-field" ';  
   $result .= 'title="';
   $result .= $fieldTitle . '">';
   $result .= '<option value="" ';
   $result .= '>Select</option>';
   $result .= '<option value="Yes" ';
   if ($fieldValue == "Yes") {
      $result .= 'selected="selected" ';
   }
   $result .= '>Yes</option>';
   $result .= '<option value="No" ';
   if ($fieldValue == "No") {
      $result .= 'selected="selected" ';
   }
   $result .= '>No</option>';
   $result .= '</select></p>';
   
   return $result;
}

function connectToDb($bu = NULL) {
   global $db_server, $db_name, $db_username, $db_password, $db_tableprefix;
   global $dbbu_server, $dbbu_name, $dbbu_username, $dbbu_password;

//   if ($bu = "useBackup") {
      $link = mysql_connect($dbbu_server, $dbbu_username, $dbbu_password, 1);
//   }
//   else {
//      $link = mysql_connect($db_server, $db_username, $db_password, 1);
//   }

   if (!$link) {
      die('Could not connect to server: ' . mysql_error());
   }
   //echo 'Connected successfully';

//   if ($bu = "useBackup") {
      $db_selected = mysql_select_db($dbbu_name, $link);
//   }
//   else {
//      $db_selected = mysql_select_db($db_name, $link);
//   }
   
   




   if (!$db_selected) {
      die ('Could not select databse : ' . mysql_error());
   }

   return $link;
   
}

function disconnectDb ($linkID) {
   mysql_close($linkID);
}

function writeData ($formData) {
   global $db_server, $db_name, $db_username, $db_password, $db_tableprefix;

   $link = connectToDb();
   
   $sql = "";
   $sql .= "INSERT INTO " . $db_tableprefix . "_applicants ( ";
   $sql .= "firstname , surname , dob , phonebh , phoneah , email , ";
   $sql .= "street , suburb , state , pcode , occupation , hobbies , ";
   $sql .= "children , childrendets , resident , priorshow , priorshowdets , ";
   $sql .= "crime , crimedets , restorder , restorderdets , bank , bankdets , ";
   $sql .= "negative , negativedets , friends , auddate, education, terms, submitdate, contwhy ) ";
   $sql .= "VALUES ( ";
   $sql .= "'" . mysql_real_escape_string($formData["firstname"]) . "', ";
   $sql .= "'" . mysql_real_escape_string($formData["surname"]) . "', ";
   $sql .= "'" . mysql_real_escape_string($formData["dobyear"]) . "-"; // date of birth   <-- ######################################## THIS
   $sql .= mysql_real_escape_string($formData["dobmonth"]) . "-"; // date of birth   <-- ######################################## THIS
   $sql .= mysql_real_escape_string($formData["dobday"]) . "', "; // date of birth   <-- ######################################## THIS
   $sql .= "'" . mysql_real_escape_string($formData["phonebh"]) . "', ";
   $sql .= "'" . mysql_real_escape_string($formData["phoneah"]) . "', ";
   $sql .= "'" . mysql_real_escape_string($formData["email"]) . "', "; //email
   $sql .= "'" . mysql_real_escape_string($formData["address"]) . "', ";
   $sql .= "'" . mysql_real_escape_string($formData["suburb"]) . "', ";
   $sql .= "'" . mysql_real_escape_string($formData["state"]) . "', ";
   $sql .= "'" . mysql_real_escape_string($formData["pcode"]) . "', "; // post code
   $sql .= "'" . mysql_real_escape_string($formData["occupation"]) . "', ";
   $sql .= "'" . mysql_real_escape_string($formData["hobbies"]) . "' , ";
   $sql .= "'" . mysql_real_escape_string($formData["children"]) . "', "; //children
   $sql .= "'" . mysql_real_escape_string($formData["manychildren"]) . "' , "; // children dets
   $sql .= "'" . mysql_real_escape_string($formData["resident"]) . "', "; // resident
   $sql .= "'" . mysql_real_escape_string($formData["priorgameshow"]) . "', "; // prior show
   $sql .= "'" . mysql_real_escape_string($formData["whichshows"]) . "' , "; //prior show dets
   $sql .= "'" . mysql_real_escape_string($formData["crime"]) . "', "; //crime
   $sql .= "'" . mysql_real_escape_string($formData["crimedetails"]) . "' , "; // crime dets
   $sql .= "'" . mysql_real_escape_string($formData["restraining"]) . "', "; //rest order
   $sql .= "'" . mysql_real_escape_string($formData["restdetails"]) . "' , "; // rest order dets
   $sql .= "'" . mysql_real_escape_string($formData["bankruptcy"]) . "', "; // bank
   $sql .= "'" . mysql_real_escape_string($formData["bankdetails"]) . "' , "; //bank dets
   $sql .= "'" . mysql_real_escape_string($formData["negativeeffect"]) . "', "; //negative
   $sql .= "'" . mysql_real_escape_string($formData["negativedetails"]) . "' , "; // negative dets
   $sql .= "'" . mysql_real_escape_string($formData["friends"]) . "' , "; // friends
   $sql .= "'" . mysql_real_escape_string($formData["audition"]) . "' , "; // audition
   $sql .= "'" . mysql_real_escape_string($formData["education"]) . "', "; // education
   $sql .= "'" . mysql_real_escape_string($formData["terms"]) . "', "; // terms
   $sql .= "'" . mysql_real_escape_string(date("Y-m-d")) . "', "; // submit date
   $sql .= "'" . mysql_real_escape_string($formData["contwhy"]) . "'"; // contwhy
   $sql .= ")";
   
   // echo $sql;
   
   $result = mysql_query($sql, $link);
   if (!$result) {
      die('<br>Could not query:' . mysql_error());
   }

   $insertID = mysql_insert_id($link);
   // echo "<br>id: $insertID";
   
   disconnectDb($link);
   
/*   $link = connectToDb("useBackup"); //put data in backup database
   $result = mysql_query($sql, $link);
   if (!$result) {
      die('<br>Could not query:' . mysql_error());
   }
   disconnectDb($link);
*/  
}

function checkData ($formData) {
   $errors = "";
   
   if ($formData["firstname"] == "") {
      $errors .= "<p>Please enter your first name</p>";
   }
   
   if ($formData["surname"] == "") {
      $errors .= "<p>Please enter your surname</p>";
   }
         
   if ($formData["dobday"] == "") {
      $errors .= "<p>Please enter your full date of birth</p>";
   }
   elseif ($formData["dobyear"] == "") {
      $errors .= "<p>Please enter your full date of birth</p>";
   }
   
   if ($formData["phonebh"] == "") {
      $errors .= "<p>Please enter your business hours contact number</p>";
   }
   
   if ($formData["phoneah"] == "") {
      $errors .= "<p>Please enter your after hours contact number</p>";
   }
   
   if ($formData["address"] == "") {
      $errors .= "<p>Please enter your full home address</p>";
   }
   elseif ($formData["suburb"] == "") {
      $errors .= "<p>Please enter your full home address</p>";
   }
   elseif ($formData["pcode"] == "") {
      $errors .= "<p>Please enter your full home address</p>";
   }
   elseif (!is_numeric($formData["pcode"])) {
      $errors .= "<p>Please check the post code you entered</p>";
   }

   if ($formData["occupation"] == "") {
      $errors .= "<p>Please enter your Occupation</p>";
   }

   if ($formData["resident"] == "") {
      $errors .= "<p>Please enter if you are/are not an Australian Resident</p>";
   }
   
   if ($formData["education"] == "") {
      $errors .= "<p>Please tell us your highest level of education</p>";
   }
   
   if ($formData["priorgameshow"] == "") {
      $errors .= "<p>Please tell us if you've been on a game show previously</p>";
   }
   
   if (($formData["priorgameshow"] == "Yes") AND ($formData["whichshows"] == "")) {
      $errors .= "<p>Please enter which game shows you've been on previously</p>";
   }


   
   if ($formData["crime"] == "") {
      $errors .= "<p>Please tell us if you've ever been arrested, charged or convicted of a crime of any type</p>";
   }
   
   if (($formData["crime"] == "Yes") AND ($formData["crimedetails"] == "")) {
      $errors .= "<p>Please provide details of which crime and when</p>";
   }


   
   if ($formData["restraining"] == "") {
      $errors .= "<p>Please tell us if you've ever had a temporary restraining order issued against you</p>";
   }
   
   if (($formData["restraining"] == "Yes") AND ($formData["restdetails"] == "")) {
      $errors .= "<p>Please provide details the temporary restraining order issued against you</p>";
   }


   
   if ($formData["bankruptcy"] == "") {
      $errors .= "<p>Please tell us if you've ever filed for bankruptcy</p>";
   }
   
   if (($formData["bankruptcy"] == "Yes") AND ($formData["bankdetails"] == "")) {
      $errors .= "<p>Please provide details of your bankruptcy</p>";
   }


   
   if ($formData["negativeeffect"] == "") {
      $errors .= "<p>Please tell us if you've ever done or been involved in anything that could reflect negatively on either you or the series</p>";
   }
   
   if (($formData["negativeeffect"] == "Yes") AND ($formData["negativedetails"] == "")) {
      $errors .= "<p>Please provide details what you've been involved in that could reflect negatively on either you or the series</p>";
   }

   if ($formData["contwhy"] == "") {
      $errors .= "<p>Please tell why you want to be a game show contestant</p>";
   }
   

   
   if ($formData["audition"] == "") {
      $errors .= "<p>Please select city in which you'd prefer to audition</p>";
   }
   

   if ($formData["terms"] != "Yes") {
      $errors .= "<p>You must agree to the terms above to apply for the series</p>";
   }
   
   return $errors;

}

?>

 

------------------------------------------------------------

 

And the setting.php code as follows:

 

<?php

putenv("TZ=Australia/Melbourne");


$db_name = "5thgrader_db01";
$dbbu_name = "5thgrader_dbbackup";
$db_username = "5thgrader";
$dbbu_username = "5thgrader";
$db_password = "5thgrader1234";
$dbbu_password = $db_password;
$db_server = "mysql.luderemedia.com";
$dbbu_server = "mysql.luderemedia.com";
$db_tableprefix = "_applicants";

#Deal with magic quotes
function stripslashes_recursive($var) {
    return (is_array($var) ? array_map('stripslashes_recursive', $var) : stripslashes($var));
}
if (get_magic_quotes_gpc()) {
    $_GET = stripslashes_recursive($_GET);
    $_POST = stripslashes_recursive($_POST);
    $_COOKIE = stripslashes_recursive($_COOKIE);
}


?>

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

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.   Restore formatting

  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.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.