Mijn formulier (bestellijst) werkt niet meer

Warning
This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
mysqli_connect()
PDO::__construct()

<?php
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select database");
?>

SELECT * FROM $tbl_name

<?php
$host="localhost";  
$username="root"; 
$password=""; 
$db_name="app"; 
$tbl_name="list"; 

#mysqli_connect("$host", "$username", "$password")or die("cannot connect"); 
#mysqli_select_db("$db_name")or die("cannot select database");

$mysqli = new mysqli("$host", "$username", "$password", "$db_name");
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
	
if ("POST" === $_SERVER['REQUEST_METHOD']) {	
	foreach( $_POST["id"] AS $id ) {
		$item = mysqli_real_escape_string($_POST["item"][$id]);
		$class = mysqli_real_escape_string($_POST["class"][$id]);
		$unity = mysqli_real_escape_string($_POST["unity"][$id]);
		$qty = mysqli_real_escape_string($_POST["qty"][$id]);
		$memo = mysqli_real_escape_string($_POST["memo"][$id]);
		$update = "UPDATE $tbl_name SET `item` = '$item', `class` = '$class', `qty` = '$qty', `unity` = '$unity', `memo` = '$memo' WHERE `id` = $id";
		mysqli_query($update) or die( mysqli_error());
		}
		}	
$sql = "SELECT * FROM $tbl_name order by    
			case  
				when class = 'Fruit' 						then 10
				when class = 'Aardappelen'  				then 20
				when class = 'Groenten'    					then 30
			else 9999
			end,
			case
				when qty = 0 							then 0
				when qty = null         				then 0
			else 1
			end DESC,
			item,
			id" ;

$res = mysqli_query( $sql ) or die( mysqli_error() );

if ( mysqli_num_rows( $res ) > 0 ) {	
	echo '<div class="headertext" id="headertext">Lijst</div><p>'."\n";
	echo '<form name="form1" id="form1" method="post">';

	while ( $row = mysqli_fetch_assoc( $res ) ) {
			if ( $row["qty"] == '0' ) {
				$class = 'form-control-inactief';  
				}
			else {
				$class = 'form-control-actief';
			}
		
		echo ' <div id="' . $class . '">' ."\n";
		echo ' <input type="text" min="0" class="  ' . $class . '" name="qty[' . $row["id"] . ']" placeholder="<aantal>" value="'.$row["qty"].'" size="4">'."\n";
		echo ' <select class="' . $class . '" name="unity[' . $row["id"] . ']">'."\n";
		echo '      <option value=""'. ($row['unity'] == '' ? ' selected="selected"' : '') .'></option>'."\n";
		echo '      <option value="Stuks"'. ($row['unity'] == 'Stuks' ? ' selected="selected"' : '') .'>Stuks</option>'."\n";
		echo '      <option value="Set"'. ($row['unity'] == 'Set' ? ' selected="selected"' : '') .'>Set</option>'."\n";
        echo '      <option value="Gram"'. ($row['unity'] == 'Gram' ? ' selected="selected"' : '') .'>Gram</option>'."\n";
		echo '      <option value="Pak"'. ($row['unity'] == 'Pak' ? ' selected="selected"' : '') .'>Pak</option>'."\n";
		echo '      <option value="Fles"'. ($row['unity'] == 'Fles' ? ' selected="selected"' : '') .'>Fles</option>'."\n";
		echo '      <option value="Krat"'. ($row['unity'] == 'Krat' ? ' selected="selected"' : '') .'>Krat</option>'."\n";
		echo '      <option value="Zak"'. ($row['unity'] == 'Zak' ? ' selected="selected"' : '') .'>Zak</option>'."\n";
		echo '      <option value="Bak"'. ($row['unity'] == 'Bak' ? ' selected="selected"' : '') .'>Bak</option>'."\n";
		echo '      <option value="Pot"'. ($row['unity'] == 'Pot' ? ' selected="selected"' : '') .'>Pot</option>'."\n";
		echo ' </select>'."\n";
		echo ' <input type="text" class="' . $class . '_bold" name="item[' . $row["id"] . ']" placeholder="<item>" value="'.$row["item"].'" size="20">'."\n";
		echo ' <input type="text" class="' . $class . '" name="memo[' . $row["id"] . ']" placeholder="<memo>" value="'.$row["memo"].'" size="10">'."\n";
		echo ' <select class="' . $class . '" name="class[' . $row["id"] . ']">'."\n";
		echo '      <option value=""'. ($row['class'] == 'ZZZZZZZZZ' ? ' selected="selected"' : '') .'></option>'."\n";		
		echo '      <option value="Fruit"'. ($row['class'] == 'Fruit' ? ' selected="selected"' : '') .'>Fruit</option>'."\n";
		echo '      <option value="Aardappelen"'. ($row['class'] == 'Aardappelen' ? ' selected="selected"' : '') .'>Aardappelen</option>'."\n";
		echo '      <option value="Groenten"'. ($row['class'] == 'Groenten' ? ' selected="selected"' : '') .'>Groenten</option>'."\n";
		echo ' </select>'."\n";
		echo '<input type="hidden" name="id[]" value="' . $row["id"] . '">  ' . "\n";

	}
	echo '<br>'. "\n";
	echo '<input type="submit" size=40 name="submit" value="Bewaren">' . "\n";
	echo '</div>' . "\n";
}

?>

<?php
error_reporting(E_ALL);
ini_set('display_errors', true);
?> 
<?php
 $con=mysqli_connect("localhost","root","","app");
 // Check connection
 if (mysqli_connect_errno())
   {
   echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }

// Perform queries 
mysqli_query($con,"SELECT * FROM list");


mysqli_close($con);
 ?> 

Ivo P op 23/08/2017 12:04:06

zet eens bovenin je script(s)

<?php
error_reporting(E_ALL);
ini_set('display_errors', true);
?>

Ik heb namelijk de indruk dat je geen foutmeldingen krijgt, terwijl die in deze gevallen toch vrij duidelijk zouden moeten zijn.

Stevie J op 23/08/2017 12:48:27

Ivo, is heb de code in een simpel script geplaatst, resultaat:

"Fatal error: Uncaught Error: Call to undefined function mysqli_connect() "

<?php
error_reporting(E_ALL);
ini_set('display_errors', true);
?> 
<?php
 $con=mysqli_connect("localhost","root","","app");
 // Check connection
 if (mysqli_connect_errno())
   {
   echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }

// Perform queries 
mysqli_query($con,"SELECT * FROM list");


mysqli_close($con);
 ?>