<?php ini_set('display_errors', 'On'); include 'storedinfo.php'; $server = "oniddb.cws.oregonstate.edu"; $username = "mcaliste-db"; $database = "mcaliste-db"; $mysqli = new mysqli($server, $username, $password, $database); if (!$mysqli || $mysqli->connect_errno) { echo "Connection error " .$mysqli->connect_errno ." ".$mysqli->connect_error; } else { echo "Connection successful<br>"; } // table name and attributes: // CREATE TABLE userinfo (id INT NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, // gender VARCHAR(6) NOT NULL, age INT NOT NULL, PRIMARY KEY (id) ); if(!empty($_POST)){ $name = htmlspecialchars($_POST['name']); $gender = htmlspecialchars($_POST['sex']); $age = htmlspecialchars($_POST['age']); } //$name = 'Bob'; //$gender = 'male'; //$age = 45; if (!($stmt = $mysqli->prepare("INSERT INTO userinfo(name, gender, age) VALUES (?, ?, ?)"))) { echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error; } $stmt->bind_param("ssi", $name, $gender, $age); $stmt->execute(); $stmt->close(); // remember to $stmt->close(); //$stmt->bind_result($resultName, $resultGender, $resultAge) //Select queries return a result set //if ($result = $mysqli->query("SELECT age FROM userinfo LIMIT 10")) { //printf("Select returned %d rows.\n", $result->num_rows); //free result set //$result->close(); //} ?>
You have javascript disabled. You will not be able to edit any code.