php - Check mysqli Insert Query excuted ok and display message and send email -


i creating registration form project, nothing secure or advanced, still new php etc.

i insert data needed login table , customer tbl, data inserts fine. cant code check worked , fire off email , display message user.

i have tried using value retrieved database there user registered successfuly.

if($userid != null)             {                 $msg1 = "thank you! registered, please check email verification link verify new account! ";                 $col1 = "green";                 //require_once "mail.php";                 require_once "inc/email.php";              }

i have tried 

if($query)             {                 $msg1 = "thank you! registered, please check email verification link verify new account! ";                 $col1 = "green";                 //require_once "mail.php";                 require_once "inc/email.php";          }

thanks,

edit - here code, 

    <?php      include ("inc/mysql.php");       error_reporting(0);     $msg = "";     $col = 'green';      function test_input($data){             $data = trim($data);             $data = stripslashes($data);             $data = htmlspecialchars($data);         return $data;     }      // define variables , set empty values     $name = $email = $chkemail = $password = $chkpassword =$address = $towncity = $postcode = "";  //required field validation  if ($_server["request_method"] == "post") {            if (empty($_post["name"])) {                 $msg = "name required";                 $col = 'red';           } else {                 $name = test_input($_post["name"]);           }            if (empty($_post["email"])) {                 $msg = "email required";                 $col = 'red';           } else {                 $email = test_input($_post["email"]);           }            if (empty($_post["chkemail"])) {                 $msg = "please confirm email address";                 $col = 'red';           } else {                 $chkemail = test_input($_post["chkemail"]);           }            if (empty($_post["password"])){                 $msg = "please enter password";                 $col = 'red';           }             if (empty($_post["chkpassword"])){                 $msg = "please confirm password ";                 $col = 'red';           } else{                 $chkpassword = test_input($_post["chkpassword"]);                 if(($_post["password"]) != $chkpassword) {                     $msg = "please check password correct";                     $col = 'red';                 } else{                     $password = test_input($_post["password"]);                 }           }            if (empty($_post["address"])) {                 $msg = "please enter first line of address";                 $col = 'red';           } else {             $address = test_input($_post["address"]);           }            if (empty($_post["towncity"])) {                 $msg = "please enter first line of town or city";                 $col = 'red';           } else {             $towncity= test_input($_post["towncity"]);           }            if (empty($_post["postcode"])) {                 $msg = "please enter postcode";                 $col = 'red';           } else {             $postcode = test_input($_post["postcode"]);             $customerveri = "n";              if($customerveri == "n"){             $name = mysqli_real_escape_string($db, $name);             $email = mysqli_real_escape_string($db, $email);             $password = mysqli_real_escape_string($db, $password);             $password = md5($password.substr($email,0,3));             $chkpassword = md5($password.substr($email,0,3));             $verifylink = md5(substr($name,0,3).substr($email,0,3));                $sql="select customeremail customer_tbl customeremail='$email'";             $result=mysqli_query($db,$sql);             $row=mysqli_fetch_array($result,mysqli_assoc);             if(mysqli_num_rows($result) == 1)             {                    $msg1 = "sorry...this email exists, please enter or login...";                 $col1 = "red";             }             else             {             $query = mysqli_query($db, "insert login_tbl (customeremail, customerpassword)values ('$email', '$password')");              $sql="select userid login_tbl customeremail='$email'";             $result=mysqli_query($db,$sql);             $row=mysqli_fetch_array($result,mysqli_assoc);             $userid = $row['userid'];              $query2 = mysqli_query($db, "insert customer_tbl (customername, userid, customeremail, customerpassword, customeraddress, customertowncity, customerpostcode, customerverified, customerverifiedlink)values ('$name', '$userid', '$email', '$password','$address','$towncity','$postcode','$customerveri','$verifylink')");             echo("error description: " . mysqli_error($db));         }            }           } }      if($userid != null)             {                 $msg1 = "thank you! registered, please check email verification link verify new account! ";                 $col1 = "green";                 //require_once "mail.php";                 require_once "inc/email.php";              }  echo '<div style="color:'.$col.'">'; echo $msg; echo '</div>';  echo '<div style="color:'.$col1.'">'; echo $msg1; echo '</div>';  ?>

seems there no issue, instead issue email.php stopped rest of statement being executed. pick bits. few hours away screen needs!

thanks answered..


-

Comments

Post a Comment

Popular posts from this blog

many to many - Django Rest Framework ManyToMany filter multiple values -

i have 2 models, 1 defining users, other defining labels on these users. using django rest framework create api. able query users @ least labels ids 1 , 2. for instance users' labels are: [(1,2), (1,2,3), (2,3), (1,3)] want query return [(1,2), (1,2,3)] . so far, i've managed query users given label (let's id=1) doing: /api/users/?labels=1 , unable query users labels 1 , 2. i've tried /api/users/?labels=1,2 or /api/users/?labels=1&labels=2 return invalid users, i.e. users without labels 1 or 2... any welcome. thanks, dimitry github test repo: https://github.com/thedimlebowski/drf-m2m-filter code: models.py class label(models.model): name = models.charfield(max_length = 60) class user(models.model): labels = models.manytomanyfield(label) filters.py class userfilter(django_filters.filterset): labels = django_filters.filters.baseinfilter( name='labels', lookup_type='in', ) class meta:...
Read more

java - Jasper subreport showing only one entry from the JSON data source when embedded in the Title band -

Image
i having issues populating data in subreport in title band of main report. data populated correctly in subreport in detail band of main report. trying find wrong in json query. appreciated. json sample data source (expenses.json) { "expenses": { "date": "8 sep 2016", "accounts": [ { "title": "xyz corp (111)", "accountname": "xyz corp", "accountnumber": "111", "transactions": [ { "date": "21 jun 2016", "name": "gas", "price": "17.50" }, { "date": "12 may 2016", "name": "shopping", "price": "111.99" }, { "date": "30 apr 2016", "name...
Read more

Java Entity Manager - JSON reader was expecting a value but found 'db' -

i have code working: entitymanager entitymanager = getentitymanager(); entitymanager.gettransaction().begin(); string query = "db.band.find({})"; list<band> list = (list<band>) entitymanager.createnativequery(query, band.class).getresultlist(); entitymanager.close(); return list; it returns list no problem. want sort list date : entitymanager entitymanager = getentitymanager(); entitymanager.gettransaction().begin(); string query = "db.band.find({something__id:objectid(\"" + myid + "\")}).sort({\"somethingelse.date\":-1})"; list<band> list = (list<band>) entitymanager.createnativequery(query, band.class).getresultlist(); entitymanager.close(); return list; my console gives me message: org.bson.json.jsonparseexception: json reader expecting value found 'db' i checked string working in mongo console , did. ideas? edit: tried putting "something__id" between quotes because would...
Read more