Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include_once("../php_includes/db_conx.php");
- include_once("../php_includes/phpmailer/PHPMailerAutoload.php");
- $email = mysqli_real_escape_string($db_conx,filter_var($_POST['emailreset'], FILTER_SANITIZE_EMAIL));
- $tanggal_lahir = mysqli_real_escape_string($db_conx,$_POST['tanggal_lahir']);
- echo '<script type="text/javascript">console.log("'.$email.'");</script>';
- echo '<script type="text/javascript">console.log("'.$tanggal_lahir.'");</script>';
- $query = "SELECT * FROM members WHERE email='$email' AND tanggal_lahir='$tanggal_lahir'";
- $konek = mysqli_query($db_conx, $query);
- $result = mysqli_num_rows($konek);
- $berhasil = 'tidak';
- $berhasilupdate = 'tidak';
- if ($result > 0) {
- function randompass($length = 8) {
- $characters = '123456789abcdefghjk';
- $charactersLength = strlen($characters);
- $randomString = '';
- for ($i = 0; $i < $length; $i++) {
- $randomString .= $characters[rand(0, $charactersLength - 1)];
- }
- return $randomString;
- }
- $key = randompass();
- $random = md5($key);
- $queryz = "UPDATE members SET password='$random' WHERE email='$email' AND tanggal_lahir='$tanggal_lahir'";
- $konekx = mysqli_query($db_conx, $queryz);
- if($konekx) {
- $mail = new PHPMailer;
- $mail->isSMTP();
- $mail->SMTPDebug = 0;
- $mail->Debugoutput = 'html';
- $mail->Host = "mail.bisnisabah.com";
- $mail->Port = 25;
- $mail->SMTPAuth = true;
- $mail->Username = "[email protected]";
- $mail->Password = "okelahoke123";
- $mail->setFrom('[email protected]', 'Bisnis Abah');
- $mail->addAddress($email, $email);
- $mail->Subject = 'Informasi Akun Bisnis Abah';
- $mail->Body='<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
- <meta name="viewport" content="width=device-width, initial-scale=1" />
- <title></title>
- <style type="text/css">img{max-width:600px;outline:0;text-decoration:none;-ms-interpolation-mode:bicubic}a img{border:0}table{border-collapse:collapse!important}#outlook a{padding:0}.ReadMsgBody{width:100%}.ExternalClass{width:100%}.backgroundTable{margin:0 auto;padding:0;width:100%!important}table td{border-collapse:collapse}.ExternalClass *{line-height:115%}.container-for-gmail-android{min-width:600px}*{font-family:Helvetica,Arial,sans-serif}body{-webkit-font-smoothing:antialiased;-webkit-text-size-adjust:none;width:100%!important;margin:0!important;height:100%;color:#676767}td{font-family:Helvetica,Arial,sans-serif;font-size:14px;color:#777;text-align:center;line-height:21px}a{color:#676767;text-decoration:none!important}.pull-left{text-align:left}.pull-right{text-align:right}.header-lg,.header-md,.header-sm{font-size:32px;font-weight:700;line-height:normal;padding:35px 0 0;color:#4d4d4d}.header-md{font-size:24px}.header-sm{padding:5px 0;font-size:18px;line-height:1.3}.content-padding{padding:20px 0 30px}.mobile-header-padding-right{width:290px;text-align:right;padding-left:10px}.mobile-header-padding-left{width:290px;text-align:left;padding-left:10px}.free-text{width:100%!important;padding:10px 60px 0}.block-rounded{border-radius:5px;border:1px solid #e5e5e5;vertical-align:top}.button{padding:55px 0 0}.info-block{padding:0 20px;width:260px}.mini-block-container{padding:30px 50px;width:500px}.mini-block{background-color:#fff;width:498px;border:1px solid #ccc;border-radius:5px;padding:30px 45px}.block-rounded{width:260px}.info-img{width:258px;border-radius:5px 5px 0 0}.force-width-img{width:480px;height:1px!important}.force-width-full{width:600px;height:1px!important}.user-img img{width:82px;border-radius:5px;border:1px solid #ccc}.user-img{width:92px;text-align:left}.user-msg{width:236px;font-size:14px;text-align:left;font-style:italic}.code-block{padding:10px 0;border:1px solid #ccc;color:#4d4d4d;font-weight:bold;font-size:18px;text-align:center}.force-width-gmail{min-width:600px;height:0!important;line-height:1px!important;font-size:1px!important}.button-width{width:228px}</style>
- <style type="text/css" media="screen">@import url(http://fonts.googleapis.com/css?family=Oxygen:400,700);</style>
- <style type="text/css" media="screen">@media screen{*{font-family:Oxygen,Helvetica Neue,Arial,sans-serif!important}}</style>
- <style type="text/css" media="only screen and (max-width: 480px)">@media only screen and (max-width:480px){table[class*="container-for-gmail-android"]{min-width:290px!important;width:100%!important}table[class="w320"]{width:320px!important}img[class="force-width-gmail"]{display:none!important;width:0!important;height:0!important}a[class="button-width"],a[class="button-mobile"]{width:248px!important}td[class*="mobile-header-padding-left"]{width:160px!important;padding-left:0!important}td[class*="mobile-header-padding-right"]{width:160px!important;padding-right:0!important}td[class="header-lg"]{font-size:24px!important;padding-bottom:5px!important}td[class="header-md"]{font-size:18px!important;padding-bottom:5px!important}td[class="content-padding"]{padding:5px 0 30px!important}td[class="button"]{padding:15px 0 5px!important}td[class*="free-text"]{padding:10px 18px 30px!important}img[class="force-width-img"],img[class="force-width-full"]{display:none!important}td[class="info-block"]{display:block!important;width:280px!important;padding-bottom:40px!important}td[class="info-img"],img[class="info-img"]{width:278px!important}td[class="mini-block-container"]{padding:8px 20px!important;width:280px!important}td[class="mini-block"]{padding:20px!important}td[class="user-img"]{display:block!important;text-align:center!important;width:100%!important;padding-bottom:10px}td[class="user-msg"]{display:block!important;padding-bottom:20px!important}}</style>
- </head>
- <body bgcolor="#eceff4">
- <table align="center" cellpadding="0" cellspacing="0" class="container-for-gmail-android" width="100%">
- <tr>
- <td align="left" valign="top" width="100%" style="background:repeat-x url(http://s3.amazonaws.com/swu-filepicker/4E687TRe69Ld95IDWyEg_bg_top_02.jpg) #fff">
- <center>
- <img src="http://s3.amazonaws.com/swu-filepicker/SBb2fQPrQ5ezxmqUTgCr_transparent.png" class="force-width-gmail">
- <table cellspacing="0" cellpadding="0" width="100%" bgcolor="#ffffff" background="http://s3.amazonaws.com/swu-filepicker/4E687TRe69Ld95IDWyEg_bg_top_02.jpg" style="background-color:transparent">
- <tr>
- <td width="100%" height="80" valign="top" style="text-align:center;vertical-align:middle">
- <!--[if gte mso 9]>
- <v:rect xmlns:v="urn:schemas-microsoft-com:vml" fill="true" stroke="false" style="mso-width-percent:1000;height:80px;v-text-anchor:middle">
- <v:fill type="tile" src="http://s3.amazonaws.com/swu-filepicker/4E687TRe69Ld95IDWyEg_bg_top_02.jpg" color="#ffffff" />
- <v:textbox inset="0,0,0,0">
- <![endif]-->
- <center>
- <table cellpadding="0" cellspacing="0" width="600" class="w320">
- <tr>
- <td class="pull-left mobile-header-padding-left" style="vertical-align:middle">
- <a href=""><img width="137" height="50" src="http://member.bisnisabah.com/assets/img/logo-2.png" alt="logo"></a>
- </td>
- <td class="pull-right mobile-header-padding-right" style="color:#4d4d4d">
- <a href=""><img width="44" height="47" src="http://s3.amazonaws.com/swu-filepicker/k8D8A7SLRuetZspHxsJk_social_08.gif" alt="twitter" /></a>
- <a href=""><img width="38" height="47" src="http://s3.amazonaws.com/swu-filepicker/LMPMj7JSRoCWypAvzaN3_social_09.gif" alt="facebook" /></a>
- </td>
- </tr>
- </table>
- </center>
- <!--[if gte mso 9]>
- </v:textbox>
- </v:rect>
- <![endif]-->
- </td>
- </tr>
- </table>
- </center>
- </td>
- </tr>
- <tr>
- <td align="center" valign="top" width="100%" style="background-color:#eceff4" class="content-padding">
- <center>
- <table cellspacing="0" cellpadding="0" width="600" class="w320">
- <tr>
- <td class="header-lg">
- Member Bisnis Abah
- </td>
- </tr>
- <tr>
- <td class="free-text">
- Password anda telah berhasil di reset! Dibawah ini adalah informasi email dan password baru anda, harap disimpan dengan baik dan lakukan pergantian password.
- </td>
- </tr>
- <tr>
- <td class="mini-block-container">
- <table cellspacing="0" cellpadding="0" width="100%" style="border-collapse:separate!important">
- <tr>
- <td class="mini-block">
- <table cellpadding="0" cellspacing="0" width="100%">
- <tr>
- <td style="padding-bottom:8px">
- Email
- </td>
- </tr>
- <tr>
- <td class="code-block">
- '.$email.'
- </td>
- </tr>
- <tr>
- <td style="padding-top:25px;padding-bottom:8px">
- Password
- </td>
- </tr>
- <tr>
- <td class="code-block">
- '.$key.'
- </td>
- </tr>
- <tr>
- <td class="button">
- <div><!--[if mso]>
- <v:roundrect xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" href="http://member.bisnisabah.com/login" style="height:45px;v-text-anchor:middle;width:155px" arcsize="15%" strokecolor="#ffffff" fillcolor="#00a8ff">
- <w:anchorlock/>
- <center style="color:#fff;font-family:Helvetica,Arial,sans-serif;font-size:14px;font-weight:regular">Login Sekarang</center>
- </v:roundrect>
- <![endif]--><a class="button-mobile" href="http://member.bisnisabah.com/login" style="background-color:#00a8ff;border-radius:5px;color:#fff;display:inline-block;font-family:Cabin,Helvetica,Arial,sans-serif;font-size:14px;font-weight:regular;line-height:45px;text-align:center;text-decoration:none;width:155px;-webkit-text-size-adjust:none;mso-hide:all">Login Sekarang</a></div>
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </center>
- </td>
- </tr>
- <tr>
- <td align="center" valign="top" width="100%" style="background-color:#eceff4;height:100px">
- <center>
- <table cellspacing="0" cellpadding="0" width="600" class="w320">
- <tr>
- <td style="padding:25px 0 25px">
- <strong>Bisnis Abah</strong><br />
- PT. AMANAN INSAN MULYA<br />
- Jalan Kayu Manis No. 11 A Pekanbaru<br />
- Telp. (0761) 839315 (Hunting)<br />
- Fax. (0761) 23579<br /><br />
- </td>
- </tr>
- </table>
- </center>
- </td>
- </tr>
- </table>
- </body>
- </html>';
- $berhasilupdate = "ya";
- $mail->AltBody = 'cangkirware';
- //send the message, check for errors
- if (!$mail->send()) {
- $berhasil = "tidak";
- } else {
- $berhasil = "ya";
- }
- }
- }
- if($berhasil && $berhasilupdate == "ya"){
- header('Location: http://member.bisnisabah.com/lupa-password?pesan=reset_success');
- } else if ($berhasil && $berhasilupdate == "tidak"){
- header('Location: http://member.bisnisabah.com/lupa-password?pesan=reset_failed');
- } else {
- header('Location: http://member.bisnisabah.com/lupa-password?pesan=error');
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement