trac26
-
Posts
4 -
Joined
-
Last visited
trac26's Achievements
Newbie (1/5)
0
Reputation
-
So I tried this and I receive this error message: Parse error: syntax error, unexpected T_LNUMBER in /var/search.php on line 65 I am using a text editor: sublime text.
-
So this code is more organized, but I still receive an error on this line: if( isset($_GET['search']) . Here is the updated code: <?php require_once "../db/connect.php"; // make link here $link = $db->_impl; // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta name="keywords" content="" /> <meta name="description" content="" /> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Employee</title> <link href="style.css" rel="stylesheet" type="text/css" media="screen" /> </head> <body> <div id="wrapper"><!-- end #header --> <div id="menu-wrapper"> <div id="menu"> <ul> <li><a href="index.php">Home</a></li> <li><a href="department.php">department</a></li> <li><a href="contact.php">Contact</a></li> <li class="current_page_item"><a href="search.php">Search</a></li> <li><a href="#"> </a></li> <li><a href="#"> </a></li> <li><a href="#"> </a></li> <li><a href="#"> </a></li> <li><a href="logout.php">Logout</a></li> </ul> </div> </div> <!-- end #menu --> <div id="page"> <div id="page-bgtop"> <div id="page-bgbtm"> <div id="page-content"> <div id="content"> <div class="post"> <h2 class="title">Search document:</h2> <p> </p> <p>Enter a document name below to search...</p> <!-- search --> <div class="search"> <form method="get" id="searchform" action="search.php"> <input type="hidden" name="searching" value="yes" /> <input type="text" value = "Search here..." name="search" id="search" /> <input type="submit" id="searchSubmit" name="searchSubmit" value= "Find" /> </form> </div> <!-- ENDS search --> <?php /* Where are you accessing the $_GET[] array for the $search or $searching results? if(isset($_POST['upload'])) { $fileName = $_FILES['userfile']['name']; $tmpName = $_FILES['userfile']['tmp_name']; $fileSize = $_FILES['userfile']['size']; $fileType = $_FILES['userfile']['type']; $fp = fopen($tmpName, 'r'); $content = fread($fp, filesize($tmpName)); $content = addslashes($content); fclose($fp); if(!get_magic_quotes_gpc()) { $fileName = addslashes($fileName); } $query = "INSERT INTO TDBOE (Description, name,size, data ) ". "VALUES ('THIS IS A TEST', '$fileName', '$fileSize', '$fileType', '$content')"; mysqli_query($link, $query) or die('Error, query failed'); echo "<br>File $fileName uploaded<br>"; } if( isset($_GET['search']) { $search = $_GET['search']; if ($search == "") { echo "<p>No search criteria specified</p>"; exit; } echo "<h2>Results:</h2><p>"; $sql = 'SELECT * FROM PROPOSALS p WHERE p.Name LIKE '%$search%''; $result = mysqli_query($link, $sql); //if no matches in DB $matches=mysqli_num_rows($data); if ($matches == 0) { echo "Sorry, but we can not find an entry to match your query<br><br>"; } while ($row = mysqli_fetch_array($link, $result)) { echo " SEARCH RETURNED RESULTS! "; } } } */ ?> ?> <div class="post"> <h2 class="title"> </h2> <p class="meta"> </div> <div style="clear: both;"></div> </div> <!-- end #content --> </div> </div> </div> </div> <!-- end #page --> </div> <div id="footer"> </div> <!-- end #footer --> </body> </html>
-
Thanks for the tips. I am working on it now and will mark solved if it works.
-
Hi I have a search page that is not working. Can anyone tell me how I can fix my code below to make it work? Thank You <?php require_once "../db/connect.php"; // make link here $link = $db->_impl; // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta name="keywords" content="" /> <meta name="description" content="" /> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Employee</title>link href="style.css" rel="stylesheet" type="text/css" media="screen" /> </head> <body> <div id="wrapper"><!-- end #header --> <div id="menu-wrapper"> <div id="menu"> <ul> <li><a href="index.php">Home</a></li> <li><a href="TDBOE.php">Department</a></li> <li><a href="contact.php">Contact</a></li> <li class="current_page_item"><a href="search.php">Search</a></li> <li><a href="#"> </a></li> <li><a href="#"> </a></li> <li><a href="#"> </a></li> <li><a href="#"> </a></li> <li><a href="logout.php">Logout</a></li> </ul> </div> </div> <!-- end #menu --> <div id="page"> <div id="page-bgtop"> <div id="page-bgbtm"> <div id="page-content"> <div id="content"> <div class="post"> <h2 class="title">Search Proposals:</h2> <p> </p> <p>Enter a proposal name below to search...</p> <!-- search --> <div class="search"> <form method="get" id="searchform" action="search.php"> <input type="hidden" name="searching" value="yes" /> <input type="text" value = "Search here..." name="search" id="search" /> <input type="submit" id="searchSubmit" name="searchSubmit" value= "Find" /> </form> </div> <!-- ENDS search --> <?php //error handling//////////// //If they did not enter a search term, show an error if ($search == "") { echo "<p>You forgot to enter a search term"; exit; } //entered a value, show results //Only displayed if they have submitted the form if ($searching == "yes") { echo "<h2>Results:</h2><p>"; } $sql = 'SELECT * FROM PROPOSALS p WHERE p.Name LIKE '%$searchSubmit%''; $result = mysqli_query($link, $sql); //if no matches in DB $matches=mysql_num_rows($data); if ($matches == 0) { echo "Sorry, but we can not find an entry to match your query<br><br>"; } while ($row = mysqli_fetch_array($link, $sql)) { echo " SEARCH RETURNED RESULTS! "; } ?> <div class="post"> <h2 class="title"> </h2> <p class="meta"> </div> <div style="clear: both;"></div> </div> <!-- end #content --> </div> </div> </div> </div> <!-- end #page --> </div> <div id="footer"> </div> <!-- end #footer --> </body> </html>