[MySQL][PHP]Bind Param Opcje

[Waloch016]

Czy ktos moze zerknac co tu jest nie tak w kodzie?? Zaznaczam ze wszystkie kolumny w bazie istnieja. i laczyc tez sie laczy bo bledy nie wywala.

[PHP] pobierz, plaintext 
 <?php
//include database connection
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "system";
 
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
 
// if the form was submitted/posted, update the record
if($_POST){
 
    //write query
    $stmt = $conn->prepare("UPDATE
                booking 
            VALUES
                car = ?,
                date = ?,
                time = ?,
                number  = ?,
				name  = ?,
				type  = ?,
				price  = ?
            WHERE
                id = ?");
 
 
    // you can bind params this way,
    // if you want to see the other way, see our add.php
    $stmt->bind_param(
        'sssissii',
        $_POST['$car'],
        $_POST['$date'],
        $_POST['$time'],
        $_POST['$number'],
		$_POST['$name'],
		$_POST['$type'],
		$_POST['$price'],
        $_GET['$id']
    );
 
    // execute the update statement
    if($stmt->execute()){
        echo "User was updated.";
 
        // close the prepared statement
        $stmt->close();
    }else{
        die("Unable to update.");
    }
}
 
/*
 * select the record to be edited,
 * you can also use prepared statement here,
 * but my hosting provider seems it does not support the mysqli get_result() function
 * you can use it like this one http://php.net/manual/fr/mysqli.prepare.php#107568
 
 * so it I'm going to use $mysqli->real_escape_string() this time.
 */
 
$sql = "SELECT
            id, car, date, time, number, name, type, price
        FROM
            booking
        WHERE
            id = \"" . $conn->real_escape_string($_GET['id']) . "\"
        LIMIT
            0,1";
 
 
// execute the sql query
$result = $conn->query($sql);
 
//get the result
$row = $result->fetch_assoc();
 
// php's extract() makes $row['firstname'] to $firstname automatically
extract($row);
 
//disconnect from database
$result->free();
$conn->close();
?>
 
<!--we have our html form here where new user information will be entered-->
<form action='edit.php?id=<?php echo $id; ?>' method='post' border='0'>
<fieldset>
<dl>
	<dt><label for="car" >Car Make:</label></dt>
	<dd><input name="car" type="text" value="<?php echo $car; ?>"></dd>
	<dt><label for="date">Date:</label></dt>
	<dd><input name="date"  type="text" id="datepicker" value="<?php echo $date; ?>"></dd>
	<dt><label for="time">Arrive Time:</label></dt>
	<dd><input name="time"  type="text" placeholder="13:00" value="<?php echo $time; ?>"></dd>
	<dt><label for="number">Tel. No.:</label></dt>
	<dd><input name="number" type="text" value="<?php echo $number; ?>"></dd>
	<dt><label for="name">Name:</label></dt>
	<dd><input name="name" type="text" value="<?php echo $name; ?>"></dd>
	<dt><label for="type" style="width:450px;">Type:</label></dt>
	<dd><select name="type" value="<?php echo $type; ?>">
 <option value="0">Select</option>
  <option value="Wash + Vac">Wash + Vac</option>
  <option value="Mini Valet">Mini Valet</option>
  <option value="Full Valet">Full Valet</option>
  <option value="Detar">Detar</option>
  <option value="Other">Other</option>
 </select></dd>
	<dt><label for="price">Price:</label></dt>
	<dd><select name="price" value="<?php echo $price; ?>">
 <option value="0">Select</option>
  <option value="10">? 10</option>
  <option value="15">? 15</option>
  <option value="20">? 20</option>
  <option value="25">? 25</option>
  <option value="30">? 30</option>
  <option value="35">? 35</option>
  <option value="40">? 40</option>
  <option value="45">? 45</option>
  <option value="50">? 50</option>
   <option value="55">? 55</option>
  <option value="60">? 60</option>
  <option value="65">? 65</option>
  <option value="70">? 70</option>
  <option value="75">? 75</option>
  <option value="80">? 80</option>
  <option value="85">? 85</option>
  <option value="90">? 90</option>
   <option value="95">? 95</option>
  <option value="100">? 100</option>
  <option value="105">? 105</option>
  <option value="110">? 110</option>
  <option value="115">? 115</option>
  <option value="120">? 120</option>
  <option value="125">? 125</option>
  <option value="130">? 130</option>
 </select></dd>
	<dt><input type="submit" name="submit" value="Add"></dt></dl>
</fieldset>
</form>
 
</body>
</html>
[PHP] pobierz, plaintext 

Szukalem w google, siedze 3 dzien i nie moge nic wyyslic. id, number, price to jest INT w bazie

Zapomnialem, przepraszam: Fatal error: Call to a member function bind_param() on a non-object in C:\wamp\www\edit.php on line 35

Wiem co znaczy blad, nie wiem jak naprawic. tak w razie w to pisze

Ten post edytował Waloch016 19.11.2014, 11:42:13

[Waloch016]

[PHP] pobierz, plaintext 
 <?php
 
     error_reporting(E_ALL);
    ini_set('display_errors','1');
//include database connection
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "system";
 
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
 
// if the form was submitted/posted, update the record
if($_POST){
 
    //write query
	//$stmt == TRUE
    $stmt = $conn->prepare("UPDATE
                `booking` 
            SET
                car = ?,
                date = ?,
                time = ?,
                number  = ?,
				name  = ?,
				type  = ?,
				price  = ?
            WHERE
                id = ?");
				//var_dump($stmt);
 
 
    // you can bind params this way,
    // if you want to see the other way, see our add.php
    $stmt -> bind_param(
        'sssissii',
        $_POST['$car'],
        $_POST['$date'],
        $_POST['$time'],
        $_POST['$number'],
		$_POST['$name'],
		$_POST['$type'],
		$_POST['$price'],
		$_POST['id']);
 
    // execute the update statement
    if($stmt->execute()){
        echo "User was updated.";
		header('Location: booking.php');
 
        // close the prepared statement
        $stmt->close();
    }else{
        die("Unable to update.");
    }
}
 
/*
 * select the record to be edited,
 * you can also use prepared statement here,
 * but my hosting provider seems it does not support the mysqli get_result() function
 * you can use it like this one <a href="http://php.net/manual/fr/mysqli.prepare.php#107568" target="_blank">http://php.net/manual/fr/mysqli.prepare.php#107568</a>
 
 * so it I'm going to use $mysqli->real_escape_string() this time.
 */
 
$sql = "SELECT
            id, car, date, time, number, name, type, price
        FROM
            `booking`
        WHERE
            id = \"" . $conn->real_escape_string($_GET['id']) . "\"
        LIMIT
            0,1";
 
 
// execute the sql query
$result = $conn->query($sql);
 
//get the result
$row = $result->fetch_assoc();
 
// php's extract() makes $row['firstname'] to $firstname automatically
extract($row);
 
//disconnect from database
$result->free();
$conn->close();
?>
 
<!--we have our html form here where new user information will be entered-->
<form action='edit.php?id=<?php echo $id; ?>' method='post' border='0'>
<fieldset>
<dl>
	<dt><label for="car" >Car Make:</label></dt>
	<dd><input name="car" type="text" value="<?php echo $car; ?>"></dd>
	<dt><label for="date">Date:</label></dt>
	<dd><input name="date"  type="text" id="datepicker" value="<?php echo $date; ?>"></dd>
	<dt><label for="time">Arrive Time:</label></dt>
	<dd><input name="time"  type="text" placeholder="13:00" value="<?php echo $time; ?>"></dd>
	<dt><label for="number">Tel. No.:</label></dt>
	<dd><input name="number" type="text" value="<?php echo $number; ?>"></dd>
	<dt><label for="name">Name:</label></dt>
	<dd><input name="name" type="text" value="<?php echo $name; ?>"></dd>
	<dt><label for="type" style="width:450px;">Type:</label></dt>
	<dd><select name="type" value="<?php echo $type; ?>">
 <option value="0">Select</option>
  <option value="Wash + Vac">Wash + Vac</option>
  <option value="Mini Valet">Mini Valet</option>
  <option value="Full Valet">Full Valet</option>
  <option value="Detar">Detar</option>
  <option value="Other">Other</option>
 </select></dd>
	<dt><label for="price">Price:</label></dt>
	<dd><select name="price" value="<?php echo $price; ?>">
 <option value="0">Select</option>
  <option value="10">&euro; 10</option>
  <option value="15">&euro; 15</option>
  <option value="20">&euro; 20</option>
  <option value="25">&euro; 25</option>
  <option value="30">&euro; 30</option>
  <option value="35">&euro; 35</option>
  <option value="40">&euro; 40</option>
  <option value="45">&euro; 45</option>
  <option value="50">&euro; 50</option>
   <option value="55">&euro; 55</option>
  <option value="60">&euro; 60</option>
  <option value="65">&euro; 65</option>
  <option value="70">&euro; 70</option>
  <option value="75">&euro; 75</option>
  <option value="80">&euro; 80</option>
  <option value="85">&euro; 85</option>
  <option value="90">&euro; 90</option>
   <option value="95">&euro; 95</option>
  <option value="100">&euro; 100</option>
  <option value="105">&euro; 105</option>
  <option value="110">&euro; 110</option>
  <option value="115">&euro; 115</option>
  <option value="120">&euro; 120</option>
  <option value="125">&euro; 125</option>
  <option value="130">&euro; 130</option>
 </select></dd>
	<dt><input type="submit" name="submit" value="Add"></dt></dl>
</fieldset>
</form>
 
</body>
</html>
[PHP] pobierz, plaintext 

Nie wywala mi bledow nic a nic