Online PHP editor | rfc for X4PEr

@ 2014-05-13T14:08:19Z

<?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();
	//}	
        
        
        
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		

?>

Output for git.master, git.master_jit, rfc.property-hooks: Warning: include(): open_basedir restriction in effect. File(storedinfo.php) is not within the allowed path(s): (/tmp:/in:/etc) in /in/X4PEr on line 4 Warning: include(storedinfo.php): Failed to open stream: Operation not permitted in /in/X4PEr on line 4 Warning: include(): Failed opening 'storedinfo.php' for inclusion (include_path='.:') in /in/X4PEr on line 4 Fatal error: Uncaught Error: Class "mysqli" not found in /in/X4PEr:10 Stack trace: #0 {main} thrown in /in/X4PEr on line 10
Process exited with code 255.

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

2020-03-21 RFC: Is_Literal - declined
2020-12-04 Enumerations - included in PHP 8.1
2018-06-15 Typed Properties v2 - implemented in PHP 7.4
2016-08-12 Object typehint - included in PHP 7.2
2016-08-14 Arrow functions - withdrawn
2016-05-29 array_change_keys() - withdrawn
2016-04-19 Lexical scope support for anonymous classes - suspended
2016-04-17 Functional Interfaces - declined
2016-03-16 Typed Properties - superseded in favor of Typed Properties 2.0
2015-08-27 Callable Prototypes - declined
2015-05-01 Short Closures - declined / withdrawn in favor of Arrow Functions
2015-02-18 Scalar type hints v5 - included in PHP 7
2015-02-14 Union Types - declined
2013-09-22 Anonymous classes - included in PHP 7

preferences:dark modelive preview