3v4l.org

run code in 300+ PHP versions simultaneously

@ 2015-11-27T22:56:40Z

<?php
//Connect to Database
    $con=mysqli_connect("localhost", "root", "password", "user");
	
	mysqli_query($con, "SET CHARACTER SET utf8");
	
	if(isset($_POST['name'])) {
		$name = $_POST['name'];
	} else {		}
	
	if(isset($_POST['age'])) {
		$age = $_POST['age'];
	} else {		}
	
	

    //Grabs values from Database
    $stmt = mysqli_prepare($con, "SELECT * FROM user WHERE username = ? AND password = ?");

    //Protects against SQL injection attacks
    mysqli_stmt_bind_param($stmt, "ss", $username, $password);

    //Execute
    mysqli_stmt_execute($stmt); 
	

    //Bind results 
    mysqli_stmt_bind_result($stmt, $userID, $name, $age, $username, $password);
    
    //Holds data of user returned
    $user = array();

    //Stores returned data in the array
    while(mysqli_stmt_fetch($stmt)){
        $user[name] = $name;
        $user[age] = $age;
        $user[username] = $username;
        $user[password] = $password;
    }
	


    //Turns array into a json
    echo json_encode($user);

	
	
    //Close Statment
    mysqli_stmt_close($stmt);

    //Close Connection
    mysqli_close($con);
?>

Output for 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.0 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.27, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6: Fatal error: Uncaught Error: Call to undefined function mysqli_connect() in /in/MEfjd:3 Stack trace: #0 {main} thrown in /in/MEfjd on line 3
Process exited with code 255.
Output for 8.3.5: Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 Fatal error: Uncaught Error: Call to undefined function mysqli_connect() in /in/MEfjd:3 Stack trace: #0 {main} thrown in /in/MEfjd on line 3
Process exited with code 255.
Output for 5.5.0 - 5.5.37, 5.6.0 - 5.6.28: Fatal error: Call to undefined function mysqli_connect() in /in/MEfjd on line 3
Process exited with code 255.

preferences:dark modelive preview

175.27 ms | 401 KiB | 220 Q