Code Snippets

PHP / Mysqli Snippet to get all rows from a Mysql table | mysql

Quick reference for a quick PHP Mysqli retrieval of a query

// // form query, use " instead of ' if using PHP variables within.  Ommit the WHERE clause if you just want all data.
$query = "SELECT * from TABLENAME where WHATEVER";

// // NB, var $con assumes your mysqli connection
$result = mysqli_query($con, $query);
  // // output data of selected
  while ($row = mysqli_fetch_assoc($result)) {
    echo $row['whatever'];
    echo $row['whereever'];

Published: Sun 24th December 2017
||COMMENTS|| This site proudly uses PrismJS to display code snippets

If you like this page, please share it.

Code Links - PHP, JS, CSS, Bootstrap, Bash, Emmet, IntelliJ, Sublime etc.

My personal list of links which I keep here publicly incase they help someone else one day.

Code Snippets

Snippets of PHP code I have gathered over the years. I keep them here for my own repository but also to share with others. I always link back when I remember the source.

My Github Repos

A work in progress. I am going to make as many modules that I write in my devbox public as possible.

Kit's Homepage

This site was originally intended as a test bed for code. It now includes my blog about business and powerlifting, as well as games for Spanish language learning

© 2018