Professional Web Applications Themes

Return custom MySQL message in a stored procedure to PHP - MySQL

I'm testing PHP and MySQL. I'd like to know if it's possible to have MySQL return a custom message back to PHP from a stored procedure. Currently most web apps have multiple calls to the database for one process. Say, process is to insert a record. First call checks to see if the record already exists. If not then second call is to insert the record. I'd like to have PHP call one stored procedure in MySQL to do both calls and return a custom message '..record already exists..' or '..record inserted..'. TIA......

  1. #1

    Default Return custom MySQL message in a stored procedure to PHP

    I'm testing PHP and MySQL. I'd like to know if it's possible to have
    MySQL return a custom message back to PHP from a stored procedure.
    Currently most web apps have multiple calls to the database for one
    process. Say, process is to insert a record. First call checks to
    see if the record already exists. If not then second call is to
    insert the record. I'd like to have PHP call one stored procedure in
    MySQL to do both calls and return a custom message '..record already
    exists..' or '..record inserted..'. TIA...

    mouac01@yahoo.com Guest

  2. #2

    Default Re: Return custom MySQL message in a stored procedure to PHP

    On 12 Mar, 04:40, com wrote: 

    Rather than that, check out INSERT ... ON DUPLICATE KEY UPDATE and
    INSERT IGNORE.

    Captain Guest

  3. #3

    Default Re: Return custom MySQL message in a stored procedure to PHP

    On 11 Mar 2007 21:40:56 -0700, com wrote: 

    Have the procedure maintain a table that includes logging info? Read the
    log table for the results.

    --
    The pluses in my current job include laughing in the face of Nobel
    laureates who have just lost the only copy of their data. (Hey,
    I'm still a BOFH).
    -- Bob Dowling
    Peter Guest

Similar Threads

  1. Cannot return a value from a stored procedure
    By wittsdd in forum Coldfusion - Advanced Techniques
    Replies: 3
    Last Post: September 19th, 04:20 PM
  2. Trouble getting stored procedure return value!?
    By maxfraser in forum Dreamweaver AppDev
    Replies: 0
    Last Post: April 17th, 09:04 PM
  3. Can't get return Value from Stored Procedure
    By Mark Forsberg in forum Coldfusion Database Access
    Replies: 4
    Last Post: April 15th, 07:14 PM
  4. Replies: 15
    Last Post: July 27th, 05:35 AM
  5. Getting Return Value of Stored Procedure
    By Vipul Pathak in forum ASP Database
    Replies: 8
    Last Post: July 30th, 01:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139