本文整理汇总了PHP中mysql_query_with_throw函数的典型用法代码示例。如果您正苦于以下问题：PHP mysql_query_with_throw函数的具体用法？PHP mysql_query_with_throw怎么用？PHP mysql_query_with_throw使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_query_with_throw函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: parseXmlAndUpdateDB
function parseXmlAndUpdateDB($xmlData, $user_id, $score_id)
{
$clean_xml = str_ireplace(['SOAP-ENV:', 'SOAP:'], '', $xmlData);
$xml = simplexml_load_string($clean_xml);
//print_r($xml);
//echo "<h1>List Of Account</h1>";
$CAIS_Account = $xml->CAIS_Account;
// Fetch Main Object from XML
foreach ($CAIS_Account->CAIS_Account_DETAILS as $Account_Details) {
global $count;
$count = $count + 1;
$Account_Number = $Account_Details->Account_Number;
$account_number = $Account_Number['0'];
$Subscriber_Name = $Account_Details->Subscriber_Name;
$subscriber_name = $Subscriber_Name['0'];
// add additional details
$Value_of_Collateral = $Account_Details->Value_of_Collateral;
$value_of_collateral = $Value_of_Collateral['0'];
$Type_of_Collateral = $Account_Details->Type_of_Collateral;
$type_of_collateral = $Type_of_Collateral['0'];
$Date_Reported = $Account_Details->Date_Reported;
$date_reported = $Date_Reported['0'];
$Current_Balance = $Account_Details->Current_Balance;
$current_balance = $Current_Balance['0'];
$Amount_Past_Due = $Account_Details->Amount_Past_Due;
$amount_past_due = $Amount_Past_Due['0'];
// end additionals details
$sql_accounts = "update tbl_getaccounts set date_reported='{$date_reported}', \n current_balance='{$current_balance}',amount_due='{$amount_past_due}', value_collateral='{$value_of_collateral}',\n type_collateral='{$type_of_collateral}' where user_id='{$user_id}' and account_number='{$account_number}' and \n subscriber_name='{$subscriber_name}';";
$exe = mysql_query_with_throw($sql_accounts);
}
return True;
}示例2: exportMysqlToCsv
function exportMysqlToCsv($table, $filename = 'export.csv')
{
$csv_terminated = "\n";
$csv_separator = ",";
$csv_enclosed = '"';
$csv_escaped = "\\";
$sql_query = "select * from {$table}";
// Gets the data from the database
$result = mysql_query_with_throw($sql_query);
$fields_cnt = mysql_num_fields($result);
$schema_insert = '';
for ($i = 0; $i < $fields_cnt; $i++) {
$l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;
$schema_insert .= $l;
$schema_insert .= $csv_separator;
}
// end for
$out = trim(substr($schema_insert, 0, -1));
$out .= $csv_terminated;
// Format the data
while ($row = mysql_fetch_array($result)) {
$schema_insert = '';
for ($j = 0; $j < $fields_cnt; $j++) {
if ($row[$j] == '0' || $row[$j] != '') {
if ($csv_enclosed == '') {
$schema_insert .= $row[$j];
} else {
$schema_insert .= $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;
}
} else {
$schema_insert .= '';
}
if ($j < $fields_cnt - 1) {
$schema_insert .= $csv_separator;
}
}
// end for
$out .= $schema_insert;
$out .= $csv_terminated;
}
// end while
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Length: " . strlen($out));
// Output to browser with appropriate mime type, you choose ;)
header("Content-type: text/x-csv");
//header("Content-type: text/csv");
//header("Content-type: application/csv");
header("Content-Disposition: attachment; filename={$filename}");
echo $out;
exit;
}示例3: strtolower
$add_file_name1 = $_FILES['addfile1']['name'];
$add_file_size1 = $_FILES['addfile1']['size'];
$add_file_tmp1 = $_FILES['addfile1']['tmp_name'];
$add_file_type1 = $_FILES['addfile1']['type'];
$add_file_ext1 = strtolower(end(explode('.', $_FILES['addfile1']['name'])));
$rand3 = rand(100000, 999999);
$filePath3 = $target_dir . $rand3 . $user_id . "addproof1." . $add_file_ext1;
$add_name1 = $rand3 . $user_id . "addproof1." . $add_file_ext1;
$result = move_uploaded_file($add_file_tmp1, $filePath3);
if (!$result) {
$errors[] = "Error: File could not be uploaded: " . $add_file_name1;
}
}
if (empty($errors)) {
$send_kyc = sendmail_attachment($filePath1, $id_name, $filePath2, $add_name, $score_id, $filePath3, $add_name1);
$experan_data = mysql_query_with_throw("INSERT INTO `tbl_uploadkyc` ( `user_id` ,`status` ) \n VALUES ('{$user_id}' ,1);");
$text = TRUE;
}
}
if (!empty($errors)) {
//report the errors
echo '<div id="gt-formfeedback"><b><font size="4">WHOOPS! Please review the following issues:</font></b><ul>';
foreach ($errors as $msg) {
//prints each error
echo "<li>{$msg}</li>";
}
// end of foreach
echo '</ul></div>';
}
}
if ($text) {示例4: VALUES
//Initialize error array
if (empty($_POST['gtname'])) {
$errors[] = "Name field can't be blank!";
}
if (empty($_POST['gtemailid'])) {
$errors[] = "Email field can't be blank!";
} else {
if (!eregi('^[[:alnum:]][a-z0-9_\\.\\-]*@[a-z0-9\\.\\-]+\\.[a-z]{2,4}$', stripslashes(trim($_POST['gtemailid'])))) {
$errors[] = 'Please provide a <strong>valid email address</strong>!';
}
}
if (empty($errors)) {
if (isUnique("email", $_POST['gtemailid'], "tbl_newsletter")) {
// Insert data into database
$gtregquery = "INSERT INTO `tbl_newsletter` (`id`, `name`, `email`, `status`, `add_date`) VALUES (NULL, '{$rwsfname}', '{$rwsuemailid}', '1', NOW())";
$gtresult = mysql_query_with_throw($gtregquery);
$subject = "Newsletter Registration on {$sitename} - by " . $rwsfname;
$body = '<table width="634" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td height="52" bgcolor="#00798c"><font style="font-family:Arial, Helvetica, sans-serif; font-size:24px; font-weight:bold; color:#FFFFFF;"> <span class="style1">' . $sitename . ' - </span></font><span style="color: #FFFFFF"><strong><font style="font-family:Arial, Helvetica, sans-serif; font-size:24px; color:#ffffff;"> Contact us details</font></strong></span></td>
</tr>
<tr>
<td align="left" valign="middle"><table width="633" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="22" colspan="2" align="left" valign="middle"></td>
</tr>
<tr>
<td width="227" height="30" align="left" valign="middle"><span style="color: #FFFFFF"><font style="font-family:Arial, Helvetica, sans-serif; font-size:12px; font-weight:bold; color:#333333"> Name:</font></span></td>
<td width="406" height="30" align="left" valign="middle"><font style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000;">' . stripslashes($rwsfname) . '</font></td>
</tr>
<tr>示例5: elseif
} elseif ($pagenum < $max_pages && $pagenum > 0) {
$pageshow = $pagenum;
} elseif ($pagenum <= 0) {
$pageshow = '1';
} else {
$pageshow = '1';
}
} else {
$pageshow = '1';
}
$begin = $pageshow - 1;
$start = $begin * $per_page;
if (!$start) {
$start = 0;
}
$getquery = mysql_query_with_throw($constructs . " ORDER BY refresh_date DESC LIMIT {$start}, {$per_page}");
while ($runrows = mysql_fetch_assoc($getquery)) {
$JobID = $runrows['JobID'];
$jobpostsubject = $runrows['jobpostsubject'];
$jobpostlocationtowncity = $runrows['jobpostlocationtowncity'];
$jobpostlocationcounty = $runrows['jobpostlocationcounty'];
$jobpostpostcode = $runrows['jobpostpostcode'];
$jobpostjobtype = $runrows['jobpostjobtype'];
$jobpostsalary = $runrows['jobpostsalary'];
$jobpostsectorindustry = $runrows['jobpostsectorindustry'];
$jobpostdescription = $runrows['jobpostdescription'];
$keywords = $runrows['keywords'];
$jobpostrecruiteremployer = $runrows['jobpostrecruiteremployer'];
$jobpostrecruitercontactperson = $runrows['jobpostrecruitercontactperson'];
$jobpostcontactnumber = $runrows['jobpostcontactnumber'];
$jobpostrecruiteremployeremail = $runrows['jobpostrecruiteremployeremail'];示例6: mysql_query_with_throw
<?php
include "../includes/config.php";
$acid = $_GET["id"];
$query = "SELECT t1.*,t2.id as ac_id,t2.account,t2.balance,t2.bank,t2.status,t2.alert,t2.account_no,t2.date_opened,t2.date_closed,t2.dateofbirth,t2.pancard,t2.notes,t2.principal, t2.interest, t2.other_charges, t2.last_payment_date, t2.last_payment_done, t2.product_type, t2.cibil_status, t2.unikdueid FROM `tbl_userdetails` as t1 INNER JOIN `tbl_accounts` as t2 ON t1.id=t2.userid WHERE t2.id=" . $_GET['id'];
$rs = mysql_query_with_throw($query);
$row = mysql_fetch_assoc($rs);
$userid = $row["id"];
$firstname = $row["firstname"];
$lastname = $row["lastname"];
$email = $row["email"];
$mobile = $row["mobile"];
$account_no = $row["account_no"];
$email = $row["email"];
?>
<script type="text/javascript" src="resources/scripts/jquery-1.3.2.min.js"></script>
<script language="javascript" type="text/javascript">
function validatenewscommentform()
{
flag=2;
formObj1 = document.rwschangepass;
if(formObj1.offeramt.value=="")
{
alert("Offer Amount field cannot be blank!");
document.getElementById("offeramt").focus();
return false;
}
if(isNaN(formObj1.offeramt.value))
{
alert("Offer Amount field contains only digits!");示例7: mysql_query_with_throw
<div class="gt-label"> </div>
<div class="gt-formfields"><img id="captcha" src="<?php
echo $baseurl;
?>
securimage/securimage_show.php" alt="CAPTCHA Image" /><input type="text" name="captcha_code" size="10" maxlength="6" id="gtcaptchcode"/><a href="#" onclick="document.getElementById('captcha').src = 'securimage/securimage_show.php?' + Math.random(); return false">[ Different Image ]</a></div>
</div>
Field Content Ends -->
<div class="gt-fields gt-buttoncentre"><input type="submit" name="button" id="button" value="Submit" class="rwsbutton" /></div>
<!-- Field Content Ends -->
</form>
<?php
} else {
$sql = 'SELECT * FROM `tbl_userdetails` WHERE id = "' . $_SESSION['GTUserID'] . '"';
$rs = mysql_query_with_throw($sql);
$row = mysql_fetch_assoc($rs);
$_SESSION['myForm']['firstname'] = stripslashes($row['firstname']);
$_SESSION['myForm']['middlename'] = stripslashes($row['middlename']);
$_SESSION['myForm']['lastname'] = stripslashes($row['lastname']);
$_SESSION['myForm']['email'] = stripslashes($row['email']);
$_SESSION['myForm']['password'] = stripslashes($row['password']);
$_SESSION['myForm']['mobile'] = stripslashes($row['mobile']);
$_SESSION['myForm']['address1'] = stripslashes($row['address1']);
$_SESSION['myForm']['address2'] = stripslashes($row['address2']);
$_SESSION['myForm']['city'] = stripslashes($row['city']);
$_SESSION['myForm']['state'] = stripslashes($row['state']);
$_SESSION['myForm']['country'] = stripslashes($row['country']);
$_SESSION['myForm']['pincode'] = stripslashes($row['pincode']);
$_SESSION['myForm']['imgurl'] = stripslashes($row['imgurl']);
$_SESSION['myForm']['id_proof'] = stripslashes($row['id_proof']);示例8: addslashes
$bank = addslashes($_POST['bank']);
$postid = $_POST["postid"];
if ($postid != "") {
$query = "UPDATE `tbl_bankperson` SET `name` = '{$title}', `email` = '{$email}', `password` = '{$password}', `mobile` = '{$mobile}', `bank` = '{$bank}' WHERE `id` = '{$postid}'";
} else {
$query = "INSERT INTO `tbl_bankperson` ( `id` , `name` , `email`, `password` , `mobile`, `bank` , `status` , `last_login` , `add_date`) VALUES (0, '{$title}', '{$email}', '{$password}', '{$mobile}', '{$bank}', '1', '', NOW())";
}
$result = mysql_query_with_throw($query);
echo "<script>document.location.href='view_bankperson.php?page=person'</script>";
/*$message = "Slideshow image has been added successfully.";
$class='successmsg';*/
}
$eid = $_GET["id"];
//code for addind news in the datbase ends here
$qedit = "SELECT * FROM `tbl_bankperson` WHERE `id` ='{$eid}'";
$redit = mysql_query_with_throw($qedit);
$row = mysql_fetch_assoc($redit);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>ADMIN CONSOLE // <?php
echo $sitename;
?>
Website</title>
<link rel="stylesheet" href="resources/css/reset.css" type="text/css" media="screen" />
<link rel="stylesheet" href="resources/css/style.css" type="text/css" media="screen" />
<link rel="stylesheet" href="resources/css/invalid.css" type="text/css" media="screen" />
<!-- Internet Explorer Fixes Stylesheet -->
<!--[if lte IE 7]>示例9: parseXmlAndUpdateDB
function parseXmlAndUpdateDB($xmlData, $user_id, $score_id)
{
$clean_xml = str_ireplace(['SOAP-ENV:', 'SOAP:'], '', $xmlData);
$xml = simplexml_load_string($clean_xml);
//print_r($xml);
$created_date = date('Y-m-d H:i:s');
//echo "<h1>Score Related Details</h1>";
$CreditProfileHeader = $xml->CreditProfileHeader;
// Fetch Main Object from XML
$Enquiry_Username = $CreditProfileHeader->Enquiry_Username;
$enq_username = $Enquiry_Username['0'];
$ReportDate = $CreditProfileHeader->ReportDate;
$report_date = $ReportDate['0'];
$ReportNumber = $CreditProfileHeader->ReportNumber;
$report_number = $ReportNumber['0'];
$Subscriber = $CreditProfileHeader->Subscriber;
$subscriber = $Subscriber['0'];
$Subscriber_Name = $CreditProfileHeader->Subscriber_Name;
$subscriber_name = $Subscriber_Name['0'];
$Current_Application_Details = $xml->Current_Application->Current_Application_Details;
// Fetch Main Object from XML
$Enquiry_Reason = $Current_Application_Details->Enquiry_Reason;
$enquiry_reason = $Enquiry_Reason['0'];
$Finance_Purpose = $Current_Application_Details->Finance_Purpose;
$finance_purpose = $Finance_Purpose['0'];
$Amount_Financed = $Current_Application_Details->Amount_Financed;
$amount_financed = $Amount_Financed['0'];
$Duration_Of_Agreement = $Current_Application_Details->Duration_Of_Agreement;
$duration_agreement = $Duration_Of_Agreement['0'];
//echo "<h1>SCORE</h1>";
$SCORE = $xml->SCORE;
// Fetch Main Object from XML
$score = $SCORE->BureauScore;
$score_level = $SCORE->BureauScoreConfidLevel;
//echo "<h1>Current Applicant Details</h1>";
//$Applicant_Details = $xml->Current_Application->Current_Application_Details->Current_Applicant_Details; // Fetch Main Object from XML
//echo "<h1>Account Details</h1>";
$Credit_Account = $xml->CAIS_Account->CAIS_Summary->Credit_Account;
// Fetch Main Object from XML
$CreditAccountTotal = $Credit_Account->CreditAccountTotal;
$accounts_total = $CreditAccountTotal['0'];
$CreditAccountActive = $Credit_Account->CreditAccountActive;
$accounts_active = $CreditAccountActive['0'];
$CreditAccountClosed = $Credit_Account->CreditAccountClosed;
$accounts_closed = $CreditAccountClosed['0'];
$CreditAccountDefault = $Credit_Account->CreditAccountDefault;
$accounts_default = $CreditAccountDefault['0'];
$Total_Outstanding_Balance = $xml->CAIS_Account->CAIS_Summary->Total_Outstanding_Balance;
// Fetch Main Object from XML
$Outstanding_Balance_Secured = $Total_Outstanding_Balance->Outstanding_Balance_Secured;
$os_balance_secured = $Outstanding_Balance_Secured['0'];
$Outstanding_Balance_UnSecured = $Total_Outstanding_Balance->Outstanding_Balance_UnSecured;
$os_balance_unsecured = $Outstanding_Balance_UnSecured['0'];
// Insert all data into table tbl_getscore_details
$sql_score_details = "INSERT INTO `tbl_getscore_details` ( `user_id` , `score_id` , `score` ,\n`score_level` , `enq_username` , `report_date` , `report_number` , `subscriber` ,\n`subscriber_name` , `enquiry_reason` , `finance_purpose` , `amount_financed` , `duration_agreement` ,\n`accounts_total` , `accounts_active` , `accounts_closed` , `accounts_default` , `os_balance_secured` ,\n`os_balance_unsecured` , `created` )\nVALUES ('{$user_id}', '{$score_id}', '{$score}', '{$score_level}', '{$enq_username}', '{$report_date}',\n'{$report_number}', '{$subscriber}', '{$subscriber_name}', '{$enquiry_reason}', '{$finance_purpose}',\n'{$amount_financed}', '{$duration_agreement}', '{$accounts_total}', '{$accounts_active}',\n'{$accounts_closed}', '{$accounts_default}', '{$os_balance_secured}', '{$os_balance_unsecured}', '{$created_date}');";
$exe = mysql_query_with_throw($sql_score_details);
//echo "<h1>List Of Account</h1>";
$CAIS_Account = $xml->CAIS_Account;
// Fetch Main Object from XML
foreach ($CAIS_Account->CAIS_Account_DETAILS as $Account_Details) {
$Identification_Number = $Account_Details->Identification_Number;
$identification_number = $Identification_Number['0'];
$Subscriber_Name = $Account_Details->Subscriber_Name;
$subscriber_name = $Subscriber_Name['0'];
$Account_Number = $Account_Details->Account_Number;
$account_number = $Account_Number['0'];
$Portfolio_Type = $Account_Details->Portfolio_Type;
$portfolio_type = $Portfolio_Type['0'];
$Account_Type = $Account_Details->Account_Type;
$account_type = $Account_Type['0'];
$Open_Date = $Account_Details->Open_Date;
$date_open = $Open_Date['0'];
$Highest_Credit_Loan_Amount = $Account_Details->Highest_Credit_or_Original_Loan_Amount;
$highcredit_loanamount = $Highest_Credit_Loan_Amount = $Highest_Credit_Loan_Amount['0'];
$Terms_Duration = $Account_Details->Terms_Duration;
$terms_duration = $Terms_Duration['0'];
$Account_Status = $Account_Details->Account_Status;
$account_status = $Account_Status['0'];
$Date_Closed = $Account_Details->Date_Closed;
$date_closed = $Date_Closed['0'];
// add additional details
$Value_of_Collateral = $Account_Details->Value_of_Collateral;
$value_of_collateral = $Value_of_Collateral['0'];
$Type_of_Collateral = $Account_Details->Type_of_Collateral;
$type_of_collateral = $Type_of_Collateral['0'];
$Date_Reported = $Account_Details->Date_Reported;
$date_reported = $Date_Reported['0'];
$Current_Balance = $Account_Details->Current_Balance;
$current_balance = $Current_Balance['0'];
$Amount_Past_Due = $Account_Details->Amount_Past_Due;
$amount_past_due = $Amount_Past_Due['0'];
// end additionals details
$Date_of_Last_Payment = $Account_Details->Date_of_Last_Payment;
$date_last_payment = $Date_of_Last_Payment['0'];
$AccountHoldertypeCode = $Account_Details->AccountHoldertypeCode;
$acc_holder_type = $AccountHoldertypeCode['0'];
$CurrencyCode = $Account_Details->CurrencyCode;
$currency = $CurrencyCode['0'];
$CAIS_Account_History_Due_date = $Account_Details->CAIS_Account_History->Days_Past_Due;
$last_history_duedays = $CAIS_Account_History_Due_date['0'];
//.........这里部分代码省略.........
示例10: mysql_query_with_throw
}
}
}
</script>
<form method="post" action="" name="form1" class="rws-viewapplicants" >
<?php
// select records from database
$sql = 'SELECT * FROM `uk_job_applicants` WHERE jobid = "' . $_GET['jobid'] . '" ';
$rs = mysql_query_with_throw($sql);
$perpage = 20;
$currentpage = $_REQUEST['currentpage'] ? $_REQUEST['currentpage'] : '1';
$startrecord = ($currentpage - 1) * $perpage;
$totalrows = mysql_num_rows($rs);
$result = mysql_query_with_throw($sql . " order by add_date desc LIMIT {$startrecord}, {$perpage}") or die(mysql_error());
$header = '<div class="jobsdata"><div class="row header"><div class="checkboxdiv"><input name="chkSelectAll" type="checkbox" id="chkSelectAll" value="1" onClick="selectAllChk()"></div><div class="column">First Name</div><div class="column">Mobile</div><div class="column" style="width:200px;">Email ID</div><div class="column">Resume</div><div class="column">Posted on</div><div class="column">Operation</div></div>';
$repeat = '';
$j = 1;
while ($row = mysql_fetch_assoc($result)) {
if ($row['jobstatus'] == '1') {
$js = 'Active';
} else {
$js = 'Inactive';
}
$repeat .= '<div class="row"><div class="checkboxdiv"><input name="chkjobid[' . $j . ']" type="checkbox" value="' . $row['ApplicantID'] . '"></div><div class="column">' . $row['applicantfirstname'] . '</div><div class="column">' . $row['applicantmobile'] . '</div><div class="column" style="width:200px;">' . $row['applicantemail'] . '</div><div class="column"><a href="useruploads/' . togetpath($row["add_date"]) . $row['applicantcvattachment'] . '" target="_blank">View Resume</a></div><div class="column">' . toshowformatdatetime($row["add_date"]) . '</div><div class="column"><a href="index.php?p=applicantdetails&aptid=' . $row['ApplicantID'] . '&jobid=' . $_GET['jobid'] . '">View Details</a></div></div>';
$j++;
}
echo $header . $repeat . '</div>';
?>
<div class="clear"></div>示例11: togetstatusofferlabel
?>
</td>
</tr>
<tr>
<td height="30" align="left" class="blackbold">Current Offer Status</td>
<td align="left" class="head2"><?php
echo togetstatusofferlabel($admin->ac_id, $admin->id);
?>
</td>
</tr>
<?php
$queryfp = "SELECT * FROM `tbl_offeremi` WHERE `offerid` = " . $row["id"];
$resultfp = mysql_query_with_throw($queryfp);
$totalfp = mysql_num_rows($resultfp);
if ($totalfp > 0) {
?>
<tr>
<td align="left" class="blackbold" height="1" colspan="2"></td>
</tr>
<tr>
<td align="left" class="blackbold" style="padding:10px 0;" colspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" class="blackbold" colspan="2"><h5>Current Offer EMI With Amount and Date</h5></td>
</tr>
<tr>
<td style="padding:10px 0;" width="25%"><strong>Amount</strong></td>
<td style="padding:10px 0;"><strong>Date</strong></td>示例12: mysql_query_with_throw
$fetch_user = "select t1.id as user_id, t1.firstname as name,t1.mobile as mobile, t1.email as email from tbl_userdetails t1 where \ndate(add_date)=DATE_SUB(curdate(), interval 1 day) \nand t1.validate=0 and mvalidate=0\nunion\nselect t2.user_id as user_id, t3.mobile as mobile, t3.firstname as name,t3.email as email from tbl_jobstatus t2 \nleft join tbl_userdetails t3 on\nt3.id=t2.user_id where t2.otp_status=1;";
$result = mysql_query_with_throw($fetch_user);
$update_array = array();
while ($row = mysql_fetch_array($result)) {
$user_id = $row['user_id'];
$user_mobile = $row['mobile'];
$user_email = $row['email'];
$user_name = $row['name'];
// send sms and email to user and others
$usermessage = 'Dear ' . $user_name . ', Please log into www.clearmydues.com with OTP to get your free credit report.';
$file_list = array(array("path" => $filePath1, "file_name" => $id_name));
$to = array($user_email);
$cc = array("");
$bcc = array("");
$subject = "Registration Validation Pending - Clearmydues";
$body = '<p>
Dear ' . $user_name . ',<br><br> Thanks for registering with clearmydues. Please login with OTP to get your free credit report.
</p>';
send_mail_through_queue($to, $cc, $bcc, $subject, $body, $file_list);
$sendsmstouser = sendsms($user_mobile, $usermessage);
// update status in job table
$update_user = "select otp_status from tbl_jobstatus where user_id='{$user_id}'\n order by id desc limit 1";
$update_user_check = mysql_query_with_throw($update_user);
$update_user_check_set = mysql_fetch_assoc($update_user_check);
if (!$update_user_check_set['otp_status']) {
// insert userid and status to 1
creteLogs(__FILE__, __LINE__, "send email to user " . $user_id . "about otp 1 time");
$insert_data = "insert into tbl_jobstatus (`user_id`, `otp_status`) \n values ({$user_id}, 1);";
$insert_data_status = mysql_query_with_throw($insert_data);
}
}示例13: md5
if (strlen($_POST['password']) < 6) {
$errors[] = 'Minimum password length is 6 characters!';
}
}
if (empty($_POST["cpassword"])) {
$errors[] = 'Confirm Password field can\'t be blank!';
}
if ($_POST["cpassword"] != $_POST["password"]) {
$errors[] = 'Passwords do not match!';
}
/*if (empty($_POST["captcha_code"]) ) {$errors[]='Security Code field can\'t be blank!';}*/
/*if (empty($_POST["recaptcha_response_field"])) {$errors[]='Security Code';}*/
if (empty($errors)) {
if (trim($_POST["password"]) != "") {
$pass = md5($_POST["password"]);
$qpu = mysql_query_with_throw("UPDATE `tbl_userdetails` SET `password` = '{$pass}' , `otpstatus` = '1' WHERE `id`=" . $_SESSION["GTUserID"]);
$_SESSION["otpstatus"] = "1";
echo "<script>document.location.href='index.php?p=myaccount'</script>";
} else {
$message_pass = '<div id="gt-formfeedback">Please fill in the following information.</div>';
}
}
} else {
//report the errors
if (!empty($errors)) {
//report the errors
echo '<div id="gt-formfeedback"><b><font size="4">WHOOPS! Please review the following issues:</font></b><ul>';
foreach ($errors as $msg) {
//prints each error
echo "<li>{$msg}</li>";
}示例14: array
if (isset($_POST['button'])) {
$email_verify = $_POST['email_verify'];
$score_id = $_POST['score_id'];
$errors = array();
//Initialize error array
if (empty($email_verify)) {
$errors[] = "Verification code can not be blank!";
}
if (empty($errors)) {
if ($email_verify) {
$msg_register = '<div id="gt-formfeedback">Email Verified.......</div>';
$user_details = mysql_query_with_throw('SELECT email_verify FROM `tbl_getscore` WHERE id = "' . $score_id . '"');
$user_code = mysql_fetch_assoc($user_details);
$code = $user_code['email_verify'];
if ($code == $email_verify) {
$user_details = mysql_query_with_throw("update `tbl_getscore` set email_verify='Verified' where id='{$score_id}'");
$msg_register = '<div id="gt-formfeedback">Email Verified....... Move to next step.</div>';
header("location:index.php?p=experian-flow&verified=1&score_id={$score_id}");
} else {
$msg_register = '<div id="gt-formfeedback">Please Input correct code received on your email id.</div>';
}
}
} else {
//report the errors
if (!empty($errors)) {
//report the errors
echo '<div id="gt-formfeedback"><b><font size="4">WHOOPS! Please review the following issues:</font></b><ul>';
foreach ($errors as $msg) {
//prints each error
echo "<li>{$msg}</li>";
}示例15: elseif
<br />
If you are having trouble logging in, please call us immediately on ' . $adminphone . '.</div>';
} elseif ($rowl["status"] == 0) {
$msg_login = '<div id="gt-forminfo">Sorry! Your Account has been temporarily suspended. Please call us immediately on ' . $adminphone . '.</div>';
} else {
$_SESSION['GTUserID'] = $rowl["id"];
$_SESSION['GTUserName'] = $rowl["name"];
$_SESSION['GTFullUserName'] = $rowl["firstname"] . ' ' . $rowl["middlename"] . ' ' . $rowl["lastname"];
$_SESSION['GTUserEmail'] = $rowl["email"];
$_SESSION['GTUserMobile'] = $rowl["mobile"];
//$taccount = togettotalaccount($_SESSION['GTUserID']);
checkMobileOrDesktop($_SESSION['GTUserID']);
#if($taccount>0){ $link = $baseurl.'index.php?p=view-account2&aid='.$taccount; } else { $link = $baseurl.'index.php?p=add-account&edit=true&add=new'; }
/*$qvalup = "UPDATE `uk_full_access_account_members` SET `add_date` = NOW() WHERE `RecruiterID` =".$rowl["RecruiterID"];
$result_valup = mysql_query_with_throw($qvalup); */
$checkreportquery = mysql_query_with_throw("SELECT `user_id` FROM `tbl_experian_data` WHERE `user_id`=" . $_SESSION['GTUserID']);
$rowl = mysql_fetch_assoc($checkreportquery);
if ($rowl["user_id"]) {
$link = $baseurl . 'index.php?p=my-score&type=bad';
} else {
$link = $baseurl . 'CMD.php';
}
$togetprofile = togetprofileitems($_SESSION['GTUserID'], 'mobile');
if ($togetprofile == "") {
echo "<script>document.location.href='index.php?p=edit-profile'</script>";
} else {
echo "<script>document.location.href='" . $link . "'</script>";
}
}
} else {
$msg_login = '<div id="gt-formfeedback">Sorry! The given Username/Password combination does not match.<br />