Use of undefined constant PDO

Question

I've looked at other similar questions about this topic, but I couldn't find what am I missing.

I am trying to convert my mysql_ codes to the PDO, but although first part is very simple yet I couldn't deal with it. What am I doing wrong? Also I have to use utf8, otherwise I'm getting characters problem.

So my issue is:

Use of undefined constant IL_ADI assumed 'IL_ADI'

I've tried $oku['IL_ADI'] and no data was returned.

$dab = new PDO("mysql:host=localhost; dbname=datauser; charset=utf8" ,'user_user' , 'password');
$dab->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$dab->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

$query = 'SELECT * FROM iller ORDER BY IL_ADI';

$result= $dab->query($query);
while($oku=$result->fetch(PDO::FETCH_ASSOC)){

    print_r ("<option name='ilsec' value=''");
    print_r ($oku[IL_ADI]);
}

print_r ($oku[IL_ADI]); use this with single quote print_r ($oku['IL_ADI']); — Amit Gaud, May 28 '17 at 15:00
Thanks for fast responseI've tried that and no data returned. — ozan, May 28 '17 at 15:02
You can't use directly IL_ADI, without apostrophes is a constant, no a string. Remember also, PHP is case-sensitive, if your table row name is il_adi, you need to use 'il_adi', not 'IL_ADI'. For more data, show your table structure as suggested by @AmitGaud — Sakura Kinomoto, May 28 '17 at 15:10
@Amit Gaud Table name is iller and has just two columns rownumber and IL_ADI , engine myISAM, collation utf8_turkish_ci — ozan, May 28 '17 at 15:11
*"I've tried $oku['IL_ADI'] and no data was returned."* - then your query failed. Plus seeing `(" — Funk Forty Niner, May 28 '17 at 15:17
*"utf8, otherwise I'm getting characters problem"* - Consult https://stackoverflow.com/questions/279170/utf-8-all-the-way-through — Funk Forty Niner, May 28 '17 at 15:19
@Fred-ii- I'm trying the IL_ADI data to show in the select option field if it helps i can post full code. But I don't want to take your more time. I'm reading the link you've send. — ozan, May 28 '17 at 15:30

score 0 · Answer 1 · answered May 28 '17 at 16:15

0

print_r ("<option name='ilsec' value=''");

to

print_r ("<option name='ilsec' value=''>");

I've forgot to put > . After adding that the data has come. But other problems came along:) Thank you everyone for the quick answers.

answered May 28 '17 at 16:15

ozan

1
3

Use of undefined constant PDO

1 Answers1