bool(true)
MySQLI INSERTED A ROW CONTAINING Walter Williams WITH AUTO_INCREMENT ID = 1
MySQLI INSERTED A ROW CONTAINING Ray Paseur WITH AUTO_INCREMENT ID = 2
MySQLI INSERTED A ROW CONTAINING Bill O\'Reilly WITH AUTO_INCREMENT ID = 3
MySQLI INSERTED A ROW CONTAINING Ray Capece WITH AUTO_INCREMENT ID = 4
MySQLI INSERTED A ROW CONTAINING John Paseur WITH AUTO_INCREMENT ID = 5


QUERY: SELECT id, xwhen, fname, lname FROM my_table WHERE fname='RAY' ORDER BY id 
FOUND 2 ROWS OF DATA 


USING MySQLi_Result::Fetch_Object(): 
stdClass Object
(
    [id] => 2
    [xwhen] => 2024-04-25 22:43:41
    [fname] => Ray
    [lname] => Paseur
)

stdClass Object
(
    [id] => 4
    [xwhen] => 2024-04-25 22:43:41
    [fname] => Ray
    [lname] => Capece
)


stdClass Object
(
    [Procedure] => find_by_First_Name
    [sql_mode] => NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    [Create Procedure] => CREATE DEFINER=`iconoun_iconoun`@`localhost` PROCEDURE `find_by_First_Name`( IN  p_first_name CHAR(24) )
BEGIN
SELECT id, xwhen, CONCAT(fname, ' ', lname) AS full_name
FROM my_table
WHERE fname = p_first_name
ORDER BY id;
END
    [character_set_client] => latin1
    [collation_connection] => latin1_swedish_ci
    [Database Collation] => latin1_swedish_ci
)

QUERY: CALL find_by_first_name('RAY') 
FOUND 2 ROWS OF DATA 


USING MySQLi_Result::Fetch_Object(): 
stdClass Object
(
    [id] => 2
    [xwhen] => 2024-04-25 22:43:41
    [full_name] => Ray Paseur
)

stdClass Object
(
    [id] => 4
    [xwhen] => 2024-04-25 22:43:41
    [full_name] => Ray Capece
)