PHP FETCH data from db on row by row not column

Question

I need to fetch data from my db. I've done it but when I say fetch array [1], the output is the all second letters in all rows. Here is the code:

include "baglan2.php";

$query = $db->query("SELECT * FROM diziler", PDO::FETCH_ASSOC);
if ( $query->rowCount() ){
 foreach( $query as $row ){
    echo ($row['link']. "<br />");
 }

I tried it with msqli but saw the same result; here is the mysqli code:

$query = mysqli_query($baglanti, "SELECT * FROM diziler");
if ( mysqli_affected_rows($baglanti) ){
 while ( $row = mysqli_fetch_assoc($query) ){
       print $row['link'][1]."<br />";
 }
 }

For instance all my data are links. When I run print $row['link'][1], it gives "t" letter from "http:" in all rows. I need to fetch my data by row not column. I have tried every method possible. However I couldn't find any method that worked.

for instance I want to make this codes output "http://**.com" in each element.

$query = mysqli_query($baglanti, "SELECT link FROM diziler"); $link_array = array(); if ( $query){ while ( $row = mysqli_fetch_assoc($query) ){ $link_array[] = $row['link']; } } echo "<pre/>";print_r($link_array); — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Sep 23, 2016 at 22:33
$row['link'] is a string. When you put an index after a string, it accesses that character in the string. Why did you write [1]? — Barmar
– Barmar, Commented Sep 23, 2016 at 23:32
@MartavisGriffin Why shouldn't he use foreach? PDOStatement implements Iterable, which allows you to use foreach. — Barmar
– Barmar, Commented Sep 23, 2016 at 23:33
The first one should have worked, since it doesn't have [1] in it. — Barmar
– Barmar, Commented Sep 23, 2016 at 23:33

Community · Accepted Answer · 2017-05-23 12:32:17Z

0

I am giving solution based on second attempt:-

$query = mysqli_query($baglanti, "SELECT link FROM diziler"); 
$link_array = array(); 
if ( $query){ 
    while ( $row = mysqli_fetch_assoc($query) ){ 
               $link_array[] = $row['link']; 
    } 
} 
echo "<pre/>";print_r($link_array); // it have all the links

Reason:- https://eval.in/649070

It's specification is given here:- https://stackoverflow.com/a/17193651/4248328

That is:- $string[int] is syntactic sugar for substr($string, int, 1)

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Sep 23, 2016 at 22:41

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tarık Baysal Over a year ago

god save u bro :)

Death-is-the-real-truth Over a year ago

Thanks @TarıkBaysal.

Collectives™ on Stack Overflow

PHP FETCH data from db on row by row not column

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related