?

Search Help Board

PHP FAQ
PHP Articles
PHP Help
Bulletin Board

PHP Manual (NEW!)
First Time PHP'ers
Help with programming
Sql assignment help
PHP Homework Help


C# Help

?
?need help creating a loop in this code
Author:??(---.rasserver.net)
Date:???10-15-03 18:46

this program that i want to modify now searchases the table customers for a matching email and if the match is made it checks for the password if the password fails it gives a login fail and if matches then it logs the customer in, i need it modified to do these
check for the matching email after the match is made compare the password if the password matches then login the customer if the match fails it should continue searching the db for another email match and continue this process untill either a match is made or no more customers.
i am very very new and rally know nothing about php and mysql and would really appreciate any help you can provide


/*
$Id: login.php,v 1.75 2003/02/13 03:01:49 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

Released under the GNU General Public License
*/

require('includes/application_top.php');

if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process')) {
$email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']);
$password = tep_db_prepare_input($HTTP_POST_VARS['password']);
///////////i think the search starts here
// Check if email exists
$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
if (!tep_db_num_rows($check_customer_query)) {
$HTTP_GET_VARS['login'] = 'fail';
} else {
$check_customer = tep_db_fetch_array($check_customer_query);
// Check that password is good
if (!tep_validate_password($password, $check_customer['customers_password'])) {
$HTTP_GET_VARS['login'] = 'fail';
} else {
$check_country_query = tep_db_query("select entry_country_id, entry_zone_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $check_customer['customers_id'] . "' and address_book_id = '1'");
$check_country = tep_db_fetch_array($check_country_query);

$customer_id = $check_customer['customers_id'];
$customer_default_address_id = $check_customer['customers_default_address_id'];
$customer_first_name = $check_customer['customers_firstname'];
$customer_country_id = $check_country['entry_country_id'];
$customer_zone_id = $check_country['entry_zone_id'];
tep_session_register('customer_id');
tep_session_register('customer_default_address_id');
tep_session_register('customer_first_name');
tep_session_register('customer_country_id');
tep_session_register('customer_zone_id');

$date_now = date('Ymd');
tep_db_query("update " . TABLE_CUSTOMERS_INFO . " set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 where customers_info_id = '" . $customer_id . "'");

// restore cart contents
$cart->restore_contents();

if (sizeof($navigation->snapshot) > 0) {
$origin_href = tep_href_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']);
$navigation->clear_snapshot();
tep_redirect($origin_href);
} else {
tep_redirect(tep_href_link(FILENAME_DEFAULT));
}
}
}
}

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LOGIN);

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_LOGIN, '', 'SSL'));
?>

>

">
<?php echo TITLE; ?>





























if (isset($HTTP_GET_VARS['login']) && ($HTTP_GET_VARS['login'] == 'fail')) {
$info_message = TEXT_LOGIN_ERROR;
} elseif ($cart->count_contents()) {
$info_message = TEXT_VISITORS_CART;
}

if (isset($info_message)) {
?>






}
?>




































' . TEXT_NEW_CUSTOMER_INTRODUCTION; ?>































' . TEXT_PASSWORD_FORGOTTEN . ''; ?>
' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . ''; ?>

















thanks

