Alt text of image doesn't appear

Question

I've trying to put alt text on images but seems to me that doesn't work. Here is how I try

// get the info from the db
$sql = "SELECT name, caption, alt FROM images order by id desc LIMIT $offset, $rowsperpage";
  $result = mysqli_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

   // while there are rows to be fetched...
  while ($list = mysqli_fetch_assoc($result)) {
   // echo data

  echo "<img src=\"upload/".$list['name']."\" alt=\"".$list['alt']."\" /></a>";
  echo $list['caption'];

With image and caption everything is fine. But in the html of the page I didn't see alt text.

update: var_dump($list)

array (size=3) 'name' => string '3ce08e141493823aeeded14f5dda6573.jpg' (length=36)  
'caption' => string 'image 1' (length=14) 
'alt' => string 'testing alt text 2' (length=18)

`alt` is the text that is displayed when an image in the `src` does not exists on the server. If you want the text to appear when you hover over the image, use `title` — Latheesan, Mar 20 '14 at 08:58
`print_r($list['alt']);` doesn't return anything. But in my table I have value.. — Goro, Mar 20 '14 at 09:01

score 4 · Answer 1 · answered Mar 20 '14 at 09:00

4

You will need to use title because the alt text will be shown in place of the image, any time the image isn't available. title will be shown as a tooltip on :hover for any browsers that support that functionality.

answered Mar 20 '14 at 09:00

Howli

12,291
19
47
72

score 1 · Answer 2 · edited May 23 '17 at 12:24

1

Make use of the title attribute instead of alt. I wonder why there is a trailing </a> tag on your echo.

The right way...

echo "<img src=upload/".$list['name']." title=".$list['alt']."/>";

Why should I use title attribute ?

edited May 23 '17 at 12:24

Community

1
1

answered Mar 20 '14 at 08:57

Shankar Narayana Damodaran

68,075
43
96
126

I forget to remove `` tag. With title again nothing in the html `
` – Goro Mar 20 '14 at 09:04
Can you try this ? `echo "";` – Shankar Narayana Damodaran Mar 20 '14 at 09:15
1

Now I can see it `` – Goro Mar 20 '14 at 09:19
But on localhost. When I try in hosting is `title=""` empty title – Goro Mar 20 '14 at 09:20
Since both databases are different , you may not have the `alt` value on your remote .. Did you check with `var_dump` again ? – Shankar Narayana Damodaran Mar 20 '14 at 09:24
Is not there when I check var_dump `array(2) { ["name"]=> string(36) "db139b1dd0064a5c7a22e0dbfb2f32cb.jpg" ["caption"]=> string(0) "" }` – Goro Mar 20 '14 at 09:27
That is the reason :) – Shankar Narayana Damodaran Mar 20 '14 at 09:28
So what can be the problem with my hosting? Any idea. Public database is version `5.5.36-cll - MySQL` and localhost is `5.6.12-log - MySQL` but I don't thing this is the problem – Goro Mar 20 '14 at 09:31
If the table does not contain the alt values how do you expect that to print ? Export your database from your localhost and import it inside your remote database and everything will work fine. – Shankar Narayana Damodaran Mar 20 '14 at 09:33
It have alt row in table and it have value. Databases are equal on local and remote. – Goro Mar 20 '14 at 09:34

score 1 · Accepted Answer · answered Mar 20 '14 at 08:58

1

Try this:

Pl check $list['alt'] is not empty & also set title value, so that you can test properly ...

-- Thanks

answered Mar 20 '14 at 08:58

Anand Solanki

3,419
4
16
27

Pl accept answer if you get solution. So that others can also get help. – Anand Solanki Mar 20 '14 at 09:12
I will but still is not fixed. – Goro Mar 20 '14 at 09:15
Ok. Just follow what I say in my answer and you will get solution. Try it. – Anand Solanki Mar 20 '14 at 09:16
`$list['alt']` is not empty you can see on var_dump($list) – Goro Mar 20 '14 at 09:18
Try: echo ""; – Anand Solanki Mar 20 '14 at 09:27
`title=''` empty title. And as I said on localhost work but in public host doesn't work. var_dump doesn't have alt.. – Goro Mar 20 '14 at 09:29
Then try using static value like alt = 'test value' and title = 'test value'. If it is working then your issue solved here. – Anand Solanki Mar 20 '14 at 09:31
`src=\"upload/".$list['name']."\" alt = 'test value' title = 'test value' />` don't have `alt` and `title` in html. Only on localhost – Goro Mar 20 '14 at 09:33

Alt text of image doesn't appear

3 Answers3