fayecuadra Posted October 22, 2008 Share Posted October 22, 2008 uhm, hello, good evening..I am required to do a website where PHP and mysql is used. I just started studying a month ago. I am supposed to match information from two different databases. I kinda need help since I really am not expert in PHP. I am on my 4th year highschool and its my project. I am already behind some of the researches my classmates are doing. I dont understand some of the PHP codes. I was already able to accept user given information and save it to database. I am currently using XAMPP but I also already have my webserver. Uhm, my next step to do is match the user given information. I have some ideas in mind but I could not put it as codes. I am currently practicing retrieving information since after matching, these matched information would be retrieve and send to email. Could anyone help me? Link to comment https://forums.phpfreaks.com/topic/129569-how-do-you-match-information-using-php/ Share on other sites More sharing options...
GKWelding Posted October 22, 2008 Share Posted October 22, 2008 What information are you trying to match? do you need an exact match or partial match? more info? Link to comment https://forums.phpfreaks.com/topic/129569-how-do-you-match-information-using-php/#findComment-671711 Share on other sites More sharing options...
revraz Posted October 22, 2008 Share Posted October 22, 2008 I would suggest talking to your teachers or classmates. You can also find a ton of tutorials on this. Link to comment https://forums.phpfreaks.com/topic/129569-how-do-you-match-information-using-php/#findComment-671720 Share on other sites More sharing options...
fayecuadra Posted October 27, 2008 Author Share Posted October 27, 2008 i just need a partial match..uhm, how does the function mysql_numrows work? when i tried to use it, it didnt work... Link to comment https://forums.phpfreaks.com/topic/129569-how-do-you-match-information-using-php/#findComment-675386 Share on other sites More sharing options...
corbin Posted October 27, 2008 Share Posted October 27, 2008 http://php.net/mysql_num_rows The php manual is your friend. Link to comment https://forums.phpfreaks.com/topic/129569-how-do-you-match-information-using-php/#findComment-675392 Share on other sites More sharing options...
fayecuadra Posted October 27, 2008 Author Share Posted October 27, 2008 where could i find the php manual? Link to comment https://forums.phpfreaks.com/topic/129569-how-do-you-match-information-using-php/#findComment-675410 Share on other sites More sharing options...
RichardRotterdam Posted October 27, 2008 Share Posted October 27, 2008 http://www.php.net/manual/en/ Link to comment https://forums.phpfreaks.com/topic/129569-how-do-you-match-information-using-php/#findComment-675571 Share on other sites More sharing options...
The Little Guy Posted October 27, 2008 Share Posted October 27, 2008 You probably/might want to do something like this: $search = 'find this text'; $sql = mysql_query("SELECT * FROM table_name WHERE MATCH (`column1`,`column2`) AGAINST ('$search' IN BOOLEAN MODE)"); echo '<h1>Found: '.mysql_num_rows($sql).' Results</h1>'; while($row = mysql_fetch_array($sql)){ echo '<p>'.$row['column1'].' :: '.$row['column2'].'</p>'; } Link to comment https://forums.phpfreaks.com/topic/129569-how-do-you-match-information-using-php/#findComment-675581 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.