[SOLVED] Can't Solve!

Sanjib Sinha · February 14, 2009

Below is my code

<?php

for($i=1; $i<=4; $i++) {
$query = "SELECT * FROM `people` WHERE `id` = {$i}  LIMIT 0, 30 ";
$result = mysql_query($query);


if($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
   if ($row['id'] > 1 || $row['id'] < 5 )
   echo $row['id'] . "<br>";
}

}

?>

The output is:

Connected Successfully

1

2

Now I want to get only the second value. Can anyone one HELP?

Zane · February 14, 2009

pardon me for being nitpicky but try changing all that completely

You should always avoid looping a select statement....whenever possible.

Besides

SELECT * FROM `people` WHERE `id` = {$i} LIMIT 0, 30

is only going to return ONE row anyway so why limit with a range to 30

Another note

if($row =

should be while($row =

That's the only loop you need.....to loop through your results

$query = "SELECT * FROM `people` WHERE `id` IN (1,2,3,4)";
$result = mysql_query($query);


while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
   if ($row['id'] == 2)
       echo $row['id'] . "
";
}
?>

Sanjib Sinha · February 14, 2009

Many Thanks.

Actually it was my fault that I did not elaborate what I wanted.

I want to read the end value. Suppose, there are number of 'id's in 'people' that I don't know.

In such case, I want to read the last one which I could not do. I tried end function but it did not work.

Sanjib Sinha · February 14, 2009

I elaborate the problem a little bit, so that if anyone can help!

My code of new_user.php page is like this:

<?php
$my_connection = mysql_connect('localhost', 'root', '');

if (!$my_connection)
{
  die('Could not conncet: ' . mysql_error());
}

echo 'Connected Successfully' . '<br><hr>';

$my_database = mysql_select_db('a');

if (!$my_database)
{
  die('Could not find database: ' . mysql_error());
}
?>

<?php

    function mysql_prep( $value ){
$magic_quotes_active = get_magic_quotes_gpc();
$new_enough_php = function_exists( "mysql_real_escape_string" ); // i.e. PHP >= v4.3.0
if( $new_enough_php ){ // PHP v4.3.0 or higher
	/*undo any magic quote efects so mysql_real_escape_string can do the work */
	if( $magic_quotes_active ){ $value = stripslashes( $value ); }
	$value = mysql_real_escape_string( $value );
} else { // before PHP v4.3.0
// if magic quotes aren't already on them add slashes manually
if( !$magic_quotes_active ){ $value = addslashes( $value ); }
// if magic quotes are active, then the slashes already exist
}
    return $value;
}
?>
<?php
function check_required_fields($required_array){
$field_errors = array();
foreach($required_array as $fieldname){
	if (!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && $_POST[$fieldname] != 0)){
	 $field_errors[] = $fieldname;
	}
}
return $field_errors;
}

function check_max_field_lengths($field_length_array){
$field_errors = array();
foreach($field_length_array as $fieldname => $maxlength){
	if (strlen(trim(mysql_prep($_POST[$fieldname]))) > $maxlength){	$field_errors[] = $fieldname; }
}
return $field_errors;
}


function display_errors($error_array){
echo "<p class=\"errors\">";
echo "Please review the following fields:<br />";
foreach($error_array as $error) {
	echo " - " . $error . "<br />";
}
echo "</p>";
}
?>

