View difference between Paste ID: ZhdWFiUg and Sq9bR0sp

 $dbUser = 'testUser';
 $dbPassword = 'testPassword';
 $dbCharset='utf-8';
 $dbName = 'testDb';
 $dbHost = 'localhost';
 
 $dsn = sprintf("mysql:host=%s;dbname=%s;charset=%s",$dbHost,$dbName,$dbCharset);
 $pdo = new PDO($dsn,$dbUser,$dbPassword);
 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
 
 $sql = "INSERT INTO users(nickname, name, surname, email, password) VALUES(:nickName,:name,:surname,:email,:password)";
-//Test insert
+$data = [
-$sql = "INSERT INTO table(field1,field2) VALUES('value1','value2')";
+':nickName' => $nickname,
-$pdo->exec($sql);
+':name' => $name,
 ':surname' => $surname,
-//Test insert multiple with prepared statement
+':email' => $email,
-$sql = "INSERT INTO table(field1,field2) VALUES(:value1,:value2)";
+':password' => $pass_1
 ];
 
-$rows = [
+
-[':value1' =>'value1',
+
-':value2' => 'value2'
+$result = $statement->execute($data);
-],
+if($result){
-[
+echo "Вы успешно зарегистрированы! Теперь вы можете зайти на сайт.";
-':value1' => 'value3',
+}else{
-':value2' => 'value4'
+echo "Ошибка! Вы не зарегистрированы.";
-]
+}