Reply to thread

Message

<blockquote data-quote="Berk" data-source="post: 436880" data-attributes="member: 63611">Hey, everyone. It's me again.So I'm doing abit of OOP here, and I have a bit of problem, where PDO returns only 1 row instead all rows, my code for example is below. This happens for every function, it only returns one row.[PHP]public static function getBans()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $conn; &nbsp; &nbsp; &nbsp; &nbsp; $stmt = $conn-&gt;prepare(&quot;SELECT * FROM bans&quot;);&nbsp; &nbsp; &nbsp; &nbsp; $stmt-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; $stmt = $stmt-&gt;fetchAll();&nbsp; &nbsp; &nbsp; &nbsp; foreach($stmt as $ban)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return &quot;&lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;th scope='row'&gt;&quot;.$ban['id'].&quot;&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.self::userDataFromId($ban['user_id'],'username').&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.$ban['ip'].&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.$ban['machine_id'].&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.self::userDataFromId($ban['user_staff_id'],'username').&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.date('Y-m-d H:s:i',$ban['timestamp']).&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.date('Y-m-d H:s:i',$ban['ban_expire']).&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.$ban['ban_reason'].&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.$ban['type'].&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;a href='editban?id=&quot;.$ban['id'].&quot;'&gt;&lt;i class='fa fa-pencil'&gt;&lt;/i&gt;&lt;/a&gt;&amp;nbsp; &lt;a id='delete' href='#' data-id='&quot;.$ban['id'].&quot;'&gt;&lt;i class='fa fa-trash'&gt;&lt;/i&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/tr&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }public static function getFilters()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $conn;&nbsp; &nbsp; &nbsp; &nbsp; $stmt = $conn-&gt;prepare(&quot;SELECT * FROM `hk`.`wordfilter` LIMIT 0, 1000&quot;);&nbsp; &nbsp; &nbsp; &nbsp; $stmt-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; $stmt = $stmt-&gt;fetchAll();&nbsp; &nbsp; &nbsp; &nbsp; foreach($stmt as $filter)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return &quot;&lt;tr id='&quot;. $filter['id']. &quot;'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.$filter['key'].&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot;.$filter['replacement'].&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;a href='editfilter?key=&quot;.$filter['key'].&quot;' id='edit' &gt;&lt;i class='fa fa-pencil'&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }[/PHP]I don't really know what I'm doing - i wish i did. anyway, I hope y'all can help me.Thanks.</blockquote>

[QUOTE="Berk, post: 436880, member: 63611"] Hey, everyone. It's me again. So I'm doing abit of OOP here, and I have a bit of problem, where PDO returns only 1 row instead all rows, my code for example is below. This happens for every function, it only returns one row. [PHP] public static function getBans() { global $conn; $stmt = $conn->prepare("SELECT * FROM bans"); $stmt->execute(); $stmt = $stmt->fetchAll(); foreach($stmt as $ban) { return "<tr> <th scope='row'>".$ban['id']."</th> <td>".self::userDataFromId($ban['user_id'],'username')."</td> <td>".$ban['ip']."</td> <td>".$ban['machine_id']."</td> <td>".self::userDataFromId($ban['user_staff_id'],'username')."</td> <td>".date('Y-m-d H:s:i',$ban['timestamp'])."</td> <td>".date('Y-m-d H:s:i',$ban['ban_expire'])."</td> <td>".$ban['ban_reason']."</td> <td>".$ban['type']."</td> <td><a href='editban?id=".$ban['id']."'></a>  <a id='delete' href='#' data-id='".$ban['id']."'></td> </tr>"; } } public static function getFilters() { global $conn; $stmt = $conn->prepare("SELECT * FROM `hk`.`wordfilter` LIMIT 0, 1000"); $stmt->execute(); $stmt = $stmt->fetchAll(); foreach($stmt as $filter) { return "<tr id='". $filter['id']. "'> <td>".$filter['key']."</td> <td>".$filter['replacement']."</td> <td><a href='editfilter?key=".$filter['key']."' id='edit' ></a></td> "; } } [/PHP] I don't really know what I'm doing - [SIZE=1]i wish i did. [/SIZE][SIZE=3]anyway, I hope y'all can help me. Thanks. [/SIZE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members