<?php
// START FORM PROCESSING
if (isset($_POST['submit'])) { // form has been submitted.
        $errors = array();
        
        // perform validation on the form data
        $required_fields = array('first_name', 'last_name', 'url', 'email');
        $errors = array_merge($errors, check_required_fields($required_fields, $_POST));    
    	 
        $fields_with_lengths = array('first_name' => 30, 'last_name' => 30, 'url' => 50, 'email' => 30);
        $errors = array_merge($errors, check_max_field_lengths($fields_with_lengths, $_POST));        

        $first_name = trim(mysql_prep($_POST['first_name']));
    $last_name = trim(mysql_prep($_POST['last_name']));
    $url = trim(mysql_prep($_POST['url']));
    $email = trim(mysql_prep($_POST['email']));
    
    if(empty($errors)) {
	$query = "INSERT INTO people ( first_name, last_name, url, email ) VALUES ( '{$first_name}', '{$last_name}', '{$url}', '{$email}' )";
    $result = mysql_query($query);
    if (mysql_affected_rows() == 1) {
	// Success
	$message = "The user was successfully created. " . "<a href=\"login.php\">Now you can Login</a>";
	echo $message;
} else {
	$message = "The user could not be created. ";
	$message .= "<br />" . mysql_error();
}
    } else {
	if (count($errors) == 1){
		$message = "There was one error in the form.";
	} else {
		$message = "There were " . count($errors) . " errors in the form.";
	}
}
// END FORM PROCESSING




} else { // form has not been submitted
$first_name = "";
$last_name = ""; 
$url = ""; 
$email = ""; 
} 

?>

<form action="new_user.php" method="post">
<table>
<tr>
<td>First Name</td>
<td><input type="text" name="first_name" maxlength="30" value="<?php echo htmlentities($first_name); ?>" /></td>
</tr>
<tr>
<td>Last Name</td>
<td><input type="text" name="last_name" maxlength="30" value="<?php echo htmlentities($last_name); ?>" /></td>
</tr>
<tr>
<td>Favourite Website</td>
<td><input type="text" name="url" maxlength="50" value="<?php echo htmlentities($url); ?>" /></td>
</tr>
<tr>
<td>Your E-mail</td>
<td><input type="text" name="email" maxlength="30" value="<?php echo htmlentities($email); ?>" /></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="submit" value="Create user" /></td>
</tr>
</table>
</form>
</td>
</tr>
</table>



        
<?php mysql_close($my_connection); ?>

The code of login.php is like this:

<?php
$my_connection = mysql_connect('localhost', 'root', '');

if (!$my_connection)
{
  die('Could not conncet: ' . mysql_error());
}

echo 'Connected Successfully' . '<br><hr>';

$my_database = mysql_select_db('a');

if (!$my_database)
{
  die('Could not find database: ' . mysql_error());
}
?>
<?php
  function redirect_to( $location = NULL ){
if ($location != NULL){
	header("Location: {$location}");
	exit;
}
    }
?>
    
<?php

    function mysql_prep( $value ){
$magic_quotes_active = get_magic_quotes_gpc();
$new_enough_php = function_exists( "mysql_real_escape_string" ); // i.e. PHP >= v4.3.0
if( $new_enough_php ){ // PHP v4.3.0 or higher
	/*undo any magic quote efects so mysql_real_escape_string can do the work */
	if( $magic_quotes_active ){ $value = stripslashes( $value ); }
	$value = mysql_real_escape_string( $value );
} else { // before PHP v4.3.0
// if magic quotes aren't already on them add slashes manually
if( !$magic_quotes_active ){ $value = addslashes( $value ); }
// if magic quotes are active, then the slashes already exist
}
    return $value;
}
?>

<?php
function check_required_fields($required_array){
$field_errors = array();
foreach($required_array as $fieldname){
	if (!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && $_POST[$fieldname] != 0)){
	 $field_errors[] = $fieldname;
	}
}
return $field_errors;
}

function check_max_field_lengths($field_length_array){
$field_errors = array();
foreach($field_length_array as $fieldname => $maxlength){
	if (strlen(trim(mysql_prep($_POST[$fieldname]))) > $maxlength){	$field_errors[] = $fieldname; }
}
return $field_errors;
}

function display_errors($error_array){
echo "<p class=\"errors\">";
echo "Please review the following fields:<br />";
foreach($error_array as $error) {
	echo " - " . $error . "<br />";
}
echo "</p>";
}
?>

