查询未插入数据库

Question

I am trying to insert to my database. I have tried pasting the query into MySQL Workbench and it works, but when I run the page it doesn't work.

echo "<b>DISTRICT</b></br>";
echo "crime volume : " . $crimeVolume. "<br>";
echo "population : " . $population. "<br>";
echo "crime rate : " . $crimeRate=round(($crimeVolume/($population/100000)),2) . " <br>";
echo "crime efficiency / crime clearance efficiency : " . $efficiency=($SolvedCases/$crimeVolume) ." <br>";
echo "use of force : " . $useofForce . " incidents<br>";
echo "drug seizures : " . $numdrug . " (grams/seizures)<br>";
echo "firearm seizures : " . $firearmSeizures=round(($numfire/$stationFire),2) . " <br>";
echo "<br>";
require_once('../../mysqlConnector/mysql_connect.php');
$query2= "INSERT INTO computation (crimeVolume,crimeRate,crimeSolutionEfficiency,useofForce,drugSeizures,firearmsSeizures,stationID) 
VALUES ('{$crimeVolume}','{$crimeRate}','{$efficiency}','{$useofForce}','{$numdrug}','{$firearmSeizures}','0');";
echo $query2;
$result=mysqli_query($dbc,$query2);
echo $result;

Answer 1

Please try this example, by setting your database connection details and it should work flawless.

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); }

// Perform query
$result mysqli_query($con,"INSERT INTO computation (crimeVolume,crimeRate,crimeSolutionEfficiency,useofForce,drugSeizures,firearmsSeizures,stationID) 
VALUES ('".$crimeVolume."','".$crimeRate."','".$efficiency."','".$useofForce."','".$numdrug."','".$firearmSeizures."','0')");

// Print result
print_r($result);

// Close connection
mysqli_close($con);
?>

Note that this is not the final solution, you are better off using a proper CLASS that has some filtering and error checking as well. ( why not a framework ? ).

I hope it helps your case.