Jump to content
Killersites Forums

Kevinstan

New Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by Kevinstan

  1. Kevinstan

    Php Search Mysql

    Hello all. I am trying to add a search field at the top of this that will allow me to search the MySQL database information and return the results in the same table view with the edit and delete options at the end of the table still. I want to be able to search by name and or id number. I cannot figure out how to do this and make it work properly. Hopefully someone in here can help me out. Thank you everyone in advance ! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>View RC Data</title> <style type="text/css"> table { border-collapse:collapse; } table td, table th { border:1px solid black;padding:5px; } tr:nth-child(even) {background: #ffffff} tr:nth-child(odd) {background: #ff0000} </style> </head> <body> <img src="logo.png" alt="logo"> <?php /* VIEW.PHP Displays all data from 'rcrentals' table */ // connect to the database include('connect-dbrc.php'); // get results from database $result = mysql_query("SELECT * FROM rcrentals") or die(mysql_error()); // display data in table // echo "<p><b>View All</b> | <a href='view-paginated.php?page=1'>View Paginated</a></p>"; echo "<table border='1' cellpadding='5'>"; echo "<tr> <th>ID</th> <th>First Name</th> <th>Last Name</th> <th>Address</th> <th>City</th> <th>State</th> <th>Zip</th> <th>Phone</th> <th>DL</th> <th>Email</th> <th>Car and Controller</th> <th></th> <th></th></tr>"; // loop through results of database query, displaying them in the table while($row = mysql_fetch_array( $result )) { // echo out the contents of each row into a table echo "<tr>"; echo '<td>' . $row['id'] . '</td>'; echo '<td>' . $row['firstname'] . '</td>'; echo '<td>' . $row['lastname'] . '</td>'; echo '<td>' . $row['address'] . '</td>'; echo '<td>' . $row['city'] . '</td>'; echo '<td>' . $row['st'] . '</td>'; echo '<td>' . $row['zip'] . '</td>'; echo '<td>' . $row['phone'] . '</td>'; echo '<td>' . $row['dl'] . '</td>'; echo '<td>' . $row['email'] . '</td>'; echo '<td>' . $row['carcont'] . '</td>'; echo '<td><a href="edit.php?id=' . $row['id'] . '">Edit</a></td>'; // echo '<td><a href="delete.php?id=' . $row['id'] . '">Delete</a></td>'; echo '<td><a href="delete.php?id=' . $row['id'] . '" onclick="return confirm(\'Confirm?\')">Delete</a></td>'; echo "</tr>"; } // close table> echo "</table>"; ?> <p><a href="../../rc/new.php">Manual Add Entry</a> :: <a href="#">Return to Main Admin Screen</a></p> </body> </html>
  2. Great script. I am trying to add a simple search function to the top of the view.php page that will search the database and show the results with the same view in table form along with the edit and delete button still. I would like for it to be searchable by id number and first name and last name. I cannot get it to work. Any help would be very much appreciated. Thanks in advance.
×
×
  • Create New...