How to insert data from multiple rows in the database from PHP

advertisements

am currently creating a table in PHP that display all row of data from one of the table in my database. After that, I want to save all row from the PHP's table into new database table. But the problem is, after save, only the last row will be stored into the new table in database, the other row from early will not be save. Can someone help me. I want to try the foreach but can someone teach me.

<table border="1" align="center" cellspacing="0">
<tr>
  <td colspan="12"><div align="center">
      <h3><strong>BOOKS</strong></h3>
  </div></td>
</tr>
<tr>
  <td width="80"><div align="center">Code</div></td>
  <td width="40"><div align="center">No</div></td>
  <td width="250"><div align="center">Name</div></td>
  <td width="100"><div align="center">Publisher</div></td>
  <td width="80"><div align="center">Price</div></td>
  <td width="60"><div align="center">Quantity</div></td>
</tr>

<?php do { ?>
  <tr>
    <td><div align="center">
        <input name="student_no" type="hidden" id="student_no" value="<?php echo $row_UserDetails['student_no']; ?>" />
        <input name="book_code" type="text" id="book_code" value="<?php echo $row_book_booking_list['book_code']; ?>" size="8" readonly="readonly" />
    </div></td>
    <td><div align="center">
        <input name="book_no" type="text" id="book_no" value="<?php echo $row_book_booking_list['book_no']; ?>" size="1" readonly="readonly" />
    </div></td>
    <td><div align="center">
        <input name="book_name" type="text" id="book_name" value="<?php echo $row_book_booking_list['book_name']; ?>" size="31" readonly="readonly" />
    </div></td>
    <td><div align="center">
        <input name="book_publisher" type="text" id="book_publisher" value="<?php echo $row_book_booking_list['book_publisher']; ?>" size="10" readonly="readonly" />
    </div></td>
    <td><div align="center">
        <input name="book_price" type="text" id="book_price" value="<?php echo $row_book_booking_list['book_price']; ?>" size="7" readonly="readonly" />
    </div></td>
    <td><div align="center">
      <select name="book_quantity" id="book_quantity">
        <option value="0">0</option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
        <option value="6">6</option>
        <option value="7">7</option>
        <option value="8">8</option>
        <option value="9">9</option>
      </select>
    </div></td>
  </tr>
<?php } while ($row_book_booking_list = mysql_fetch_assoc($book_booking_list)); ?>
</table>


if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO book_booked_list (student_no, book_code, book_no, book_name, book_publisher, book_price, book_quantity) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                   GetSQLValueString($_POST['student_no'], "int"),
                   GetSQLValueString($_POST['book_code'], "text"),
                   GetSQLValueString($_POST['book_no'], "text"),
                   GetSQLValueString($_POST['book_name'], "text"),
                   GetSQLValueString($_POST['book_publisher'], "text"),
                   GetSQLValueString($_POST['book_price'], "double"),
                   GetSQLValueString($_POST['book_quantity'], "int"));

mysql_select_db($database_book_con, $book_con);
$Result1 = mysql_query($insertSQL, $book_con) or die(mysql_error());
}

To copy all rows from source_table to book_booked_list table, just execute the query below:

INSERT INTO book_booked_list
    (student_no, book_code, book_no, book_name, book_publisher,
       book_price, book_quantity)
SELECT
    student_no, book_code, book_no, book_name, book_publisher,
       book_price, book_quantity
FROM source_table

Replace source_table with the name of the table you copy data from.

Related Articles

PHP - How to add data to a row in the database

I created a login page that when user login redirect to a pictures.php, pictures page should contains the images of the user , I already create upload page to upload image to file directory and when the user upload an image the image link is added to

How to insert data in a row using the list in Python?

I have a list called rowdata = [u'android', u'TSC', u'airtime-ctg', u'guest', u'guest', u'8354e5f4-e18d-11e6-9a46-0242ac110002', u'77c7600c502a3d15'] and want to enter this data in my table ctg_payload. I have tried : sqlquery = 'insert into ctg_payl

How to insert data into multiple tables in Yii

I am new in Yii. I need to create product module to save product data. In that i need to create two table products and product_image to save product data and multiple product images. Product table id, category_id, , title ,price, description Product

Inserting multiple rows in the database from the same html form

I want to insert differently i.e. multiple entries into the database, but input is taken from the same form. I have a form called questionForm. It is a static form, and has a text field for inserting question and corresponding text fields like marks

How to insert data into multiple tables at once

I am wondering if the code I have written is the best way to insert data into multiple tables at ones. For me this is the first time i'am using code to insert data into the database. Before i was always using the tools from visual studio to do it. So

How to insert data from one table to another table

I am using this auto complete form, that gets the data from 1 table, now i am using that form to insert data from its table to another table. here is my SQL for the inserting into the table "products" $image = addslashes(file_get_contents($_FILE

How to insert data from the string into the table?

I have on table PersonDetail which contains NAME and AGE as column. I am using one application which is taking all data as String by comma and pipe separated value like 'Acton,58|Nairi,20|Sara,14|Denny,52' (Format is same as given) I want to insert t

how to insert data into multiple tables using a single query

Inserting the data in multiple tables using single query INSERT INTO client_1.student_info, client_1.admission_details,client_1.parent_info,client_1.student_grade_mapping,client_1.parent_student_mapping( year1, division, id, student_id, firstname, la

How to insert in a specific line in the database?

Okay, so my database is as follows by this order: id (primary - auto_increment), username (unique), password, fname, mail I have it so that users register a username and password and it adds it to the database, first of all. No username can be the sa

How to insert data from multiple tables at once

I am trying to insert data into a table using data from 2 other tables. I need to use: Project.ProjectID and Action.ActionID to be inserted into a table I have called ActionDetails, WHERE the Project.ProjectID = 1 Any ideas...? i've googled everywher

How to insert multiple table rows into the database using php

I have a script that generates for me a table and every time I press a button it generates a row. When the user press submit I want to insert into the database all rows at once. I tried there something but don't work. I have there the query to insert