PHP CodeIgniter - MySQL Workbench

935

I will be developing a website with PHP CodeIgniter(Framework) and MySQL. I already have done different project using the tools.

Here is something new to me ... I ask about my Professor if I could make a stored procedure on PHP-MySQL then, he suggested me this "MySQL Workbench". I already have experience making stored procedure in SQL and it work so fine to me.

I already "googled" a lot but I could not find any tutorial from scratch about PHP CodeIgniter and MySQL Workbench interaction. Could any body help me? Any tutorial/reference would help. Thank you

808

Answer

Solution:

Check How to write a stored procedure using phpMyAdmin and how to use it through php?

delimiter //
CREATE PROCEDURE sp_test()
BEGIN
  SELECT 'Number of records: ', count(*) from test;
END//

But I recommend to use MySQL Workbench instead.

More information: php.net stored procedure refrence

People are also looking for solutions to the problem: laravel php artisan migrate does not create a new table

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.