Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("inc/connect.php");
- $file = fopen('Profs.csv', 'r');
- $a=1;
- while (($line = fgetcsv($file, 0, "," , '"')) !== FALSE) { //ici une virgule
- $array[] = $line;
- }
- foreach($array as $entree){
- $query = $db->prepare("SELECT * FROM Users WHERE nom = ? AND prenom = ?");
- $query->execute(array($entree[0], $entree[1])); //Correction ici
- if($result = $query->fetch()){
- echo ($a++." error</br>");
- }
- else {
- $query = $db->prepare("INSERT INTO Users VALUES (?, ?)");
- $query->execute(array($entree[0], $entree[1]));
- } //J'ai juste inversé le if car je suis pas sur que le != fonctionne sur un fetch
- }
- fclose($file);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement