Jump to content

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ntubookb/domains/ntubookbrowser.co.uk/public_html/books.php

ashleycolton1234

By ashleycolton1234
in PHP Coding Help

Recommended Posts

ashleycolton1234 Newbie

ashleycolton1234

Posted
Posted
<?php

//session status block

include "connect_to_mysql.php";

?>

<?php

//script error reporting

//error reporting

error_reporting(E_ALL);

ini_set('display_errors','1');

?>

 

<?php

//parse form data to database

//parse the form data and add inverntory items to the system

//CHANGE ALL VALUES TO SUIT NEEDS OF CURRENT DATABASE

//FORM DATA AND ADD BOOK TO THE SYSTEM DATABASE

if (isset($_POST['BOOKNAME'])) {

 

    $BOOKNAME = mysql_real_escape_string($_POST['BOOKNAME']);

$BOOKPRICE = mysql_real_escape_string($_POST['BOOKPRICE']);

$CATEGORY = mysql_real_escape_string($_POST['CATEGORY']);

$BOOKDESCRIPTION = mysql_real_escape_string($_POST['BOOKDESCRIPTION']);

// See if that product name is an identical match to another product in the system

$sql = mysql_query("SELECT ID FROM BOOK WHERE BOOKNAME='$BOOKNAME' LIMIT 1");

    

// Add this product into the database now

$sql = mysql_query("INSERT INTO BOOK (BOOKNAME, BOOKPRICE, BOOKDESCRIPTION, CATEGORY, DATE) 

        VALUES('$BOOKNAME','$BOOKPRICE','$BOOKDESCRIPTION','$CATEGORY',now())") or die (mysql_error());

     $pid = mysql_insert_id();

// Place image in the folder 

$newname = "$pid.jpg";

move_uploaded_file( $_FILES['fileField']['tmp_name'], "inventory_images/$newname");

echo 'Book Successfully Uploaded <a href="index.php"><b>Click Here To Go To Home Page</b></a>';

    exit();

}

?>

 

<?php

//this block grab the whole list for viewing

//THIS BLOCKS GRABS THE WHOLE LIST FOR VIEWING

$product_list = "";

$sql = mysql_query("SELECT * FROM BOOK ORDER BY date_added DESC");

$productCount = mysql_num_rows($sql); // count the output amount

if ($productCount > 0) {

while($row = mysql_fetch_array($sql)){

$ID = $row["ID"];

   $BOOKNAME = $row["BOOKNAME"];

$CATEGORY = $row["CATEGORY"];

$BOOKDESCRIPTION = $row["BOOKDESCRIPTION"];

$BOOKPRICE = $row["BOOKPRICE"];

$product_list = "Product ID: $ID - <strong>$BOOKNAME</strong> - $$BOOKPRICE - <em>Added $date_added</em>        • <br />";

$date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));

}

} else {

$product_list = "There are currently no books for sale, check back soon !";

}

?>

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>NTU Book Browser</title>

<link rel="stylesheet" href="style.css" />


 

<script>

$(function() {

$("#text-one").change(function() {

$("#text-two").load("textdata/" + $(this).val() + ".txt");

});

});

</script>

</head>

 

<body>

<div id="wrapper">

 

    <?php include_once("template_header.php");?>

        

<div id="wrapper_content">

      

 

        

        <div id="headers">

<h2> Books </h2>

        </div>

        

        <div id="main">

        

        <div id="add_item">

        <p><i> <a href="books.php#bookForm">+Sell Book</a></i></p>

        </div>

        

       

<?php echo $product_list; ?>

        

        

        

        <a name="bookForm" id="bookForm"></a>

        <h3> Add New Book Form </h3>

        <form action="books.php" enctype="multipart/form-data" name="myForm" id="myform" method="post">

    <table width="90%" border="0" cellspacing="0" cellpadding="6">

      <td align="right">Book Name</td>

        <td><select name="CATEGORY" id="text-one">

<option selected value="base">Select Book Category</option>

<option value="biomedicalscience">Biomedical Science</option>

<option value="history">History</option>

<option value="spanish">Spanish</option>

<option value="economics">Economics</option>

<option value="sportsscience">Sports Science</option>

<option value="forensicsscience">Forensics Science</option>

<option value="computersystems">Computer Systems</option>

<option value="english">English</option>

<option value="psychologyandeducation">Psychology and Education</option>

</select>

        </td>

 

<br />

<td align="right"></td>

        <td>

<select name="BOOKNAME" id="text-two">

<option>Select Book</option>

</select>

        </td>

      </tr>

      <tr>

        <td align="right">Book Price</td>

        <td><label>

          £

          <input name="BOOKPRICE" type="text" id="BOOKPRICE" size="12" />

        </label></td>

      </tr>

      <tr>

        

      <tr>

       

      <tr>

        <td align="right">Book Description</td>

        <td><label>

          <textarea name="BOOKDESCRIPTION" id="description" cols="64" rows="5"></textarea>

        </label></td>

      </tr>

      <tr>

        <td align="right">Book Image</td>

        <td><label>

          <input type="file" name="fileField" id="fileField" />

        </label></td>

      </tr>      

      <tr>

        <td> </td>

        <td><label>

          <input type="submit" name="button" id="button" value="Add Book" />

        </label></td>

      </tr>

    </table>

    </form>

        

        

        

        

        

        

        </div>

        

        

        

        

        

        

        

        

        

        

        

        

        

    

        

 

        <div id="footer">

    <?php include_once("template_footer.php");?>

        </div>

        

        

        

    </div>

</div>

    <div class="clear"></div>

</body>

</html>

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.