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
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="> > > > > > > bottommargin="0" leftmargin="0" rightmargin="0"> > > > > > >