-
Book Overview & Buying
-
Table Of Contents
Practical Web Development
By :
Practical Web Development
By:
Overview of this book
Free Chapter
Adding data
We mentioned using phpMyAdmin to propagate our tables. Once our application is running, we need to know how to add a date using PHP code, for instance, to add an order to the system. We will provide an example that adds a book to the books table. All the strings we use can, of course, be replaced by PHP variables. The SQL command we need here is INSERT:
<?php
$insertsql = 'INSERT INTO books (title, author_id, price) VALUES ("My new book", "3", "38);'
$mysqli->query($insertsql);
$newestbook = $mysqli->insert_id;
?>This will automatically add a row to your table, create your primary key with a value one higher than all others, insert the title, author_id, and insert the price into that row. All other fields will get the default value you specified while building your tables with phpMyAdmin.
The insert_id function is quite handy if you want to retrieve the value of the newly created primary key. We will use this now to change the price from 38 to 39.
Updating data
Let's...
Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
50+ new titles added per month and exclusive early access to books as they are being written.
Notes and Bookmarks
Search in title
Add to playlist
Font size
Change the font size
Margin width
Change margin width
Day/Sepia/Night Modes
Change background colour
Search
Your notes and bookmarks