Insert multiple rows by one mysql query
Tje123
I'm trying to insert multiple rows by one mysql query.this is my full code.but it's didn't work.it's display error.
$res_name=$_POST['res_name'];
$mail=$_SESSION["email"];
$sql="INSERT INTO opening
(res_id,res_name,email,day,start,end)
VALUES
(NULL,'$res_name','$mail','monday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Tuesday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Wednesday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Thursday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Friday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Saturday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Sunday','00:00:00','00:00:00')";
$result=mysql_query($sql)or die ("Error");
Junius L.
I don't know how you connect to your database but there's nothing wrong with your script. I have tested it with PDO, mysqli_query and mysql_query and it's working fine. below is the code I have used to test.
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "data";
$con = mysql_connect($servername, $username, $password) or
die("Could not connect: " . mysql_error());
mysql_select_db($dbname);
$res_name="JHB";
$mail="[email protected]";
$sql="INSERT INTO opening
(res_id,res_name,email,day,start,end)
VALUES
(NULL,'$res_name','$mail','monday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Tuesday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Wednesday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Thursday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Friday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Saturday','00:00:00','00:00:00'),
(NULL,'$res_name','$mail','Sunday','00:00:00','00:00:00')";
$result = mysql_query($sql);
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
編集
関連記事
Related 関連記事
- 1
Multiple MySQL rows with one form
- 2
MySQL INSERT INTO from PHP://INPUT multiple rows
- 3
How can I insert multiple records in mysql using php at once with one query dynamicaly?
- 4
Python Mysql CREATE and INSERT in one query
- 5
VERTICA insert multiple rows in one statement with named columns
- 6
Insert multiple rows from two tables into one table
- 7
PHP/MySQL; For loop to to insert rows only adds one
- 8
How to insert multiple, increasing by 1, rows to mysql database with php
- 9
PHP - PDO - How to fetch multiple rows with only one query?
- 10
MySql query to get rows with only one connected row
- 11
MySQL query to update multiple rows based on a column using php
- 12
MYSQL- Update multiple rows with one submit button
- 13
php mysql（INSERT QUERY）
- 14
mysql insert into query not working
- 15
Multiple rows to one column
- 16
SQL - Multiple Rows Into One
- 17
For Loop to insert multiple rows in SQL
- 18
mysql query to count no of rows in joining three tables and count rows of one table
- 19
MySQL count across multiple columns, with subquery, with one result query
- 20
Insert multiple values from one table to another using eloquent/query builder
- 21
one to one result in mysql Query
- 22
Mysql INSERT query inserts zeroes
- 23
MYSQL INSERT INTO FROM SELECT QUERY
- 24
How to combine multiple rows into one rows in SQL
- 25
SQL Combining multiple rows into one
- 26
Convert one column to multiple rows
- 27
Duplicate rows after a MySQL query
- 28
mysql query returning double rows
- 29
MySQL query - multiple JOIN
コメントを追加