joshstevens19
-
Posts
30 -
Joined
-
Last visited
Posts posted by joshstevens19
-
-
so im connecting my netbeans php to phpmyadmin (database).. now in this i am trying to create a php code statement which will take the inserted data into the html fields and insert them into my database successful.. anybody know what im doing wrong here is the error message:Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\PhpProject1\New Review.php on line 27error inserting new record<?phpif (isset($_REQUEST['submitted'])) {include('connect database.php');$showtitle = $_POST['SHOWTITLE'];$showreview =$_POST['SHOWREVIEW'];$sqlinsert = "INSERT INTO reviews (SHOWTITLE,SHOWREVIEW) VALUES('$showtitle', '$showreview')";if (!mysql_query($dbConn,$sqlinsert)) {die('error inserting new record');}here is my html coding with it<form method="post" action="New Review.php"><input type="hidden" name="submitted" value="true" /><fieldset><legend> New Reviews</legend><label> Enter show title:<input type ="text" name="SHOWTITLE" /></label><label> Enter Review: <input type ="text" name="SHOWREVIEW" /></label></fieldset><br /><input type ="submit" value ="add new review" /></form>
-
i have tried that part of changing and now it comes up with this Notice: Undefined variable: INSERT INTO reviews (SHOWTITLE,SHOWREVIEW) VALUES('Match Of The Day', 'amazing') in C:\xampp\htdocs\PhpProject1\New Review.php on line 27
error inserting new record
<?phpif (isset($_POST['submitted'])) {include('connect database.php');$showtitle = $_POST['SHOWTITLE'];$showreview =$_POST['SHOWREVIEW'];$sqlinsert = "INSERT INTO reviews (SHOWTITLE,SHOWREVIEW) VALUES('$showtitle', '$showreview')";if (!mysql_query($$sqlinsert)) {die('error inserting new record');} -
so all i do is replace
if (!mysql_query($dbConn,$sqlinsert)) {
to your code? am i correct in saying that and thats the only issue involved??
-
so im connecting my netbeans php to phpmyadmin (database).. now in this i am trying to create a php code statement which will take the inserted data into the html fields and insert them into my database successful.. anybody know what im doing wrong here is the error message:Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\PhpProject1\New Review.php on line 27error inserting new record
<?php if (isset($_REQUEST['submitted'])) { include('connect database.php'); $showtitle = $_POST['SHOWTITLE']; $showreview =$_POST['SHOWREVIEW']; $sqlinsert = "INSERT INTO reviews (SHOWTITLE,SHOWREVIEW) VALUES('$showtitle', '$showreview')"; if (!mysql_query($dbConn,$sqlinsert)) { die('error inserting new record'); }
here is my html coding with it<form method="post" action="New Review.php"><input type="hidden" name="submitted" value="true" /><fieldset><legend> New Reviews</legend><label> Enter show title:<input type ="text" name="SHOWTITLE" /></label><label> Enter Review: <input type ="text" name="SHOWREVIEW" /></label></fieldset><br /><input type ="submit" value ="add new review" /></form>
PHP coding help .. ? query and if statements playing up
in PHP Coding Help
Posted
when i echo it out it comes up with this
Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\PhpProject1\New Review.php on line 27
error inserting new record
and when i switch them about all it says is
'error inserting new record' but no warning codes.. whats the next thing i could do as it not inserting it into the database which i am trying to achieve