Php stored procedure call example

Php stored procedure call example

// For example, the stored procedure to be called is gxtj (a, B) $ Db = new mysqli ("localhost", "ssss", "aaaaa", "bbbb "); Mysqli_query ($ db, "set names utf8 "); $ Result = $ db-> query ("call gxtj ($ year, $ jd)"); // gxtj is the mysql stored procedure name [color = gray] [/color] While ($ row = $ result-> fetch_array (MYSQLI_ASSOC) // retrieves a row from the returned result set { While ($ key = key ($ row) {// Obtain the field name in sequence $ Value = current ($ row); // Obtain field values in sequence } }