arnisi Posted June 19, 2011 Share Posted June 19, 2011 Hello to all of you, i m a university student and i decided to ask for your help because from this task it depends if i m going to pass the lesson. so please help me!!!!!!! The part that i have problem is the search part. I work at localhost, xampp and i have made a table named "logfile" in database named "uowm". My table looks like this: I have two files, the one is search.php and the other one is functions.php . The code of search.php is this one: <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> <link href="index.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="container"> <div id="maincontent"> <form method="post" action="search.php" enctype="multipart/form-data"> <p>Category: <select name="logfile"> <option value="">Please select category</option> <?php include_once("functions.php"); db_open(); db_logfile_print_option(); ?> </select></p> <input type="submit" value="submit" /> <?php if(!empty($_POST['logfile'])) { $sql ='SELECT sql_command FROM logfile WHERE log_id="'.$_POST['logfile']; @ $result = mysql_query($sql); echo "<center>The result is".$result ; echo <<<form_rt1 <center> <table border='5'> <tr> <th><b>Log ID</b></th> <th><b>User ID</b></th> <th><b>Date</b></th> <th><b>Sql command</b></th> </tr> form_rt1; include_once("functions.php"); db_open(); $sql ='SELECT * FROM logfile WHERE log_id="'.$_POST['logfile'].'"'; @ $result = mysql_query($sql); while ($row = mysql_fetch_array($result)){ echo "<tr><td>".$row['log_id']."</td>"; echo "<td>".$row['user_id']."</td>"; echo "<td>".$row['date']."</td>"; echo "<td>".$row['sql_command']."</td></tr>"; } echo <<<form_rt2 </table> </center> form_rt2; } $sql ='SELECT * FROM logfile WHERE log_id="'.$_POST['logfile'].'"'; @ $result = mysql_query($sql); ?> </form> </div> </div> </body> </html> Could you please make it work? THANK YOU SO MUCH p.s. i'm uploading the files too, if someone needs them. The code from functions.php is this one: <?php function db_open() { @ $db = mysql_connect('localhost', 'luser1', '1234') or die('Iβ€IΒµIΒ½ I?I€I?IΒIΒµIΖ’IΒµ IΒ½IΒ± IΒ³I?IΒ½IΒµI? IΖ’IΒIΒ½I/IΒµIΖ’IΒ· I?IΒµ Iβ€IΒ· IΒ²IΒ¬IΖ’IΒ· I/IΒµI/I?I?IΒIΒ½I‰IΒ½'); @ mysql_select_db('uowm') or die(' Iβ€” IΒ²IΒ¬IΖ’IΒ· I/IΒµI/I?I?IΒIΒ½I‰IΒ½ I/IΒµIΒ½ IΒ²IΒIΒI?IΒ·I?IΒµ.'); mysql_query("SET CHARACTER SET utf8"); mysql_query("SET NAMES utf8"); } function db_close() { mysql_close();} function db_logfile_print_option() { $sql='SELECT * from logfile'; @ $result = mysql_query($sql); while ($row = mysql_fetch_array($result)){ var_dump ($row); echo "<option value=\"$row[log_id]\"> $row[logfile_name]</option>"; }} function db_query($query, & $result) { @ $result = mysql_query($query) or exit('Το αίτημα απέτυχε'); } function db_logfile_print_option() { @$sql='SELECT * from logfile' ; @ $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { echo "<option value=\"$row[log_id]\"> $row[logfile_name]</option>"; } } function db_logfile_print_checkbox() { @$sql='SELECT * from logfile'; @ $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { echo "<p><label>$row[sql_command]</label><input type=\"checkbox\" name=\"logfile[]\" value=\”$row[log_id]\” </p>"; } } ?> [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/239783-logfile-search-php/ Share on other sites More sharing options...
arnisi Posted June 19, 2011 Author Share Posted June 19, 2011 I forgot to mention that the search file must contain a feature in which the user will enter a keyword, except selecting category, and it will searches the category to find the keyword and display it. please please please please help me!!!! Quote Link to comment https://forums.phpfreaks.com/topic/239783-logfile-search-php/#findComment-1231724 Share on other sites More sharing options...
arnisi Posted June 19, 2011 Author Share Posted June 19, 2011 i am also uploading the database sql file here )) PLEASE HELP ME!!!! [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/239783-logfile-search-php/#findComment-1231725 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.