If you need to convert php stdClass to array, there is a lazy one-liner method. In one liner we are using the JSON methods if you’re willing to lose a tiny bit of performance. Here you need to encode stdClass with json_encode and after that decode it using json_decode. Converting an array/stdClass -> stdClass $stdClass […]
Continue Reading →Think, you want to get timestamp for today midnight, then use following code. $timestamp = strtotime(‘today midnight’); Also, you can refer php date time here. http://php.net/datetime
Continue Reading →Codeigniter Active Record syntax for join $this->db->join(); Ex: $this->db->select(‘*’); $this->db->from(‘user’); $this->db->join(‘review’, ‘review.id = user.id’); $query = $this->db->get(); And it will generate following sql. SELECT * FROM user JOIN review ON review.id = user.id if you need several joins in one query, you have to call join function multiple times. If you need a specific type […]
Continue Reading →After installing MySQL and Apache/PHP, the database connections didn’t work from PHP. They worked only if connect using the MySQL client. Must be a problem with the PHP side. There is a sock file that PHP was trying to use, and it was in /var/mysql/mysql.sock and loged that the file was not there. Warning Error: […]
Continue Reading →If you want to empty or truncate a mysql table using codeigniter active record, use the following code. 🙂 To empty $this->db->empty_table(); This will generate a delete SQL string and runs the query. // DELETE FROM mytable To truncate $this->db->from(‘mytable’); $this->db->truncate(); // or $this->db->truncate(‘mytable’); This will generate a truncate SQL string and runs the query. […]
Continue Reading →The easiest way is to use date function, which lets you mix hard-coded values with ones extracted from a timestamp. If you don’t give a timestamp, it assumes the current date and time. <?php // Current timestamp is assumed, so these find first and last day of THIS month $first_day_this_month = date(‘m-01-Y’); // hard-coded ’01’ […]
Continue Reading →ffmpeg_animated_gif The ffmpeg_animated_gif object provides methods to create animated gif movies from a series of frames. ffmpeg_animated_gif object methods Method Description $gif = new ffmpeg_animated_gif(String output_file_path, Integer width, Integer height, Integer frame_rate, [Integer loop_count]) create a new ffmpeg_animated_gif object output_file_path – Location in the filesystem where the animated gif will be written. width – Width […]
Continue Reading →ffmpeg_frame The ffmpeg_frame object provides methods to query individual frames from a movie. ffmpeg_frame object methods Method Description $frame = new ffmpeg_frame(Resource gd_image) Create a frame object from a GD image. NOTE: This function will not be available if GD is not enabled. $frame->getWidth() Return the width of the frame. $frame->getHeight() Return the height of […]
Continue Reading →ffmpeg_movie The ffmpeg_movie object provides methods to query and manipulate movies and audio tracks. ffmpeg_movie object methods Method Description $movie = new ffmpeg_movie(String path_to_media, boolean persistent) Open a video or audio file and return it as an object. path_to_media – File path of video or audio file to open. persistent – Whether to open this […]
Continue Reading →In PHP, addslashes function is used to quote string with slashes. It returns a string with backslashes before characters that need to be quoted in database queries etc. These characters are single quote (‘), double quote (“), backslash (\) and NUL (the NULL byte). For example, to insert the name O’reilly into a database, you […]
Continue Reading →