PHP and MySQL Stored Procedure Exec Problem 


  • <?php

  • $Server = "127.0.0.1";

  • $DataBase = "tedt";

  • $UserName = "root";

  • $PassWord = "124@#";

  • $Conn = mysqli_connect($host, $UserName, $PassWord);

  • if(!$Conn)

  • {

  •     die("Could not connect to server : " . mysqli_error());

  • }

  • else

  • {

  •     mysqli_select_db($Conn,$DataBase) or die("Could not connect to database");

  • }

  • ?>

  • <?php

  • print "Procedure #1";



  • $res= $Conn->query("CALL storepro;");

  • print_r($res) ;

    • ?>

    Comments

    Post a Comment

    Popular posts from this blog

    php format date string short month

    As you can see in our last example there are tons of different formats that can be used in the date feature. Below is a summary of the variable used in date, and what each does. Remember they ARE CaSe sEnsItIVe: DAYS   d - day of the month 2 digits (01-31)   j - day of the month (1-31)   D - 3 letter day (Mon - Sun)   l - full name of day (Monday - Sunday)   N - 1=Monday, 2=Tuesday, etc (1-7)   S - suffix for date (st, nd, rd)   w - 0=Sunday, 1=Monday (0-6)   z - day of the year (1=365) WEEK   W - week of the year (1-52) MONTH   F - Full name of month (January - December) m - 2 digit month number (01-12)   n - month number (1-12)   M - 3 letter month (Jan - Dec)   t - Days in the month (28-31) YEAR L - leap year (0 no, 1 yes) o - ISO-8601 year number (Ex. 1979, 2006) Y - four digit year (Ex. 1979, 2006) y - two digit year (Ex. 79, 06) TIME a - am or pm A - AM or PM B - Swatch Internet time (...
    Read more

    Attempting to understand handling regular expressions with php

    Regular Expression, commonly known as RegEx is considered to be one of the most complex concepts. However, this is not really true. Unless you have worked with regular expressions before, when you look at a regular expression containing a sequence of special characters like /, $, ^, \, ?, *, etc., in combination with alphanumeric characters, you might think it a mess. RegEx is a kind of language and if you have learnt its symbols and understood their meaning, you would find it as the most useful tool in hand to solve many complex problems related to text searches. Just consider how you would make a search for files on your computer. You most likely use the ? and * characters to help find the files you're looking for. The ? character matches a single character in a file name, while the * matches zero or more characters. A pattern such as 'file?.txt' would find the following files: file1.txt filer.txt files.txt Using the * character inst...
    Read more