[RESOLVED] [HELP] Problem with FULL TEXT SEARCH Feature

romioaa

Hi,

I am having a big problem with my code:

This is for index.php

<body>
<div id="apDiv3">
<div align="center">
<p><span class="style8">JOUTUBE</span><br />
<span class="style5">The Number One Video Engine</span></p>
<form id="form" name="form1" method="GET" action="search.php">
<label> Search a Video
<input name="search_video" type="text" id="search_video" size="50" />
</label>
<label>
<input type="submit" name="submit" id="submit" value="Submit" />
</label>
<span class="style7"><a href="submit.php">Submit Video </a> </span>
<br />
<span class="style9">Home - Latest Videos- Contact Us</span>
</form>
<p> </p>
</div>
</div>
<div id="apDiv5">

This is for search.php

<?php
$search2= $_GET['search_video'];

$query = "
SELECT * FROM submission_form
WHERE MATCH(video_title, video_description) AGAINST ('$search2')
";
$sql = mysql_query($query);

while($row = mysql_fetch_array($sql)) {
echo "<tr><td>{$row['video_title']}</td>";
echo "<td>{$row['video_description']}</td>";
echo "</table>";
}

I am getting this error:

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

bradgrafelman

Welcome to PHPBuilder! When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags (not the generic CODE tags) as they make your code much easier to read and analyze.

As for your problem, you need to debug the SQL query since it is failing. As the error message states, you're passing mysql_fetch_array() a boolean instead of a MySQL resource. That must mean that [man]mysql_query/man returned a boolean response which, as the manual states, means that an error occured and the query has failed.

To figure out why, you should retrieve the MySQL error message. If [man]mysql_query/man returns FALSE, use [man]mysql_error/man to get this message to aid in debugging the query.

Also, user-supplied data should never be placed directly into a SQL query else your code will be vulnerable to SQL injection attacks and/or just plain SQL errors. Instead, you must first sanitize the data with a function such as [man]mysql_real_escape_string/man (for string data).

romioaa

Thanks for the answer but I am not being able to solve the problem, I am new in PHP so i have not alot experience with this types of errors, can you please tell me what to do.

I have tried everything :s

BenGilbert

See if this helps. Change the $GET to a $POST
also change your form method from get to post in your index page.


<?php
$search2= $_POST['search_video'];


$query = "SELECT * FROM submission_form WHERE MATCH(video_title, video_description) AGAINST ('$search2')";
$sql = mysql_query($query);


while($row = mysql_fetch_array($sql)) {
echo "<tr><td>{$row['video_title']}</td>";
echo "<td>{$row['video_description']}</td>";
echo "</table>";
}

romioaa

I am getting the same error:


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

This would be line 24


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

johanafm

# You allready have a connection to the db, right?
# Assuming you have, and it's called $link...


# User supplied data is (could be) unsecure
$search2 = mysql_real_escape_string($_POST['search_video'], $link);


$query = "SELECT * FROM submission_form WHERE MATCH(video_title, video_description) AGAINST ('$search2')";
$sql = mysql_query($query);

# As the documentation at php.net says, mysql_query returns a result set resource
# OR BOOLEAN FALSE
# As the documentation at php.net says, mysql_fetch_array takes a result set resource
# as argument, NOT boolean false.
# That's what the error message means. If you look at it again, it should be obvious
# Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given
# $sql is parameter one, but it's not a resource, it's a boolean.

# So, after every single query, check the return value
if (!$sql)
{
	error_log(mysql_errno($link).': ' . mysql_error($link));
	exit; # or? it might be ok to go on as well...
}
else
{
	while($row = mysql_fetch_array($sql))
	{
		echo "<tr><td>{$row['video_title']}</td>";
		echo "<td>{$row['video_description']}</td>";
		echo "</table>";

romioaa

ok,

No I know that the mysql query is returning as a boolean, what should I do to fix it?

<?php mysql_query($query); ?>

johanafm

Read this

romioaa

I did that and I am getting and it returns false, .... the connection to the database is working and I don't know where else to look

bradgrafelman

What is the MySQL error message? As we've pointed out (numerous times), you should be using [man]mysql_error/man to check for the MySQL error message when a query fails.

romioaa

I added the code as johanafm told me and what I get is a blank page ...

johanafm

In that case, error reporting is turned off by default (php.ini), or error_level is not properly specified (less likely).
Change php.ini to log or display errors by default, and set error_level to -1.

romioaa

I finally found the error, it looks that I was searching for the word 'SEO' and in FULL TEXT option we have to search for words that have more than three letters

🙂 .... thanks everyone