lucasd Posted March 30, 2009 Share Posted March 30, 2009 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); } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.