Soucis de requete entre PHP et SQL
Bonjour,
Je n'arrive pas a executer ma requete SQL, apres diffrents tests, je suppose que le probleme provient de mon code PHP et non de la requete :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| function extractKWOS ($backDay) {
$db = mysqli_connect("localhost","interns","45Ge","test_reporting");
if (mysqli_connect_errno()) echo "Failed to connect to MySQL: ".mysqli_connect_error().'<br/>';
else {
echo 'Connected with phpMyAdmin.<br/>';
if($backDay == 1) {
$kwosPHP = $db->query('SELECT kwos FROM vow_backorders WHERE order_created_at <= DATE_SUB(order_created_at, INTERVAL 1 DAY) ');
while ($data = $kwosPHP->fetch()) {
echo 'ok';
echo $data['pord'].'<br />';
}
}
else {
$kwosPHP = $db->query('SELECT kwos FROM vow_backorders WHERE order_created_at <= DATE_SUB(order_created_at, INTERVAL 3 DAY)');
while ($data = $kwosPHP->fetch()) {
echo $data['order_created_at'].'<br />';
}
}
}
} |
Ainsi, pour savoir si c etait la requete qui etait fausse, j,ai prefere faire un requete plus simple :
Code:
1
2
3
4
5
6
7
8
9
10
11
|
echo 'Connected with phpMyAdmin.<br/>';
if($backDay == 1) {
echo 'ok';
$kwosPHP = $db->query('SELECT kwos FROM vow_backorders WHERE pord = \'PORD510055\' ');
echo 'test';
while ($data = $kwosPHP->fetch()) {
echo 'ok';
echo $data['pord'].'<br />';
}
} |
Je recois :
Connected with phpMyAdmin.
oktest
Merci !!!
