fork download
copy 
  1. <?php
  2.  
  3. mb_internal_encoding('utf-8');
  4. error_reporting(-1);
  5.  
  6. $student = array('DatafirstName', 'DatalastName', 'Datasex', 'Datasection', 'Dataemail', 'Datayear', 'Dataexams', 'DataisLocal');
  7. $example = array('firstName', 'lastName', 'sex', 'section', 'email', 'year', 'exams', 'isLocal');
  8.  
  9. //foreach ($example as $field) {
  10. //	$student[] = $_POST[$field];
  11. //}
  12.  
  13. try {
  14. 	$DHB = new PDO('mysql:host = localhost;dbname = sat', 'root', '');
  15. 	$STH = $DHB->prepare("SELECT email FROM students WHERE email = ?");
  16. 	$STH->bindparam(1, $email);
  17. 	$email = $_POST['email'];
  18. 	if ($STH->execute()) {
  19. 		throw new PDOExpenition("Ошибка $email уже используеться.\n");
  20. 	} else {
  21. 		$STH = $DHB->prepare("INSERT into students (firstName, lastName, sex, section, email, year, exams, isLocal) values (?, ?, ?, ?, ?, ?, ?, ?)");
  22. 		$STH->execute($student);
  23. 	}
  24. }
  25. catch (PDOExpenition $e) {
  26.  
  27. }
  28. ?>
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:  Uncaught exception 'PDOException' with message 'could not find driver' in /home/hrCBlJ/prog.php:14
Stack trace:
#0 /home/hrCBlJ/prog.php(14): PDO->__construct('mysql:host = lo...', 'root', '')
#1 {main}
  thrown in /home/hrCBlJ/prog.php on line 14
https://ideone.com/B40RGE
language:
PHP (php 7.3.5)
created:
10 years ago
visibility:
public

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!