Skip to main content
A
Anonymous
February 28, 2010
Question

PHP Stored Procedure MySQL? CS4

  • February 28, 2010
  • 2 replies
  • 3374 views

This is half rant and half question.

I've been using ASP and MS SQL for years and started to move to PHP

So here's my question. Normally, when I'm using Stored Procedures in MSSQL, I create it in the database...no problem.

I then create a recordset in Dreamweaver that calls this procedure.

It looks something like this...{call user.nameofprocedure}

Above is the only thing I see in the recordset unless I'm pulling in a variable... Using SPs is nice because I don't have to open each page of my site if I want to change all the pages that use the same Stored Procedure. How can I pull in a stored procedure? Is it similar to this? {call user.nameofprocedure}\

Does using PHP mean I have to start writing queries in dreamweaver instead of the database?

I hope Dreamweaver supports SP; please let me know how to do this. Thanks

If now, I think I'm going to be really depressed about this. And if so, I will start to feel the pains as I start to realzie that the hype surrounding PHP has NOT lived up to the reality. I understand why open source is such a great thing but it just hasn't made anything any easier.

As I said, I've been using MSSql for years and then moved to MySQL. The interface and tools that MSSQL has are great. Features and "easy" to use. Now I'm trying to pick up with PHP/MySQL and I'm just not finding the same sophistication that I found with ASP/MSSQL...Man, I really want ot like php..but it's really hard to see why when it seems that so much is missing.  I just keep finding that there's a "roughness" to things associated with PHP?MySQL vs ASP/MS SQL.

IF PHP is the wave of the future, with Adobe and EVERYTHING else I"ve seen, they don't seem to be making it any easier.

It just seems, if you're going to replacing something with another technology, shouldn't it be better?

Open source is great all but why is everyone discontinuing support?\\

Well, back to my original question, does anyone have a good example of I can implement a stored procedure in Dreamweaver/php/MySQL?

This topic has been closed for replies.

2 replies

David_Powers
David_Powers
Inspiring
March 2, 2010

LArtJunky wrote:

I hope Dreamweaver supports SP; please let me know how to do this.

Dreamweaver's PHP server behaviors do not support stored procedures. Why? For the very simple reason that the server behaviors were designed in 2002, and have remained basically unchanged since then. Stored procedures were not added to MySQL until version 5.0, which was released in 2005, three years after the server behaviors were designed.

If now, I think I'm going to be really depressed about this. And if so, I will start to feel the pains as I start to realzie that the hype surrounding PHP has NOT lived up to the reality.

This has nothing to do with PHP. PHP is simply a server-side language that processes data and assists in communication with a database.

It sounds as though you have grown to become dependent on Dreamweaver server behaviors. They have always offered only the most basic functionality, and probably always will. Probably not the message you wanted to hear, but that's the way I see the situation.

A
Anonymous
March 3, 2010

Dreamweaver's PHP server behaviors do not support stored procedures. Why? For the very simple reason that the server behaviors were designed in 2002, and have remained basically unchanged since then. Stored procedures were not added to MySQL until version 5.0, which was released in 2005, three years after the server behaviors were designed.

David, I was aware that MySQL SPs are new. It just seems as though Adobe could update the server behaviors to fit the new technology.

This has nothing to do with PHP. PHP is simply a server-side language that processes data and assists in communication with a database.

Basically, I'm an Artist first and I have to admit that programming does not come easy to me...obviously. However, I'm a one-man-shop (always have been) so I"m forced to dig into things that I never thought I'd have to learn. Those Extensions have allowed me access into areas of programming that I never would have gotten into. In the long run, I probably would have been better had Macromedia not offered that functionality; I would have stayed grounded in the code itself. Before Dreamweaver's Behaviors came along, I was doing programming by hand in ASP and things were painfully slow and hard to learn because nobody else I knew was doing this stuff and there was just so little information out there to help. When those Extensions came along, It was such a relief and whole new areas opened up to me.

I just wish things would get easier rather than harder. I think we are still in the infancy of all this web development. Eventually I think Designers like myself won't have to deal with this stuff...it will all just be "built in."

I know that this Stored Procedure thing has nothing to do with PHP. I'm just want to be able to replicate SPs in PHP and still have Dreamweaver display my bindings . I like how easy these things can be and I buck against going backwards. Imagine if an Artists in Illustrator, in order to draw a box, had to work out the programming in asci every time they wanted that box? Well, that's generally where we're at with Web Design. Eventually, if you want a complete shopping cart, you'll just drop one into your design...Blog? Drop it in...I guess what drives me crazy right now is that it's a Programmers world. Programmers designing the code that builds the structure of the sites. Had Designers had a hand in this code development, we would have had columns in css.

Well, I guess I'll have to find my way through this stuff because I'll be retired before my future vision of Web Design is a reality.

A
Anonymous
March 3, 2010

So how do I connect using a stored procedure and PHP? I couldn't find anything on the web that shows how it might work with Dreamweaver.

Will I still be able to use Dreamweaver's server behaviors?

A
artjunky
Participant
February 28, 2010

s

Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices