Code Snippets

Some may laugh at this. I used to use this ugly, slow function repeatedly and stored the result in APC. | php

This was before RDS has MySQL cache, so I would store the result in memcached to prevent DB hits. It is convenient to get a quick single row, but really you want to fetch the row then cycle through it with a while function.

 * @param $con dbconnection
 * @param $query mysqlquery
 * @return mixed|string returns single result
function kishore_get($con, $query)
  // //echo $query;
  $result = $con->query($query);
  $value = $result->fetch_array(MYSQLI_NUM);
  return is_array($value) ? $value[0] : "";

Published: Mon 25th 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