html - Cant connect php to mysql -
new php , connecting form attributes php connect godaddy mysql. every attempt ends in blank screen no error messages. there syntax errors jump out? sublime text wont register php syntax, thats problem time. may need call godaddy support? password has been removed privacy.
<?php $servername = "localhost"; $dbusername = "jaysenhenderson"; $dbpassword = "xxxxx"; $dbname = "eotdsurvey"; $con = new mysqli ($servername, $dbusername, $dbpassword, $dbname); mysql_select_db('eotdsurvey', $con) // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo("connected successfully"); $_post['bi1'] $_post['bi2'] $_post['bi3'] $_post['bi4'] $_post['bi5'] $_post['bi6'] $_post['bi7'] $_post['bi8'] $_post['bi9'] $_post['bi10'] $_post['bi11'] $_post['bi12'] $_post['bi13'] $_post['bi14'] $_post['bi15'] $sql = "insert survey1(bi1)" $sql = "insert survey1(bi2)" $sql = "insert survey1(bi3)" $sql = "insert survey1(bi4)" $sql = "insert survey1(bi5)" $sql = "insert survey1(bi6)" $sql = "insert survey1(bi7)" $sql = "insert survey1(bi8)" $sql = "insert survey1(bi9)" $sql = "insert survey1(bi10)" $sql = "insert survey1(bi11)" $sql = "insert survey1(bi12)" $sql = "insert survey1(bi13)" $sql = "insert survey1(bi14)" $sql = "insert survey1(bi15)" if ($conn->query<$sql) === true) { echo "it fucking works."; } else{ echo "didnt workkkkkk"; } $conn->close(); ?>
please connect database this...
$connection = mysqli_connect(db_server,db_user,db_pass); if (!$connection) { die("database connection failed: " . mysqli_error()); } // 2. select database use $db_select = mysqli_select_db($connection, db_name); if (!$db_select) { die("database selection failed: " . mysqli_error()); }
and use mysqli_select_db instead of mysql_select_db , insert semi-colon (;) after every line end according php code standard.
Comments
Post a Comment