0

Hey everyone! I am working on a project that involves querying a mysql database using php, and I am running into some issues. html form is in list_files.php and the query is in query.php .. i also attached my mySQL database which has 2 tables: only the file table is being used for this part of the project.

I just cant seem to get php to echo any results from the query.. i keep getting this syntax error-->

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\query.php on line 41

I am able to upload to the database just fine, but i am hitting a wall when it comes to the query.

This is what i have so far-->

query.php

<?php
			$host="localhost"; // Host name 
			$username="root"; // Mysql username 
			$password=""; // Mysql password 
			$db_name="informationdb"; // Database name 
			$tbl_name="file"; // Table name 
			
			// Connect to the database
            $con = mysql_connect("$host", "$username", "$password", "$db_name");
			
            if(!$con) {
                die("MySQL connection failed: ". mysql_error());
            } 
			
			$playerfname=$_POST["playerfname"];
			$playerlname=$_POST["playerlname"];
			$sport=$_POST["sport"];
			$season=$_POST["season"];
			$number=$_POST["number"];
			
			
			
			
			//$playerfname=trim($playerfname);
			//$playerlname=trim($playerlname);
			//$sport=trim($sport);
			//$season=trim($season);
			//$number=trim($number);
			
			
			$result = mysql_query("
				SELECT *
				FROM file
				WHERE playerfname LIKE '%".$playerfname."%'
				AND playerlname LIKE '%".$playerlname."%'
				AND sport LIKE '%".$sport."%'
				AND season LIKE '%".$season."%'
				AND number LIKE '%".$number."%'
				");

			while($row = mysql_fetch_array($result))
			{
				echo $row['playerfname'] . " " . $row['playerlname'] . " " . $row['sport'] . " " . $row['season'] . " " . $row['number'];
				echo "<br />";
			}
			
			mysql_close($con);
		?>

list_files.php

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

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US">

<head>
	<title>ASU Sports Information</title>
	<link rel='stylesheet' type='text/css' href='menu.css' />
	<link rel='stylesheet' type='text/css' href='form.css' />
</head>

<body>
<div class="header">

	<img src="BlockA.png" alt="BlockA" height="110px" />
	<img src="Header.png" alt="Header" height="100px"/>

</div>

<div class="body">
		<div class="link">
			<ul class="nav red"> 
 
			<li><a href="login_success.php">Home</a></li>
			<li><a href="contact.html">Contact</a></li>
			<li><a href="uploadform.php">Upload Photos</a></li>
			<li><a href="list_files.php">Search Photos</a></li>
			</ul>
		</div>
		<br /> <br /><br />
		<div class="searchform">
			
			<form action="query.php" id="loginform" method="post">
			<p style="text-align:center">
				<label>First Name:</label>
				<input type="text" name="playerfname" size="30" /> <br>
				<label>Last Name:</label>
				<input type="text" name="playerlname" size="30" /> <br>
				<label>Sport:</label>
				<input type="text" name="sport" size="30" /> <br>
				<label>Season:</label>
				<input type="text" name="season" size="30" /> <br>
				<label>Jersey Number:</label>
				<input type="text" name="number" size="30" /> <br>
			</p>
			<p style="text-align:center"> <input id="submitbutton" type="submit" value="Search"/> </p>
			
		</div>
</div>

</body>

</html>
  
 <?php  
//show files in database and download them 
	$host="localhost"; // Host name 
	$username="root"; // Mysql username 
	$password=""; // Mysql password 
	$db_name="informationdb"; // Database name 
	$tbl_name="file"; // Table name 
	
    // Connect to the database
    $dbLink = new mysqli("localhost", "$username", "$password", "$db_name");
    if(mysqli_connect_errno()) {
        die("MySQL connection failed: ". mysqli_connect_error());
    }
     
    // Query for a list of all existing files
    $sql = 'SELECT `id`, `name`, `mime`, `size`, `playerfname` FROM `file`';
    $result = $dbLink->query($sql);
     
    // Check if it was successfull
    if($result) {
        // Make sure there are some files in there
        if($result->num_rows == 0) {
            echo '<p>There are no files in the database</p>';
        }
        else {
            // Print the top of a table
            echo '<table width="100%">
                    <tr>
                        <td><b>Name</b></td>
                        <td><b>File Type</b></td>
                        <td><b>Size (bytes)</b></td>
                        <td><b>Player First Name</b></td>
                        <td><b>&nbsp;</b></td>
                    </tr>';
     
            // Print each file
            while($row = $result->fetch_assoc()) {
                echo "
                    <tr>
                        <td>{$row['name']}</td>
                        <td>{$row['mime']}</td>
                        <td>{$row['size']}</td>
                        <td>{$row['playerfname']}</td>
                        <td><a href='get_file.php?id={$row['id']}'>Download</a></td>
                    </tr>";
            }
     
            // Close table
            echo '</table>';
        }
     
        // Free the result
        $result->free();
    }
    else
    {
        echo 'Error! SQL query failed:';
        echo "<pre>{$dbLink->error}</pre>";
    }
     
 
// Close the mysql connection
    $dbLink->close();
    ?>

Database layout:
db name: informationdb
table: file
fields:

id name mime size data playerfname playerlname sport season number

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

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US">

<head>
	<title>ASU Sports Information</title>
	<link rel='stylesheet' type='text/css' href='menu.css' />
	<link rel='stylesheet' type='text/css' href='form.css' />
</head>

<body>
<div class="header">

	<img src="BlockA.png" alt="BlockA" height="110px" />
	<img src="Header.png" alt="Header" height="100px"/>

</div>

<div class="body">
		<div class="link">
			<ul class="nav red"> 
 
			<li><a href="login_success.php">Home</a></li>
			<li><a href="contact.html">Contact</a></li>
			<li><a href="uploadform.php">Upload Photos</a></li>
			<li><a href="list_files.php">Search Photos</a></li>
			</ul>
		</div>
		<br /> <br /><br />
		<div class="searchform">
			
			<form action="query.php" id="loginform" method="post">
			<p style="text-align:center">
				<label>First Name:</label>
				<input type="text" name="playerfname" size="30" /> <br>
				<label>Last Name:</label>
				<input type="text" name="playerlname" size="30" /> <br>
				<label>Sport:</label>
				<input type="text" name="sport" size="30" /> <br>
				<label>Season:</label>
				<input type="text" name="season" size="30" /> <br>
				<label>Jersey Number:</label>
				<input type="text" name="number" size="30" /> <br>
			</p>
			<p style="text-align:center"> <input id="submitbutton" type="submit" value="Search"/> </p>
			
		</div>
</div>

</body>

</html>
  
 <?php  
//show files in database and download them 
	$host="localhost"; // Host name 
	$username="root"; // Mysql username 
	$password=""; // Mysql password 
	$db_name="informationdb"; // Database name 
	$tbl_name="file"; // Table name 
	
    // Connect to the database
    $dbLink = new mysqli("localhost", "$username", "$password", "$db_name");
    if(mysqli_connect_errno()) {
        die("MySQL connection failed: ". mysqli_connect_error());
    }
     
    // Query for a list of all existing files
    $sql = 'SELECT `id`, `name`, `mime`, `size`, `playerfname` FROM `file`';
    $result = $dbLink->query($sql);
     
    // Check if it was successfull
    if($result) {
        // Make sure there are some files in there
        if($result->num_rows == 0) {
            echo '<p>There are no files in the database</p>';
        }
        else {
            // Print the top of a table
            echo '<table width="100%">
                    <tr>
                        <td><b>Name</b></td>
                        <td><b>File Type</b></td>
                        <td><b>Size (bytes)</b></td>
                        <td><b>Player First Name</b></td>
                        <td><b>&nbsp;</b></td>
                    </tr>';
     
            // Print each file
            while($row = $result->fetch_assoc()) {
                echo "
                    <tr>
                        <td>{$row['name']}</td>
                        <td>{$row['mime']}</td>
                        <td>{$row['size']}</td>
                        <td>{$row['playerfname']}</td>
                        <td><a href='get_file.php?id={$row['id']}'>Download</a></td>
                    </tr>";
            }
     
            // Close table
            echo '</table>';
        }
     
        // Free the result
        $result->free();
    }
    else
    {
        echo 'Error! SQL query failed:';
        echo "<pre>{$dbLink->error}</pre>";
    }
     
 
// Close the mysql connection
    $dbLink->close();
    ?>
<?php
			$host="localhost"; // Host name 
			$username="root"; // Mysql username 
			$password=""; // Mysql password 
			$db_name="informationdb"; // Database name 
			$tbl_name="file"; // Table name 
			
			// Connect to the database
            $con = mysql_connect("$host", "$username", "$password", "$db_name");
			
            if(!$con) {
                die("MySQL connection failed: ". mysql_error());
            } 
			
			$playerfname=$_POST["playerfname"];
			$playerlname=$_POST["playerlname"];
			$sport=$_POST["sport"];
			$season=$_POST["season"];
			$number=$_POST["number"];
			
			
			
			
			//$playerfname=trim($playerfname);
			//$playerlname=trim($playerlname);
			//$sport=trim($sport);
			//$season=trim($season);
			//$number=trim($number);
			
			
			$result = mysql_query("
				SELECT *
				FROM file
				WHERE playerfname LIKE '%".$playerfname."%'
				AND playerlname LIKE '%".$playerlname."%'
				AND sport LIKE '%".$sport."%'
				AND season LIKE '%".$season."%'
				AND number LIKE '%".$number."%'
				");

			while($row = mysql_fetch_array($result))
			{
				echo $row['playerfname'] . " " . $row['playerlname'] . " " . $row['sport'] . " " . $row['season'] . " " . $row['number'];
				echo "<br />";
			}
			
			mysql_close($con);
		?>
1
Contributor
1
Reply
3
Views
5 Years
Discussion Span
Last Post by dunktap
1

i fixed it!!

<?php
			$host="localhost"; // Host name 
			$username="root"; // Mysql username 
			$password=""; // Mysql password 
			
			
			// Connect to the database
            $con = mysql_connect("$host", "$username", "$password");
			
            if(!$con) {
                die("MySQL connection failed: ". mysql_error());
            } 
			
			
			$playerfname=$_POST["playerfname"];
			$playerlname=$_POST["playerlname"];
			$sport=$_POST["sport"];
			$season=$_POST["season"];
			$number=$_POST["number"];
			
			
			
			
			//$playerfname=trim($playerfname);
			//$playerlname=trim($playerlname);
			//$sport=trim($sport);
			//$season=trim($season);
			//$number=trim($number);
			
			$mydb=mysql_select_db("informationdb");
			
			$sql ="
				SELECT *
				FROM file
				WHERE playerfname LIKE '%".$playerfname."%'
				AND playerlname LIKE '%".$playerlname."%'
				AND sport LIKE '%".$sport."%'
				AND season LIKE '%".$season."%'
				AND number LIKE '%".$number."%'
				";
			$result=mysql_query($sql);
			while($row = mysql_fetch_array($result))
			{
				echo $row['playerfname'] . " " . $row['playerlname'] . " " . $row['sport'] . " " . $row['season'] . " " . $row['number'];
				echo "<br />";
			}
			
			mysql_close($con);
		?>
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.