Soucis de base de données on-line
Ferméjordane45 Messages postés 38404 Date d'inscription mercredi 22 octobre 2003 Statut Modérateur Dernière intervention 2 février 2025 - 30 mars 2023 à 19:14
- Soucis de base de données on-line
- Formules excel de base - Guide
- Base de registre - Guide
- Tnt base de données vide - Forum TNT / Satellite / Réception
- Gigaset ne reconnait plus sa base - Forum telephonie fixe
- Supprimer les données de navigation - Guide
4 réponses
28 mars 2023 à 06:31
Bonjour
Commence par ça
Si tu ne vois toujours pas d'erreur.... Montre nous ton code.
30 mars 2023 à 16:41
bonjour jordan45 . je n'ai pas toujours resolu le probleme.
voici le code php de la page
<?php require_once('header.php'); ?> <?php $statement = $pdo->prepare("SELECT * FROM tbl_settings WHERE id=1"); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { $banner_registration = $row['banner_registration']; } ?> <?php if (isset($_POST['form1'])) { $valid = 1; if(empty($_POST['cust_name'])) { $valid = 0; $error_message .= LANG_VALUE_123."<br>"; } if(empty($_POST['cust_email'])) { $valid = 0; $error_message .= LANG_VALUE_131."<br>"; } else { if (filter_var($_POST['cust_email'], FILTER_VALIDATE_EMAIL) === false) { $valid = 0; $error_message .= LANG_VALUE_134."<br>"; } else { $statement = $pdo->prepare("SELECT * FROM tbl_customer WHERE cust_email=?"); $statement->execute(array($_POST['cust_email'])); $total = $statement->rowCount(); if($total) { $valid = 0; $error_message .= LANG_VALUE_147."<br>"; } } } if(empty($_POST['cust_phone'])) { $valid = 0; $error_message .= LANG_VALUE_124."<br>"; } if(empty($_POST['cust_address'])) { $valid = 0; $error_message .= LANG_VALUE_125."<br>"; } if(empty($_POST['cust_country'])) { $valid = 0; $error_message .= LANG_VALUE_126."<br>"; } if(empty($_POST['cust_city'])) { $valid = 0; $error_message .= LANG_VALUE_127."<br>"; } if(empty($_POST['cust_state'])) { $valid = 0; $error_message .= LANG_VALUE_128."<br>"; } if(empty($_POST['cust_zip'])) { $valid = 0; $error_message .= LANG_VALUE_129."<br>"; } if( empty($_POST['cust_password']) || empty($_POST['cust_re_password']) ) { $valid = 0; $error_message .= LANG_VALUE_138."<br>"; } if( !empty($_POST['cust_password']) && !empty($_POST['cust_re_password']) ) { if($_POST['cust_password'] != $_POST['cust_re_password']) { $valid = 0; $error_message .= LANG_VALUE_139."<br>"; } } if($valid == 1) { $token = md5(time()); $cust_datetime = date('Y-m-d h:i:s'); $cust_timestamp = time(); // saving into the database $statement = $pdo->prepare("INSERT INTO tbl_customer ( cust_name, cust_cname, cust_email, cust_phone, cust_country, cust_address, cust_city, cust_state, cust_zip, cust_b_name, cust_b_cname, cust_b_phone, cust_b_country, cust_b_address, cust_b_city, cust_b_state, cust_b_zip, cust_s_name, cust_s_cname, cust_s_phone, cust_s_country, cust_s_address, cust_s_city, cust_s_state, cust_s_zip, cust_password, cust_token, cust_datetime, cust_timestamp, cust_status ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); $statement->execute(array( strip_tags($_POST['cust_name']), strip_tags($_POST['cust_cname']), strip_tags($_POST['cust_email']), strip_tags($_POST['cust_phone']), strip_tags($_POST['cust_country']), strip_tags($_POST['cust_address']), strip_tags($_POST['cust_city']), strip_tags($_POST['cust_state']), strip_tags($_POST['cust_zip']), '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', md5($_POST['cust_password']), $token, $cust_datetime, $cust_timestamp, 1 )); // Send email for confirmation of the account $to = $_POST['cust_email']; $subject = LANG_VALUE_150; $verify_link = BASE_URL.'verify.php?email='.$to.'&token='.$token; $message = ' '.LANG_VALUE_151.'<br><br> <a href="'.$verify_link.'">'.$verify_link.'</a>'; $headers = "From: noreply@" . BASE_URL . "\r\n" . "Reply-To: noreply@" . BASE_URL . "\r\n" . "X-Mailer: PHP/" . phpversion() . "\r\n" . "MIME-Version: 1.0\r\n" . "Content-Type: text/html; charset=ISO-8859-1\r\n"; // Sending Email mail($to, $subject, $message, $headers); unset($_POST['cust_name']); unset($_POST['cust_cname']); unset($_POST['cust_email']); unset($_POST['cust_phone']); unset($_POST['cust_address']); unset($_POST['cust_city']); unset($_POST['cust_state']); unset($_POST['cust_zip']); $success_message = LANG_VALUE_152; } } ?> <div class="page-banner" style="background-color:#444;background-image: url(assets/uploads/<?php echo $banner_registration; ?>);"> <div class="inner"> <h1><?php echo LANG_VALUE_16; ?></h1> </div> </div> <div class="page"> <div class="container"> <div class="row"> <div class="col-md-12"> <div class="user-content"> <form action="" method="post"> <?php $csrf->echoInputField(); ?> <div class="row"> <div class="col-md-2"></div> <div class="col-md-8"> <?php if($error_message != '') { echo "<div class='error' style='padding: 10px;background:#f1f1f1;margin-bottom:20px;'>".$error_message."</div>"; } if($success_message != '') { echo "<div class='success' style='padding: 10px;background:#f1f1f1;margin-bottom:20px;'>".$success_message."</div>"; } ?> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_102; ?> *</label> <input type="text" class="form-control" name="cust_name" value="<?php if(isset($_POST['cust_name'])){echo $_POST['cust_name'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_103; ?></label> <input type="text" class="form-control" name="cust_cname" value="<?php if(isset($_POST['cust_cname'])){echo $_POST['cust_cname'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_94; ?> *</label> <input type="email" class="form-control" name="cust_email" value="<?php if(isset($_POST['cust_email'])){echo $_POST['cust_email'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_104; ?> *</label> <input type="text" class="form-control" name="cust_phone" value="<?php if(isset($_POST['cust_phone'])){echo $_POST['cust_phone'];} ?>"> </div> <div class="col-md-12 form-group"> <label for=""><?php echo LANG_VALUE_105; ?> *</label> <textarea name="cust_address" class="form-control" cols="30" rows="10" style="height:70px;"><?php if(isset($_POST['cust_address'])){echo $_POST['cust_address'];} ?></textarea> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_106; ?> *</label> <select name="cust_country" class="form-control select2"> <option value="">Select country</option> <?php $statement = $pdo->prepare("SELECT * FROM tbl_country ORDER BY country_name ASC"); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { ?> <option value="<?php echo $row['country_id']; ?>"><?php echo $row['country_name']; ?></option> <?php } ?> </select> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_107; ?> *</label> <input type="text" class="form-control" name="cust_city" value="<?php if(isset($_POST['cust_city'])){echo $_POST['cust_city'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_108; ?> *</label> <input type="text" class="form-control" name="cust_state" value="<?php if(isset($_POST['cust_state'])){echo $_POST['cust_state'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_109; ?> *</label> <input type="text" class="form-control" name="cust_zip" value="<?php if(isset($_POST['cust_zip'])){echo $_POST['cust_zip'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_96; ?> *</label> <input type="password" class="form-control" name="cust_password"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_98; ?> *</label> <input type="password" class="form-control" name="cust_re_password"> </div> <div class="col-md-6 form-group"> <label for=""></label> <input type="submit" class="btn btn-danger" value="<?php echo LANG_VALUE_15; ?>" name="form1"> </div> </div> </div> </form> </div> </div> </div> </div> </div> <?php require_once('footer.php'); ?>
30 mars 2023 à 16:46
Maintenant que je sais que tu es en PDO ... applique ceci
https://forums.commentcamarche.net/forum/affich-37584941-php-pdo-gerer-les-erreurs
Et comme pour ma réponse précédente :
Si tu ne vois toujours pas d'erreur.... Montre nous ton code.
Modifié le 30 mars 2023 à 17:51
voici le code complet de la page jd enregistrement ordan45.
merci d'avance
<?php require_once('header.php'); ?> <?php $statement = $pdo->prepare("SELECT * FROM tbl_settings WHERE id=1"); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { $banner_registration = $row['banner_registration']; } ?> <?php if (isset($_POST['form1'])) { $valid = 1; if(empty($_POST['cust_name'])) { $valid = 0; $error_message .= LANG_VALUE_123."<br>"; } if(empty($_POST['cust_email'])) { $valid = 0; $error_message .= LANG_VALUE_131."<br>"; } else { if (filter_var($_POST['cust_email'], FILTER_VALIDATE_EMAIL) === false) { $valid = 0; $error_message .= LANG_VALUE_134."<br>"; } else { $statement = $pdo->prepare("SELECT * FROM tbl_customer WHERE cust_email=?"); $statement->execute(array($_POST['cust_email'])); $total = $statement->rowCount(); if($total) { $valid = 0; $error_message .= LANG_VALUE_147."<br>"; } } } if(empty($_POST['cust_phone'])) { $valid = 0; $error_message .= LANG_VALUE_124."<br>"; } if(empty($_POST['cust_address'])) { $valid = 0; $error_message .= LANG_VALUE_125."<br>"; } if(empty($_POST['cust_country'])) { $valid = 0; $error_message .= LANG_VALUE_126."<br>"; } if(empty($_POST['cust_city'])) { $valid = 0; $error_message .= LANG_VALUE_127."<br>"; } if(empty($_POST['cust_state'])) { $valid = 0; $error_message .= LANG_VALUE_128."<br>"; } if(empty($_POST['cust_zip'])) { $valid = 0; $error_message .= LANG_VALUE_129."<br>"; } if( empty($_POST['cust_password']) || empty($_POST['cust_re_password']) ) { $valid = 0; $error_message .= LANG_VALUE_138."<br>"; } if( !empty($_POST['cust_password']) && !empty($_POST['cust_re_password']) ) { if($_POST['cust_password'] != $_POST['cust_re_password']) { $valid = 0; $error_message .= LANG_VALUE_139."<br>"; } } if($valid == 1) { $token = md5(time()); $cust_datetime = date('Y-m-d h:i:s'); $cust_timestamp = time(); // saving into the database $statement = $pdo->prepare("INSERT INTO tbl_customer ( cust_name, cust_cname, cust_email, cust_phone, cust_country, cust_address, cust_city, cust_state, cust_zip, cust_b_name, cust_b_cname, cust_b_phone, cust_b_country, cust_b_address, cust_b_city, cust_b_state, cust_b_zip, cust_s_name, cust_s_cname, cust_s_phone, cust_s_country, cust_s_address, cust_s_city, cust_s_state, cust_s_zip, cust_password, cust_token, cust_datetime, cust_timestamp, cust_status ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); $statement->execute(array( strip_tags($_POST['cust_name']), strip_tags($_POST['cust_cname']), strip_tags($_POST['cust_email']), strip_tags($_POST['cust_phone']), strip_tags($_POST['cust_country']), strip_tags($_POST['cust_address']), strip_tags($_POST['cust_city']), strip_tags($_POST['cust_state']), strip_tags($_POST['cust_zip']), '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', md5($_POST['cust_password']), $token, $cust_datetime, $cust_timestamp, 1 )); // Send email for confirmation of the account $to = $_POST['cust_email']; $subject = LANG_VALUE_150; $verify_link = BASE_URL.'verify.php?email='.$to.'&token='.$token; $message = ' '.LANG_VALUE_151.'<br><br> <a href="'.$verify_link.'">'.$verify_link.'</a>'; $headers = "From: noreply@" . BASE_URL . "\r\n" . "Reply-To: noreply@" . BASE_URL . "\r\n" . "X-Mailer: PHP/" . phpversion() . "\r\n" . "MIME-Version: 1.0\r\n" . "Content-Type: text/html; charset=ISO-8859-1\r\n"; // Sending Email mail($to, $subject, $message, $headers); unset($_POST['cust_name']); unset($_POST['cust_cname']); unset($_POST['cust_email']); unset($_POST['cust_phone']); unset($_POST['cust_address']); unset($_POST['cust_city']); unset($_POST['cust_state']); unset($_POST['cust_zip']); $success_message = LANG_VALUE_152; } } ?> <div class="page-banner" style="background-color:#444;background-image: url(assets/uploads/<?php echo $banner_registration; ?>);"> <div class="inner"> <h1><?php echo LANG_VALUE_16; ?></h1> </div> </div> <div class="page"> <div class="container"> <div class="row"> <div class="col-md-12"> <div class="user-content"> <form action="" method="post"> <?php $csrf->echoInputField(); ?> <div class="row"> <div class="col-md-2"></div> <div class="col-md-8"> <?php if($error_message != '') { echo "<div class='error' style='padding: 10px;background:#f1f1f1;margin-bottom:20px;'>".$error_message."</div>"; } if($success_message != '') { echo "<div class='success' style='padding: 10px;background:#f1f1f1;margin-bottom:20px;'>".$success_message."</div>"; } ?> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_102; ?> *</label> <input type="text" class="form-control" name="cust_name" value="<?php if(isset($_POST['cust_name'])){echo $_POST['cust_name'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_103; ?></label> <input type="text" class="form-control" name="cust_cname" value="<?php if(isset($_POST['cust_cname'])){echo $_POST['cust_cname'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_94; ?> *</label> <input type="email" class="form-control" name="cust_email" value="<?php if(isset($_POST['cust_email'])){echo $_POST['cust_email'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_104; ?> *</label> <input type="text" class="form-control" name="cust_phone" value="<?php if(isset($_POST['cust_phone'])){echo $_POST['cust_phone'];} ?>"> </div> <div class="col-md-12 form-group"> <label for=""><?php echo LANG_VALUE_105; ?> *</label> <textarea name="cust_address" class="form-control" cols="30" rows="10" style="height:70px;"><?php if(isset($_POST['cust_address'])){echo $_POST['cust_address'];} ?></textarea> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_106; ?> *</label> <select name="cust_country" class="form-control select2"> <option value="">Select country</option> <?php $statement = $pdo->prepare("SELECT * FROM tbl_country ORDER BY country_name ASC"); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { ?> <option value="<?php echo $row['country_id']; ?>"><?php echo $row['country_name']; ?></option> <?php } ?> </select> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_107; ?> *</label> <input type="text" class="form-control" name="cust_city" value="<?php if(isset($_POST['cust_city'])){echo $_POST['cust_city'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_108; ?> *</label> <input type="text" class="form-control" name="cust_state" value="<?php if(isset($_POST['cust_state'])){echo $_POST['cust_state'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_109; ?> *</label> <input type="text" class="form-control" name="cust_zip" value="<?php if(isset($_POST['cust_zip'])){echo $_POST['cust_zip'];} ?>"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_96; ?> *</label> <input type="password" class="form-control" name="cust_password"> </div> <div class="col-md-6 form-group"> <label for=""><?php echo LANG_VALUE_98; ?> *</label> <input type="password" class="form-control" name="cust_re_password"> </div> <div class="col-md-6 form-group"> <label for=""></label> <input type="submit" class="btn btn-danger" value="<?php echo LANG_VALUE_15; ?>" name="form1"> </div> </div> </div> </form> </div> </div> </div> </div> </div> <?php require_once('footer.php'); ?>
30 mars 2023 à 17:56
code de la page connexion
<?php // Error Reporting Turn On ini_set('error_reporting', E_ALL); // Setting up the time zone date_default_timezone_set('America/Los_Angeles'); // Host Name $dbhost = 'localhost'; // Database Name $dbname = 'ecommerce'; // Database Username $dbuser = 'root'; // Database Password $dbpass = ''; // Defining base url define("BASE_URL", ""); // Getting Admin url define("ADMIN_URL", BASE_URL . "admin" . "/"); try { $pdo = new PDO("mysql:host={$dbhost};dbname={$dbname}", $dbuser, $dbpass); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch( PDOException $exception ) { echo "Connection error :" . $exception->getMessage(); }
30 mars 2023 à 18:26
Et les try catch au niveau de tes requêtes ?
30 mars 2023 à 19:09
jordane45, s'il te plait je ne comprend pas la question . s'il te plait soit un peu plus explicite
30 mars 2023 à 19:14
Je pense que les explications qui se trouvent dans le lien que je t'ai donné sont suffisamment clair surtout qu'elle dispose d'exemples.