What is the correct syntax for PHP SQL prepared statements

0 votes

The PHP/SQL statement that I have created is not prepared. Here only one variable is being passed through, I think this happened due to the syntax.

$sql = "INSERT INTO notes (noteText) VALUES ?";

What have I done wrong here? and how can I fix this?

Jun 1, 2022 in PHP by Kichu
 • 19,040 points • 449 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In PHP

0 votes
1 answer

What is the best way to allow plugins for a PHP application?

Hello @kartik, I've used, it's an attempt to ...READ MORE

answered Apr 15, 2020 in PHP by Niroj
 • 82,840 points • 728 views
0 votes
0 answers

Can't a PHP file be stored in .html extension? I've heard that .php is not supported by some browsers i'm not sure What might be the remedy for this?

This is my sample code and it ...READ MORE

Jun 14, 2022 in PHP by narikkadan
 • 63,600 points • 428 views
0 votes
0 answers

What is the best IDE for PHP?

I use Notepad++ for code editing, I need an ...READ MORE

Jun 23, 2022 in PHP by narikkadan
 • 63,600 points • 633 views
0 votes
1 answer

What is meant by passing the variable by value and reference in PHP?

Hello, When the variable is passed as value ...READ MORE

answered Mar 27, 2020 in PHP by Niroj
 • 82,840 points • 3,260 views
0 votes
1 answer

What is the use of $_REQUEST variable in php?

Hii @kartik, The $_REQUEST variable is used to read the ...READ MORE

answered Mar 27, 2020 in PHP by Niroj
 • 82,840 points • 3,282 views
0 votes
1 answer

What are the best way to allow plugins for a PHP application?

Hii, Here is an approach I have  used, it's ...READ MORE

answered Apr 1, 2020 in PHP by Niroj
 • 82,840 points • 751 views
0 votes
2 answers

Define a SQL query? What is the difference between SELECT and UPDATE Query? How do you use SQL in SAS?

HI.. SQL is Structured Query Language, which is ...READ MORE

answered Aug 8, 2020 in PHP by anonymous
 • 10,539 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
 • 8,250 points • 1,268 views
0 votes
2 answers

How to create a shared database for users for different systems to connect to a single database in another system.?

Like Omkar said, while presenting your project ...READ MORE

answered Mar 18, 2019 in Database by Vardhan
 • 13,150 points • 5,046 views
0 votes
1 answer

Can i learn back-end web development without having any knowledge on front end web development?

Hi Unfortunately no, you have to know the ...READ MORE

answered Apr 23, 2020 in Web Development by Chyanit
 • 160 points • 2,881 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.