?Topics Author? Date
?need help creating a loop in this code??new
frankie 10-15-03 18:46?
?Re: need help creating a loop in this code??new
bastien 12-15-03 14:10?
?Re: need help creating a loop in this code??new
frank 12-17-03 06:36?
?Re: need help creating a loop in this code??new
bastien 12-22-03 06:04?
Go to Top??|??Go to Topic??|??Flat View??|??Search?
??|??
New Topic
?Reply To This Message
?Your Name:
?Your Email:
?Subject:
Email replies to this thread, to the address above.
??wrote: > > this program that i want to modify now searchases the table > customers for a matching email and if the match is made it > checks for the password if the password fails it gives a > login fail and if matches then it logs the customer in, i > need it modified to do these > check for the matching email after the match is made compare > the password if the password matches then login the customer > if the match fails it should continue searching the db for > another email match and continue this process untill either a > match is made or no more customers. > i am very very new and rally know nothing about php and mysql > and would really appreciate any help you can provide > > > /* > $Id: login.php,v 1.75 2003/02/13 03:01:49 hpdl Exp $ > > osCommerce, Open Source E-Commerce Solutions > http://www.oscommerce.com > > Copyright (c) 2003 osCommerce > > Released under the GNU General Public License > */ > > require('includes/application_top.php'); > > if (isset($HTTP_GET_VARS['action']) && > ($HTTP_GET_VARS['action'] == 'process')) { > $email_address = > tep_db_prepare_input($HTTP_POST_VARS['email_address']); > $password = > tep_db_prepare_input($HTTP_POST_VARS['password']); > ///////////i think the search starts here > // Check if email exists > $check_customer_query = tep_db_query("select > customers_id, customers_firstname, customers_password, > customers_email_address, customers_default_address_id from " > . TABLE_CUSTOMERS . " where customers_email_address = '" . > tep_db_input($email_address) . "'"); > if (!tep_db_num_rows($check_customer_query)) { > $HTTP_GET_VARS['login'] = 'fail'; > } else { > $check_customer = > tep_db_fetch_array($check_customer_query); > // Check that password is good > if (!tep_validate_password($password, > $check_customer['customers_password'])) { > $HTTP_GET_VARS['login'] = 'fail'; > } else { > $check_country_query = tep_db_query("select > entry_country_id, entry_zone_id from " . TABLE_ADDRESS_BOOK . > " where customers_id = '" . $check_customer['customers_id'] . > "' and address_book_id = '1'"); > $check_country = > tep_db_fetch_array($check_country_query); > > $customer_id = $check_customer['customers_id']; > $customer_default_address_id = > $check_customer['customers_default_address_id']; > $customer_first_name = > $check_customer['customers_firstname']; > $customer_country_id = > $check_country['entry_country_id']; > $customer_zone_id = $check_country['entry_zone_id']; > tep_session_register('customer_id'); > tep_session_register('customer_default_address_id'); > tep_session_register('customer_first_name'); > tep_session_register('customer_country_id'); > tep_session_register('customer_zone_id'); > > $date_now = date('Ymd'); > tep_db_query("update " . TABLE_CUSTOMERS_INFO . " set > customers_info_date_of_last_logon = now(), > customers_info_number_of_logons = > customers_info_number_of_logons+1 where customers_info_id = > '" . $customer_id . "'"); > > // restore cart contents > $cart->restore_contents(); > > if (sizeof($navigation->snapshot) > 0) { > $origin_href = > tep_href_link($navigation->snapshot['page'], > tep_array_to_string($navigation->snapshot['get'], > array(tep_session_name())), $navigation->snapshot['mode']); > $navigation->clear_snapshot(); > tep_redirect($origin_href); > } else { > tep_redirect(tep_href_link(FILENAME_DEFAULT)); > } > } > } > } > > require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LOGIN); > > $breadcrumb->add(NAVBAR_TITLE, > tep_href_link(FILENAME_LOGIN, '', 'SSL')); > ?> > > > > > charset="> > <?php echo TITLE; ?> > > > > > bottommargin="0" leftmargin="0" rightmargin="0"> > > > > > > > > > > > > > >
border="0" width="" cellspacing="0" > cellpadding="2"> > > > >
width="100%" cellspacing="0" cellpadding="0"> > > > > > > > if (isset($HTTP_GET_VARS['login']) && > ($HTTP_GET_VARS['login'] == 'fail')) { > $info_message = TEXT_LOGIN_ERROR; > } elseif ($cart->count_contents()) { > $info_message = TEXT_VISITORS_CART; > } > > if (isset($info_message)) { > ?> > > > > > > > } > ?> > > > >
cellpadding="0"> > > > > >
?> align="right"> 'table_background_login.gif', HEADING_TITLE, > HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?>
'100%', '10'); ?>
'100%', '10'); ?>
tep_href_link(FILENAME_LOGIN, 'action=process', 'SSL')); > ?> cellpadding="2"> > > > > > > > > > > > > >
valign="top"> valign="top"> ?>
border="0" width="100%" height="100%" cellspacing="0" > cellpadding="1" class="infoBox"> > > > >
height="100%" cellspacing="0" cellpadding="2" > class="infoBoxContents"> > > > > > > > > > >
tep_draw_separator('pixel_trans.gif', '100%', '10'); ?>
TEXT_NEW_CUSTOMER . '

' . > TEXT_NEW_CUSTOMER_INTRODUCTION; ?>
tep_draw_separator('pixel_trans.gif', '100%', '10'); ?>
border="0" width="100%" height="100%" cellspacing="0" > cellpadding="1" class="infoBox"> > > > >
height="100%" cellspacing="0" cellpadding="2" > class="infoBoxContents"> > > > > > > > > > > > > > > > > > > > > > > > > > > >
tep_draw_separator('pixel_trans.gif', '100%', '10'); ?>
TEXT_RETURNING_CUSTOMER; ?>
tep_draw_separator('pixel_trans.gif', '100%', '10'); ?>
ENTRY_EMAIL_ADDRESS; ?> tep_draw_input_field('email_address'); ?>
ENTRY_PASSWORD; ?> tep_draw_password_field('password'); ?>
tep_draw_separator('pixel_trans.gif', '100%', '10'); ?>
echo '' . TEXT_PASSWORD_FORGOTTEN . ''; ?>
tep_draw_separator('pixel_trans.gif', '100%', '10'); ?>
echo '' . tep_image_button('button_continue.gif', > IMAGE_BUTTON_CONTINUE) . ''; ?> echo tep_image_submit('button_login.gif', > IMAGE_BUTTON_LOGIN); ?>
border="0" width="" cellspacing="0" > cellpadding="2"> > > > >
> > > > > >
> > > > > > thanks ">??

Provided By
Phorum