database - mySql error connecting DB -

database - mySql error connecting DB -

i maintain getting error when im trying insert database. "mysqli_select_db() expects 2 parameters, 1 given in"

$host="localhost"; // host name $username="root"; // mysql username $password=""; // mysql password $db_name="#test"; // database name $tbl_name="appoint"; // table name // connect server , select databse. $con = mysqli_connect("$host", "$username", "$password")or die("cannot connect"); if(! $con ) { die('could not connect: ' . mysql_error()); } $customer=$_post['name']; $assist=$_post['assisstant']; $service=$_post['service']; $date=$_post['date']; $time=$_post['time']; $sql="insert $tbl_name (cus_name, emp_name, date, time, service) values ('$customer', '$assist', '$date', '$time', '$service');"; mysqli_select_db("$db_name")or die("cannot select db"); $retval = mysql_query( $sql, $con ); if(! $retval ) { die('could not come in data: ' . mysql_error()); } echo "entered info successfully\n"; mysql_close($con);

you're using procedurally.

from the docs;

bool mysqli_select_db ( mysqli $link , string $dbname )

so;

mysqli_select_db($con, $db_name)or die("cannot select db");

mysql database