fork download
copy 
  1. <?php
  2.  
  3. $mysqli = new mysqli("localhost","user","password","db");
  4. if (mysqli_connect_errno()) {
  5. printf("Connect failed: %s\n", mysqli_connect_error());
  6. exit();
  7. }    
  8.  
  9. $i = 1;
  10. while ($i <= 14)
  11. {
  12.     $column = 'field_'.$i;
  13.     $sql= '"ALTER TABLE supply ADD '.$column.' VARCHAR(45)"';
  14.     $result = $mysqli->query($sql) ;
  15. 		if ($result){
  16. 		  echo "Table is updated. New column {$column} added" ;
  17. 		}
  18. $i++;
  19. }
  20.  
  21. ?>
Runtime error #stdin #stdout #stderr 0.01s 20568KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
PHP Fatal error:  Class 'mysqli' not found in /home/0Wz9LL/prog.php on line 3
https://ideone.com/1sHOzt
language:
PHP (php 7.3.5)
created:
10 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!