Question: Please I need PHP code (PDO) for check table (books) if not exist print error, and if books table exist insert data into books. $conn

Please I need PHP code (PDO) for check table (books) if not exist print error, and if books table exist insert data into books.

$conn = new PDO($dsn, $username, $password);

$sql = "INSERT INTO books(booktitle, description, price, category) VALUES ('$bookTitle', '$describtion', $price, '$category')";

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Your tasks is to create a guest book that contains three small php-scripts as follows: connect.php , which will set up a connection to the database. guestbook.php , which will show all the guestbook...

Q:

PHP and SQL / for this code below please, I need to add code on it that checks for the database table, if exist add the data and if it doesn't exist, echo an error and die or exit. Book Tilile

Q:

Web scripting php Use the php scripts below for Ch13 and Ch14. Implement the codes in a fully functional working web application which does the following: Allows users to register with their personal...

Q:

Hello, in this problem I only need numbers 16 and 17 finished, and if you see anything else wrong feel free to change. (only change under "// Type your code here") In PHP 3 --> 3. Problem Description...

Q:

How do I search in my database? Also how can I fix my code so that the entries show up in the table. I just started coding today so I am not very knowledgable. Here are the requirements: I am stuck...

Q:

Complete a Java program named ARMgr that maintains customer accounts receivable in a database. The code to initialize the CustomerAccountsDB database table and add a set of customer accounts is...

Q:

Complete a Java program named ARMgr that maintains customer accounts receivable in a database. The code to initialize the CustomerAccountsDB database table and add a set of customer accounts is...

Q:

Complete a Java program named ARMgr that maintains customer accounts receivable in a database. The code to initialize the CustomerAccountsDB database table and add a set of customer accounts is...

Q:

Complete a Java program named ARMgr that maintains customer accounts receivable in a database. The code to initialize the CustomerAccountsDB database table and add a set of customer accounts is...

Q:

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

Q:

Explain the distinction between a direct-financing lease and a sales-type lease for a lessor.

Q:

The chief accountant for Hollywood Corporation provides you with the following list of accounts receivable written off in the current year. Hollywood Corporation follows the policy of debiting Bad...

Q:

Knight's Tour The updated Knight's Tour challenge involves starting with an 8 x 8 board where each square is either empty or contains one of six unique letters of my first and last name. you should...

Q:

What is not a benefit of the strategy roadmap method? Promotes shared understanding Helps selection options Creates plans Identifies challenges

Q:

What information do you need from your customers to help them with their problems?

Q:

What questions do you ask of complaining customers that could be eliminated?

Q:

What behaviors can you engage in that will quickly move your customers from seeing themselves as standing in opposition to your organization to a view where they see you operating in partnership?