php - Insert data in mysql table
I have problem with inserting data in mysql by PHP code
I use a WAMP server for executing my codes and my database collection is utf8_persian_ci
When I run the code in PHP, using the code below, it doesn't work.
PHP Code:
$query="insert into lesson_form(lessid,teachid,tvahed,maghta,snazari,samali,skargahi,zamantashkil,ahdaf,masli,mfarei,mosharekat,tamrinat,project,bfaaliat,bmidterm,bfinal)
values ($lessid,$teacherid,$tvahed,$maghta,$snazari,$samali,$skargahi,$zaman,$ahdaf,$masli,$mfarei,$mosharekat,$tamrinat,$project,$bfaaliat,$bmidterm,$bfinal);";
mysqli_query($con,"set names 'utf8'");
$run_query=mysqli_query($con,$query);
if (mysqli_query($con, $query))
{
echo "New record created successfully";
}
else
{
echo "Error: " . "<br>" . mysqli_error($con);
}
But when I execute the MySQL statement in PhpMyAdmin page it works:
MySQL Statement
INSERT INTO lesson_form(lessid,teachid,tvahed,maghta, snazari,samali,skargahi,zamantashkil,ahdaf,masli,mfarei, mosharekat,tamrinat,project,bfaaliat,bmidterm,bfinal) values (101,27401,3,'کارش',48,48, 48,'شنبه','حضو','www.w3school.com','جز','tamrinat', '','',12,4,4)
Answer
Solution:
Hope this will help :)