Prism ICT

Default image

MySql Call Self SP known as a recursive stored procedure

Sample SP Code DELIMITER // CREATE PROCEDURE RecursiveSP(IN n INT) BEGIN -- Base case: when n is less than or

Default image

MySql connection and query in PHP

If you trying to connect with the MySQL database quickly then you can use this code from below. It's simple

Default image

codeigniter count_all_results without reset query

If you want to count total data from table before get result then you can follow below codex. $this->select('Name'); $TotalData