链接和发送表单值到mysql数据库？

Question

My html code:

<form action="send_post.php" method="post">
    <input type="submit" value="Login" />
</form>

PHP code:

<?php
$con = mysqli_connect("","","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
else
{
// echo('Connected with Mysql');
}
@mysql_select_db("a", $con);// connect to database db_name
if (isset($_POST['Submit']))
{
$email=$_POST['email']; 
 $pass=$_POST['pass']; 
$sql_query="INSERT INTO formdata (email, pass) VALUES('$email', '$pass')";}
?>

Database name: mysql Table name: formdata

Why it is not working? in second line I used 'local host' first but I was receiving error so I removed it.

Answer 1

1. You use the mysqli_ API to connect to your database and then test for errors and try to select a database with the mysql_ API. Pick one and stick to it. (Don't pick mysql_ it is deprecated).
2. You only run the form handling code if there is a Submit data item in the submitted data. You have no form control with name="Submit" so that will never happen.
3. Your form handling code expects there to be email and pass data in the submitted data but your form does not have fields with those names.
4. Constructing an SQL query as a string and storing it in a variable is insufficient to do anything to your database. You have to actually sent it to the database server. That would use mysqli_query with your current approach, but you should switch to prepared statements