3v4l.org

run code in 300+ PHP versions simultaneously
<?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