Write a prepared statement for the below code $name mysql real escape string(htmlentities($ POST 'name' )) $content mysql real escape string(htmlentities($ POST 'content' )) $submit mysql real escape string(htmlentities($ POST 'submit' )) echo $username if(isset($submit)) if($name $content) $sql INSERT INTO posts (title, content, time, owner) VALUES ('$name', '$content', now(), '$username') $result $mysqli query($sql) if($result) echo Your reply has been saved header ('Location index php') else echo $result echo problem with query else echo one or more fields are empty else echo Your reply has been saved, php require auth php $mysqli new mysqli(' localhost root 'seedubuntu', project mysql connect error die(' Connection to the database has error $mysqli connect error) $nane nysgl real escape string(htnlentities($ POSTC 'name $content mysql real escape string (htnlentities POST content $submit mysql real escape string (htnlentities($ POSTC' subnit' )) echo $username if(isset ($submit)) if ($nane Scontent)f i $segl INSERT INTO posts (title content, tine, owner) VALUES ('Snane 'Scontent', now(), 'Susernane $result $nysqli query ($sql) if $result) echo Your reply has been saved header ('Location index php') else echo result echo problem with query else echo one or nore fields are empty else echo Your reply has been saved

The Answer is in the image, click to view ...

Question: Write a prepared statement for the below code $name = mysql_real_escape_string(htmlentities($_POST['name'])); $content = mysql_real_escape_string(htmlentities($_POST['content'])); $submit = mysql_real_escape_string(htmlentities($_POST['submit'])); echo $username; if(isset($submit)) { if($name && $content){ $sql

Write a prepared statement for the below code

$name = mysql_real_escape_string(htmlentities($_POST['name'])); $content = mysql_real_escape_string(htmlentities($_POST['content'])); $submit = mysql_real_escape_string(htmlentities($_POST['submit'])); echo "$username"; if(isset($submit)) { if($name && $content){ $sql = "INSERT INTO posts (title, content, time, owner) VALUES ('$name', '$content', now(), '$username')"; $result = $mysqli->query($sql); if($result){ echo "Your reply has been saved"; header ('Location: index.php'); } else{ echo $result; echo "problem with query"; } } else{ echo "one or more fields are empty"; } } else { echo "Your reply has been saved, ";

}

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!

TASK You are to create a forum website based on the descriptions below, that allows users to sign up and create topics and posts on those topics. SET-UP Create a folder on...

Write a delete function to the post.. which will deleted the post that is been added in the database. Below code is the auth.php $mysqli = new mysqli('localhost', 'root', 'seedubuntu', 'root');...

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...

PHP and MySQL Programming Part 1: A Guest Book 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....

PHP and MySQL Programming... Part 1: A Guest Book 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....

I know its a bit harsh but see if you can finish it in before tomorrow? thanks QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 2...

Attached is the project for the assignment. I will need a draft by Feb 20th but the actually project is not due until Feb 27th. My weekly discussion post are attached as well they are title...

Hello, Would you please review the attached assignment? I know I have errors in and this assignment carries into the rest of the course so I need to get it corrected to move forward. I have attached...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

A manufacturing company operates a non-integrated accounting system. At the end of Month 1 of the financial year the following reconciliation statement was prepared. Profit as per cost accounts Add:...

A black body is at a temperature of 5760 K. The energy of radiation emitted by the body at wavelength 250 nm is U, at wavelength 500 nm is U, and that at 1000 nm is U. Wien's constant, b = 2.88 10...

Possible returns and their probabilities for an asset is given in the table below. The expected return is 2 7 . 2 5 % . Calculate the standard deviation of the asset's return. \ table [ [ Probability...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

KEY QUESTION Trace the cause-and-effect chain through which financing and refinancing of the public debt might affect real interest rates, private investment, the stock of capital, and economic...

KEY QUESTION Why does the Federal Reserve require commercial banks to have reserves? Explain why reserves are an asset to commercial banks but a liability to the Federal Reserve Banks. What are...

KEY QUESTION Suppose the price level and value of the dollar in year 1 are 1 and $1, respectively. If the price level rises to 1.25 in year 2, what is the new value of the dollar? If, instead, the...