<?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($_REQUEST)){
//unset($err);
$name = htmlspecialchars($_REQUEST['name']);
$gender = htmlspecialchars($_REQUEST['sex']);
$age = htmlspecialchars($_REQUEST['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 name, gender, age FROM userinfo LIMIT 10")) {
printf("Select returned %d rows.\n", $result->num_rows);
}
/*
$data = '';
$data .= '<table border="1">';
while($row = mysql_fetch_assoc($facebook))
{
$data .= '<tr>';
foreach($row as $value)
{
$data .= '<td>$value</td>';
}
$data .= '</tr>';
}
$data .= '</table>';
//free result set
$result->close();
}*/
} else
{
echo "You did not complete all of the required fields!";
}
//$err = array();
//performing all validations and raising corresponding errors
//if (empty($_REQUEST['name'])) $err[] = "Name field is required";
//if (empty($_REQUEST['sex'])) $err[] = "Gender field is required";
// if (empty($_REQUEST['age'])) $err[] = "Age field is required");
?>
preferences:
35.06 ms | 402 KiB | 5 Q