<?php
// START FORM PROCESSING
if (isset($_POST['submit'])) { // form has been submitted.
        $errors = array();
        
        // perform validation on the form data
        $required_fields = array('first_name', 'last_name', 'url', 'email');
        $errors = array_merge($errors, check_required_fields($required_fields, $_POST));    
    	 
        $fields_with_lengths = array('first_name' => 30, 'last_name' => 30, 'url' => 50, 'email' => 30);
        $errors = array_merge($errors, check_max_field_lengths($fields_with_lengths, $_POST));
              
        $first_name = trim(mysql_prep($_POST['first_name']));
    $last_name = trim(mysql_prep($_POST['last_name']));
    $url = trim(mysql_prep($_POST['url']));
    $email = trim(mysql_prep($_POST['email']));
    
    if(empty($errors)) {
    	$query = "SELECT id, first_name ";
	$query .= "FROM people ";
	$query .= "WHERE first_name = '{$first_name}' ";
	$query .= "AND last_name = '{$last_name}' ";
	$query .= "AND url = '{$url}' ";
	$query .= "AND email = '{$email}' ";
	$query .= "LIMIT 1";
	$result_set = mysql_query($query);

    if (mysql_num_rows($result_set) == 1) {
	// username/password authinticated
	// and only 1 match
	// echo "You can login";
	redirect_to("ab.php");		

        } else {
	if (count($errors) == 1){
		$message = "There was 1 error in the form.";
	} else {
		$message = "There were " . count($errors) . " errors in the form.";
	}
	}

} else { // form has not been submitted.
if (isset($_GET['logout']) && $_GET['logout'] == 1) {
$message = "You are logged out.";
} echo $maessage;
$first_name = "";
$last_name = ""; 
$url = ""; 
$email = ""; 
}
} 
?>


<form action="login.php" method="post">
<table>
<tr>
<td>First Name</td>
<td><input type="text" name="first_name" maxlength="30" value="<?php echo htmlentities($first_name); ?>" /></td>
</tr>
<tr>
<td>Last Name</td>
<td><input type="text" name="last_name" maxlength="30" value="<?php echo htmlentities($last_name); ?>" /></td>
</tr>
<tr>
<td>Favourite Website</td>
<td><input type="text" name="url" maxlength="50" value="<?php echo htmlentities($url); ?>" /></td>
</tr>
<tr>
<td>Your E-mail</td>
<td><input type="text" name="email" maxlength="30" value="<?php echo htmlentities($email); ?>" /></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="submit" value="LogIn" /></td>
</tr>
</table>
</form>
</td>
</tr>
</table>

<?php mysql_close($my_connection); ?>

:-\

Now if anyone filled up the form and logged in, the datas go directly to the the database in the table "people".

I want to read the 'id' of people which is auto-incremented with every entry. If I use "SELECT * FROM people", the whole bunch of 'id's come out. I don't want the whole thing. I want only the 'end' 'id'.

Any IDEA?

allworknoplay · February 14, 2009

Now if anyone filled up the form and logged in, the datas go directly to the the database in the table "people".

I want to read the 'id' of people which is auto-incremented with every entry. If I use "SELECT * FROM people", the whole bunch of 'id's come out. I don't want the whole thing. I want only the 'end' 'id'.

Any IDEA?

Yeah this is easy. Just "SELECT * FROM people...." and order by ID DESC".

This will get you all the records but return the last entry to the top.

Then you don't even have to do a loop, you just output your return query and it will only give you

the last entry.

Sanjib Sinha · February 14, 2009

Many Many thanks. I found another way where every user find their 'id' along with 'first_name' and 'last_name' .

The code is:

<?php
$result = mysql_query("SELECT id, first_name, last_name FROM people", $my_connection);
while (list($id, $first_name, $last_name) = mysql_fetch_row($result)) {
    echo " <tr>\n" .
          "  <td><a href=\"content.php?id=$id\">$first_name . $id</a></td>\n" .
          "  <td>$last_name</td>\n" .
          " </tr>\n";
}


?>

It gives a nice link where anyone can click the his/her name and author_id link and land up in the main page.

Sign In

[SOLVED] Can't Solve!

Recommended Posts

Sanjib Sinha

Link to comment

Share on other sites

Zane

Link to comment

Share on other sites

Sanjib Sinha

Link to comment

Share on other sites

Sanjib Sinha

Link to comment

Share on other sites

allworknoplay

Link to comment

Share on other sites

Sanjib Sinha

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information