WordPress.org

Ready to get started?Download WordPress

Forums

[closed] How insert stored procedures into WP database (2 posts)

  1. aconceptor
    Member
    Posted 1 year ago #

    Hi all,

    I am looking for a solution to the following problem.
    I have to model a database for a wordpress plugin. Are present in this model procedures and functions.

    I found a way to create tables from the file which is stored in the SQL code.
    But I mound on stored procedures.
    Indeed, the proceedings is a result of instruction, we have ;, in the middle of this code.
    Function dbDelta made ​​a split precisely on the file;
    So my procedure and my functions causes an error.
    I also tried with the functions $ wpdb-> query and $ wpdb-> get_results without success.

    Someone would have a solution to my problem?

  2. jholder83864
    Member
    Posted 1 year ago #

    Take a look here:
    http://wordpress.org/support/topic/wordpress-and-stored-procedure?replies=2
    and see if that helps. WordPress doesn't create any SP, so as such, there's not a pretty way to interface with it using the wordpress functions. That thread should help you to be able to access and execute them.
    WARNING: this isn't at all suported, and will make your installation un-upgrade able. If at all possible, try to work around SP.

Topic Closed

This topic has been closed to new replies.

About this Topic