html - Getting php mysqli error -
i'm making customer management system, have succsessfully retrieved data db, when i'm trying add customer showing below error, i'm not getting i'm wrong, i'm new on programming. please & let me know i'm wrong.
here notice:
notice: undefined property: mysqli::$get_id in d:\xampp\htdocs\cmanager\add_customer.php on line 25
here php code insert records:
<?php require_once('includes\database.php'); ?> <?php if(isset($_post['submit'])){ $name=$email=$phone=$password=$image=""; $name= mysqli_real_escape_string($mysqli, $_post['name']); $email= mysqli_real_escape_string($mysqli, $_post['email']); $phone= mysqli_real_escape_string($mysqli, $_post['phone']); $password= md5(mysqli_real_escape_string($mysqli, $_post['password'])); $image= mysqli_real_escape_string($mysqli, $_post['image']); $address= mysqli_real_escape_string($mysqli, $_post['address']); $country= mysqli_real_escape_string($mysqli, $_post['country']); $city= mysqli_real_escape_string($mysqli, $_post['city']); $zipcode= mysqli_real_escape_string($mysqli, $_post['zip_code']); $query= "insert customer(id, name, email, phone, password, image) values ('','$name','$email','$phone','$password','$image')"; $mysqli->query('$query'); $query="insert customer_address(customer,address, country, city, zip_code) values ('$mysqli->get_id','$address','$country','$city','$zipcode')"; $mysqli->query('$query'); //header('location: index.php'); exit; } ?> here html:
<html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="x-ua-compatible" content="ie=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>cmanager | dashboard</title> <!-- bootstrap core css --> <link href="css/bootstrap.min.css" rel="stylesheet"> <!-- custom styles template --> <link href="css/jumbotron-narrow.css" rel="stylesheet"> </head> <body> <div class="container"> <div class="header"> <ul class="nav nav-pills pull-right"> <li class="active"><a href="index.php">home</a></li> <li><a href="add_customer.php">add customer</a></li> </ul> <h3 class="text-muted">store cmanager</h3> </div> <div class="row marketing"> <div class="col-lg-12"> <h2>customers</h2> <form action="add_customer.php" method="post"> <table> <tr> <td>name:</td> <td><input type="text" name="name" required="true"></td> </tr> <tr> <td>email:</td> <td><input type="email" name="email" required="true"></td> </tr> <tr> <td>phone:</td> <td><input type="phone" name="phone" required="true"></td> </tr> <tr> <td>password:</td> <td><input type="password" name="password" required="true"></td> </tr> <tr> <td>image:</td> <td><input type="text" name="image" required="true"></td> </tr> <tr><td><h2>other details:</h2><td></tr> <tr> <td>address:</td> <td><input type="text" name="address"></td> </tr> <tr> <td>country:</td> <td><input type="text" name="country"></td> </select> </tr> <tr> <td>city:</td> <td><input type="text" name="city"></td> </select> </tr> <tr> <td>zip code:</td> <td><input type="text" name="zip_code"></td> </tr> <tr><td><input type="submit" value="submit" name="submit"></td></tr> </table> </form> </div> </div> <div class="footer"> <p>© company 2014</p> </div> </div> </body> </html> database:
<?php $db_host="localhost"; $db_name="store"; $db_user="root"; $db_pass=''; $mysqli= new mysqli($db_host, $db_user,$db_pass,$db_name); if(mysqli_connect_errno()){ echo "connection failed.mysqli_connect_errno"; die(); } ?>
you call wrong property in query
$query="insert customer_address(customer,address, country, city, zip_code) values ('$mysqli->get_id','$address','$country','$city','$zipcode')"; you can try using $mysqli->insert_id
like this:
$query="insert customer_address(customer,address, country, city, zip_code) values ('{$mysqli->insert_id}','$address','$country','$city','$zipcode')"; update: sorry miss 1 big mistake:
you cant using vars this:
$mysqli->query('$query'); you must use:
$mysqli->query($query);
Comments
Post a Comment