![[H]ard|Forum](/styles/hardforum/xenforo/logo_dark.png){kind=logo}
mysql_connect($host, $user, $password);
@mysql_select_db($database) or die ("Unable to select database");
$sqlquery = "select name, number from coolpeople";
$query = mysql_query($sqlquery);
if (mysql_num_rows($query) > 0)
{
while ($record = mysql_fetch_object($query))
{
//substitute col1, col2, etc.. with column names from your DB
echo($record->col1 . " - " . $record->col2...etc..);
}
}<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "vengance") or die(mysql_error());
mysql_select_db("test1") or die(mysql_error());
// Get all the data from the "users" table
$result = mysql_query("select first_name, last_name, email from users")
or die(mysql_error());
echo "<table border='1'>";
echo "<tr> <th>First</th> <th>Last</th> <th>email</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['first_name'];
echo "</td><td>";
echo $row['last_name'];
echo "</td><td>";
echo $row['email'];
echo "</td></tr>";
}
echo "</table>";
?>
Thanks for the help.<?php
// This Query is desgined to allow a user to search for a single user and pull there information
// Jeff Flogerzi Version 1
// Make The MYSQL Connection
require_once ('mysql_connect.php');
$result = mysql_query("select first_name, last_name, email from users where last_name ='$_POST['last_name']' ")
or die(mysql_error());
if ($result) { // If Ran ok, Display the results
echo "<table border='1'>";
echo "<tr>
<th>First Name</th>
<th>Last Name</th>
<th>Email Address</th>
</tr>";
// keeps getting the next row until there are no more to get
$bg = '#ffffdd';
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['first_name'];
echo "</td><td>";
echo $row['last_name'];
echo "</td><td>";
echo $row['email'];
echo "</td></tr>";
}
echo "</table>";
mysql_free_result ($result);
} else {
echo '<p>The current information is not avabablie at this time. We sorry.</p>';
}
mysql_close();
?>
<h2>Pull User Information</h2>
<form action="experimental.php" method="post">
<p>Users Last Name: <input type="text" name="last_name" size="15" maxlength="25" value="<?php if (isset($_POST['last_name'])) echo $_POST['last_name']; ?>" /></p>
<p><input type="submit" name="submit" value="Search!" /></p>
<input type="hidden" name="submitted" value="TRUE" />
</form><?php
// This Query is desgined to allow a user to search for a single user and pull there information
// Jeff Flogerzi Version 1
// Make The MYSQL Connection
//require_once ('mysql_connect.php');
$result = mysql_query("select first_name, last_name, email from users where last_name ='$_POST[last_name]' ") or die(mysql_error());
if ($result) { // If Ran ok, Display the results
echo "<table border='1'>";
echo "<tr>
<th>First Name</th>
<th>Last Name</th>
<th>Email Address</th>
</tr>";
// keeps getting the next row until there are no more to get
$bg = '#ffffdd';
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['first_name'];
echo "</td><td>";
echo $row['last_name'];
echo "</td><td>";
echo $row['email'];
echo "</td></tr>";
}
echo "</table>";
mysql_free_result ($result);
} else {
echo '<p>The current information is not avabablie at this time. We sorry.</p>';
}
mysql_close();
?>
<h2>Pull User Information</h2>
<form action="experimental.php" method="post">
<p>Users Last Name: <input type="text" name="last_name" size="15" maxlength="25" value="<?php if (isset($_POST['last_name'])) echo $_POST['last_name']; ?>" /></p>
<p><input type="submit" name="submit" value="Search!" /></p>
<input type="hidden" name="submitted" value="TRUE" />
</form>Well that I understand. My question is how do I just show just the results. Currently the page will still include the search box and search button.
Thanks for everyone's help. One last question,does anyone know a tool that will validate PHP code just on syntax alone?
wow thanks for the tip on that. I did not know we could do that. I will go back redesign my code using bits from my first version.
Thank you very much. The second one is very useful. You see I am not a programmer and this has been tough as I am learning to develop that logic that all programmers have (at least in my eyes)OP if you're still interested in some php/mysql tutorials, try:
http://www.hudzilla.org/phpwiki
http://www.techotopia.com/index.php/PHP_Essentials