Re: Dreamweaver CC and PHP / MySql

osgood_ · ‎Jun 21, 2013

Nancy O. wrote: Changing the underlying programming from countless JS server behavior files to a radically new approach is a Herculean task. I certainly wouldn't want to write this code. Would you? Should have been thought about a few years back in my opinion. Adobe must know that the core structure of the program was built around the server behaviours. I'm sure it was a Herculean task to build the server behaviours first time around, nothing has changed apart from Adobe has this time make a complete bungle.

osgood_ · ‎Jun 18, 2013

hyadav wrote: -Harshit yadav Yes. that's what most people are saying at the moment, lol

osgood_ · ‎Jun 18, 2013

John Waller wrote: Seems that ColdFusion support is removed in Dreamweaver CC and later http://help.adobe.com/en_US/dreamweaver/cs/using/WScbb6b82af5544594822 510a94ae8d65-7874a.html lol seems they are doing their very best to alienate customers.

osgood_ · ‎May 29, 2013

I usually just put the connection details in a stand alone file and use an include file in each page which needs a database connection <?php include('database_connection.php'); ?>

osgood_ · ‎Apr 25, 2013

Aftert much searching and trawling through a load of trash I final found an answer which was plain to follow. <?php $id = $_GET['id']; $stmt = $conn->prepare("SELECT productId, productName, productDate, productQuantity FROM products WHERE id=?"); $stmt->bind_param('i',$id); $stmt->bind_result($productId, $productName, $productDate, $productQuantity); $stmt->execute(); $stmt->fetch(); ?> Then you can echo out the database column anywhere on the page. <h1><?php echo $productName;?></h1> I dont know why productID becomes a variable - $productID and so on, which need to be in the bind_results function. These thing work in mysteroius ways. Ok now this opens up another question after looking at your code how do you do it when selecting from more than one table??? Does it become: $stmt->bind_result($table1.col1, table2.column1); or what? I can tell you one thing unless you get the bind_result in the correct order you'll be ****** over a barrel backwards because nothing will show on the page. In a sql query it didnt matter what order they came in so I can see the prepared statement thing is going to be a bit of a nightmare for complex queries. Good luck.

osgood_ · ‎Apr 25, 2013

tessimon wrote: Sorry to confuse this is not the issue as I just put in general terms for colums and ids to make it easier to understand and I have mistyped a space. My issue I think is with $row = $stmt->fetch(); and echo $row['col1']; etc... if I bind the result they display if I use these last 2 lines I get nothing. Thank you for you response though, this could easily have been the answer. Did you solve the issue as I'm having exactly the same problem as you. I cannot find a way to display the results by echoing them out to the page.........I'm begining to think can it even be done using prepared statements as I've seen no examples on the web which explain the procedure. I can do it using real_escape_string but that is really messy if you have a lots of $_POSTS or $_GETS and I'm not even sure real_escape_string fully protects against injections.

osgood_ · ‎Apr 23, 2013

Do you have this as the while loop? while($row_rsSum = mysql_fetch_assoc($result))

osgood_ · ‎Apr 23, 2013

Change the query to this: $query = "SELECT SUM(host_editpropUtil.utilityAmount), host_editprop.prop_id WHERE prop_id = $recordID"; and the echo to this: echo $row['SUM(host_editpropUtil.utilityAmount)']; What happens now?

osgood_ · ‎Apr 23, 2013

What would this give you? $recordID = $_GET['recordID']; $query = "SELECT host_editpropUtil.SUM(utilityAmount), host_editprop.prop_id WHERE prop_id = $recordID"; $result = mysql_query($query); while($row = mysql_fetch_assoc($result)) { echo $row['SUM(utilityAmount)']; }

osgood_ · ‎Apr 23, 2013

Jonathan Fortis wrote: let me know how you get on please I split the products and customer information into two tables and it still works. The sql query still isn't anywhere near as complex as yours is though. What we have established is the do-while loop does work if you break out and back into the php again. What I would do is a test using two simple tables first to get the do-while loop working. Once that is working you have a template. Then its a case of building the sql query.

osgood_ · ‎Apr 22, 2013

Jonathan Fortis wrote: ok i will try that and let you know how i get on thanks for your help I don't think there can be much wrong with what you have. Now I know the loop works it should work even if the information is being sourced from a dedicated 'products' table. The fact that you get the first record returned is encouraging because it means at least the query is correct. For my own curiosity I'll seperate the data into two tables tomorrow and see what happens.

osgood_ · ‎Apr 22, 2013

Yes, ALL product information in the database were retrieved and sent to the email. Only 3 products for testing purposes. I just tested it down to the do-while loop. The html table code after that is missing. You have to bare in mind this is a crude test. The database set up query is not as complex as yours is so that may be why its working but certainly breaking up the 'message' is the way to go. I may try and get the products from another table tomorrow if I have time to test. The html code and column database names are the same as you have. the recordeset is 'rsOrders' instead of 'rsOrder' that you used, <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } mysql_select_db($database_conDonations, $conDonations); $query_rsOrders = "SELECT * FROM orders"; $rsOrders = mysql_query($query_rsOrders, $conDonations) or die(mysql_error()); $row_rsOrders = mysql_fetch_assoc($rsOrders); $totalRows_rsOrders = mysql_num_rows($rsOrders); //emailer // Email new tenant information $to = 'email@email.co.uk';// . ',' . '$row_rsOrder["Email"]'; //$to = $row_rsOrder["Email"]; $subject = "Your Order Details"; $message = " <html> <head> <title>Dear ".$row_rsOrders['FirstName']." please see your Order Details Below</title> </head> <body> <img src=\"http://www.website.com/images/logoBLPP.jpg\" alt=\"\" /> <h2>Your B Order".$row_rsOrders['OrderID']."</h2> <table width='800' border='0' cellspacing='0' cellpadding='0'> <tr><td><p>Thank you for shopping below are you details of the order you have recently placed. If you have any questions please contact us</p> <br /> </a></p> <tr><td></td></tr></table> <table width='980' border='1' cellspacing='0' cellpadding='10'> <tr valign='top'> <td bgcolor='#E9E9E9' class='header1'>Customer Name</td> <td class='text'>".$row_rsOrders['FirstName']."</td> <td bgcolor='#E9E9E9' class='header1'>Order ID</td> <td bgcolor='#E9E9E9' class='text'>".$row_rsOrders['OrderID']."</td> <td bgcolor='#E9E9E9' class='header1'>Order Status</td> <td class='text'>".$row_rsOrders['TransactResult']."</td> </tr> <tr valign='top'> <td bgcolor='#E9E9E9' class='header1'>Email</td> <td class='text'>".$row_rsOrders['Email']."</td> <td bgcolor='#E9E9E9' class='header1'> </td> <td class='text'> </td> <td bgcolor='#E9E9E9' ><span class='header1'>Order Date</span></td> <td class='text'>".$row_rsOrders['OrderDate']."</td> </tr> <tr valign='top'> <td bgcolor='#E9E9E9' class='header1'>Shipping Address</td> <td class='text'><p>".$row_rsOrders['Address']."</p> <p>".$row_rsOrders['Town']."</p> <p>".$row_rsOrders['PostCode']."</p> <p>".$row_rsOrders['Country']."</p> <p> </p></td> <td> </td> <td> </td> <td colspan='2' align='right' valign='bottom'><span class='header'> ORDER TOTAL:".$row_rsOrders['Total']."<br /> </span><span class='text'>Shipping:".$row_rsOrders['Shipping']."</span><span class='header'><br /> </span></td> </tr> <tr valign='top'> <td bgcolor='#E9E9E9' class='header1'>Product ID</td> <td bgcolor='#E9E9E9' class='header1'>Product Description</td> <td bgcolor='#E9E9E9' colspan='2' class='header1'>Size</td> <td bgcolor='#E9E9E9' ><span class='header1'>Quantity</span></td> <td bgcolor='#E9E9E9' align='right'><span class='header1'>Price</span></td> </tr>"; ?> <?php do { ?> <?php $message .=" <tr valign='top'> <td class='text'>".$row_rsOrders['ProductID']."</td> <td class='text'>".$row_rsOrders['Product']."</td> <td colspan='2' class='text'>".$row_rsOrders['UnitSize']."</td> <td><span class='text'>".$row_rsOrders['Quantity']."</span></td> <td align='right' class='text'>".$row_rsOrders['UnitPrice']."</td> </tr>"; ?> <?php } while ($row_rsOrders = mysql_fetch_assoc($rsOrders)); ?> <?php $message .=" </body> </html>"; // Always set content-type when sending HTML email $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= 'From: company name <email@domain.com>' . "\r\n"; $send = mail($to, $subject, $message, $headers); mysql_free_result($rsOrders); ?>

osgood_ · ‎Apr 22, 2013

pziecina wrote: Hi Yes, they were convenient, but I don't think Dw had any choice but to drop them completely. Especially when one considers that the old sever behaviour code and either of the 'newer' methods could not be used together on the same page, can you imagine the confusion and problems users would have had if Dw had just updated the server behaviours. So maybe dropping them completely was not such a bad idea. The next few years will be interesting though, as 'old' Dw extensions, (shopping carts, etc.) cannot be used one the same page by anyone who is updating their skills to use the new MySQLi or PDO way of doing things. As for an extension that uses the new methods, I believe that most Dw extension developers are planning to update their extensions, (probably at a cost to the user!!!) but again they may be incompatible with the users preferred 'new' way of coding, (MySQLi or PDO). Then comes the problem with CMS's. Wordpress uses the old php extension, but Drupal uses PDO, (Joomla uses its own PDO database abstraction layer) so even these will have compatibility problems for users. As they say, "We live in interesting times", and if we thought it was just html, css, javascript and browsers that were giving us incompatibility problems, now we can add PHP and Databases to the list. PZ Everything you say is so true, it's going to get very messy unless there is a u-turn. I'm going with the improved mysqli for the moment as it seems quite quick to grasp. I don't use third party CMS or Cart extentions, I write my own. I have a simple cart that I can easily switch to sqli from now on. Over the weekend I replicated all the most popular DW Server Behaviours using mysqli which was quite simple. Not used them yet in any 'live' project but will from now on. I dare say I'll come across something that will hold me up for a time while I go through the process of trial and error. Whilst extentions are a great and convenient way to lay down something fast looks as if they might come back to bite you big time. I really do not like reyling on anything I don't know because as I've said in the past and I think you echo my thoughts as well, if something changes it's out of my control to put it right. Os

osgood_ · ‎Apr 22, 2013

Ok well I got my do-while loop to work, it now sends all the products in the email BUT I am only using one table. However I cant see that as an issue because you say that the first product is coming through for you so the others should. Mine was a stupid typing error that was stopping it from working.

osgood_ · ‎Apr 22, 2013

Jonathan Fortis wrote: so are you saying it cant be done without a load more coding? No not saying that. I just don't know if its a simple fix we are not seeing or whether the information needs to be put into an array and fetched from that or how the do-while loop can work because it needs to be part of the 'message'. But breaking the 'message' so the php can do its job seems to render the information as not part of the 'message' so it won't send. I'm sure this will be so simple for anyone who has a good understanding. At the moment I can't get my head around how to achieve it. It would be nic eto know though for future reference as I'm sure it will come in handy.

osgood_ · ‎Apr 22, 2013

rjjacob wrote: Since I wrote this post I concluded that there is no substitute for understanding and have started my re-education by delving further into the issue with updated PHP/MySQL books and tutorials so I can prepare for a Dreamweaver without this functionality. Yes, I too have concluded that is the way to go as well. There really is no substitute for learning as much as you can. Whilst the DW Server Behaviours were very convenient they have not kept pace, Adobe prefering to spent their time on less important updates in my opinion. The Server Behaviours are what makes Dreamweaver the tool of choice for database integration for those who lack the knowledge. I feel the Adobe team will regret not coming up with an alternative. Anything that detracts from making the program what it is is a step in the wrong direction and for sure this is a big step in the wrong direction. rjjacob wrote: I have mainly used DW server behaviors in my development projects that's why I am curious about what others are doing to make the change. I'm surprised there haven't been more posts; perhaps I'm the last one to be taking action about this, or maybe no one is too worried about it yet. I think a lot have changed their working practice but many more are burying their heads in the sand. sql_ support is a way off from being completely dropped yet. rjjacob wrote: Anyway, your assessment of how terrible the server behaviors are is correct. I'm finding that true after barely breaking the binding on a few books about the greater subject and looking into mysqli and PDO. Yes, because I relied heavily on them I did not know how bad they were until I forced myself to look further afield. What you can do in a couple of lines of code the DW Server Behaviors produced quadruple or more to achieve the same. rjjacob wrote: But they sure were convenient! Yes, I agree. Maybe some extention developer will come up with a set of new improved behaviours. I tell you if they do they will make a shed load of money.

osgood_ · ‎Apr 22, 2013

Jonathan Fortis wrote: >>Does the way you have it actually work anyway? What I mean is when you test the email does any information come through using the set up below: the way i had it working was everything was coming through but only the 1st record of the order Oh ok, it didn't work for me until I changed to the variables. You must have something different in your code which renders the way you have set it up just fine. I've been trying to think of a way to loop through the records in a legitimate way. I'm pretty much sure you can't have the loop within the 'message' itself without breaking out of it to allow the php to work.

osgood_ · ‎Apr 22, 2013

Does the way you have it actually work anyway? What I mean is when you test the email does any information come through using the set up below: <td class='text'>".$row_rsOrder['ProductID']."</td> I thought that you needed to create a variable first like: $ProductID = $row_rsOrder['ProductID']; <td class='text'>".$ProductID."</td> The way you have set it up you would surely need to use echo to append the information to the <td></td> cell? echo $row_rsOrder['ProductID'] But you can't do that because that would be using a php block within a block.

osgood_ · ‎Apr 22, 2013

hummmm ...... are OrderID and ProductID in the same table ?

osgood_ · ‎Apr 22, 2013

Jonathan Fortis wrote: that makes sense. but that is showing an error, Undefined variable: message in E:\Domains\b\website\user\htdocs\admin\order-details-sent.php on line 135 <td class='text'>".$row_rsOrder['ProductID']."</td> i replaced the " with ' at the start and end as this was error prompting could this be that is still causing errors <?php do { ?> <?php $message = .' <tr valign='top'> <td class='text'>".$row_rsOrder['ProductID']."</td> <td class='text'>".$row_rsOrder['Product'].','.$row_rsOrder['catname']."< /td> <td colspan='2' class='text'>".$row_rsOrder['UnitSize']."</td> <td><span class='text'>".$row_rsOrder['Quantity']."</span></td> <td align='right' class='text'>". DoFormatCurrency($row_rsOrder['UnitPrice'], 2, ',', '.', '£ ', '')."</td> </tr>'; ?> <?php } while ($row_rsOrder = mysql_fetch_assoc($rsOrder)); ?> I'm not sure. I did notice you have not escaped the second " alt=\"" in the image below which will cause the code to choke. <img src=\"http://www.website.com/images/logoBLPP.jpg\" alt=\"" />

osgood_ · ‎Apr 22, 2013

Jonathan Fortis wrote: i have a php MySQL database that stores individual bills paid, i need to show the full amount of the column that stores the individual payments what i have so far Not read all the thread but you want the total of all the individual bills that are stored in a column in your database? If so just creat a simple query like below replacing colName with the name of your column for the individual bills information and tableName with the table that the information is stored in. $query = "SELECT SUM(colName) FROM tableName"; $result = mysql_query($query) or die(mysql_error()); Then just echo it out: (replace colName with the name you used in the query above) <?php while($row = mysql_fetch_array($result)){ echo $row['SUM(colName)']; } ?>

osgood_ · ‎Apr 22, 2013

A possible reason: The do - while loop is probably not working because you have to break out of the php and back into it again. i.e, break the $message into sections and stitch it together again $message .= " <?php do { ?> <?php $message = ." <tr valign='top'> <td class='text'>".$row_rsOrder['ProductID']."</td> <td class='text'>".$row_rsOrder['Product'].','.$row_rsOrder['catname']."< /td> <td colspan='2' class='text'>".$row_rsOrder['UnitSize']."</td> <td><span class='text'>".$row_rsOrder['Quantity']."</span></td> <td align='right' class='text'>". DoFormatCurrency($row_rsOrder['UnitPrice'], 2, ',', '.', '£ ', '')."</td> </tr>"; ?> <?php } while ($row_rsOrder = mysql_fetch_assoc($rsOrder)); ?> You can't have a block of php code which the do-while loop is within another block of php code which the $message is. You have to break out of the php to alllow the do-while loop to work and then go back into php to complete the message. Have you tried that?

osgood_ · ‎Apr 22, 2013

I've just started to look at mysqli - the replacement for sql_ The below url covers all the basics like Insert, Update and Delete, plus a few more. http://www.pontikis.net/blog/how-to-use-php-improved-mysqli-extension-and-why-you-should I've been using the DW server behaviours for a number of years because of their ease of use and convenience. However when you start to look deeper you realise just how overly complex and outdated they really are. I don't know what you do but if you mainly use DW server behaviours then it's not going to be such a big step to learn the 'improved' sqli It took me a weekend to get to grips with how to implement them to replace the most popular DW server behaviours - Insert, Delete, Update, Repeat Region, Show Region, User Login-Logout, etc Getting to grips with how to connect, write a query and fetch information, instead of letting DW do it, certainly has enlightened me in terms of how terrible the server behaviours in DW are.

osgood_ · ‎Mar 05, 2013

porterWeb wrote: I know this is an old post, but still exactly what i wanted. I have followed instructions and can see all my images, but I need it to be the background image of a div, so other divs or content ie a menu could be on top. can this be combined with css?? thank you for any help at all. I don't think this particular solution provides for background images which are a slideshow BUT if you Google for something like 'background images to <div> as slideshow using jQuery' you will probably find something. I found something a while back but I didn't do enough testing to see what the results were. Might be as well to start a fresh thread asking for what it is you want as your post is getting buried in an old thread.

osgood_ · ‎Feb 19, 2013

DevilUrd wrote: One last question.. If i do determine that, let's say, leftdiv height is 60% (and also set overflow to auto) will whatever content i put there never go past those 60%? Or will it continue to occupy until i add things? I don't know as I never use heights, so it's not a situation I've ever come across or likely to experience. You'll have to experiment but remember other users won't necessarily see what you're seeing. They have their browsers set up differently that's why you shouldn't try to nail everything down. Sure you can set heights but if the content is more than the height of the container (this can happen if someone zooms the text of the page) you have to allow for the content to scroll should it exceed the height of the conatiner. If you set the height on many containers then you potentially have a lot of scroll bars OR if you don't allow for scrolling risk the content disappearing as it vanishes when the height of the container is breached.

osgood_ · ‎Feb 19, 2013

DevilUrd wrote: Does that mean that the content must be in % too? I'm very confused now... What i wanted in the test page above is that those divs would fit the whole screen in height as well. Forget height when designing for the web. The web is not a fixed depth area like DTP. The content determines the height. The less content the less the height is. The more content the more the height will make. Unless you know specifically what the height of your content will be from page to page how can the content ever fit the height exactly without the necessity to scroll. To make those <divs> stretch the whole depth of the screen can probably be achieved with some javascipt if you search Google but quite frankly its not worth the effort.

osgood_ · ‎Feb 19, 2013

Hi Peran, I don't know much about the 'Fluid Grid' in Dreamweaver apart its target audience is desktop, tablet and mobiles. It works by setting media query breaks at specific widths and the website design morphs into something else to fit the screeen width when an alternative media query is evoked. This is not what the original OP was asking. As I read it they have a site which they want to fit the browser width on all desktops. This is achieved by setting containers at percentage width rather than fixed width. I guess you could use media queries to target just desktops but you would need to use more media queries at the higher end range.

osgood_ · ‎Feb 19, 2013

DevilUrd wrote: Well, by removing all the height values, virtually nothing happened (besides the content being dragged to the left side of the screen). In higher resolution it did not enlarged to fit the screen and in lower resolution it did not squeezed to fit it either. What I supplied is a bare bones basic structure which fits all resolution screens as an example - how you are applying it I don't know. Removing any height would not result in anything being dragged anywhere.

osgood_ · ‎Feb 18, 2013

DevilUrd wrote: Thanks for your reply! My main problem atm is dealing with the height, since the width was already ok. And you set % values for width, but determined fixed values for height. If i don't put any value on height, and only fix width based on percentages, it's not working.. Or did i understood it wrong? Height is ALWAYS determined by the content, that's why you should never specify a fixed height for a container unless it contains a fixed height element such as an image, video or an iframe, etc What's not working if you remove the height values?

osgood_ · ‎Feb 18, 2013

flexible, fluid, call it what you want throws up yet another set of probelms. Below is your main <div> structure set to accommodate the width of any browser viewport. I've coloured the <divs> with vivid colors so you can see what is going on...........and then there is 'responsive' layouts which ups the game even further. I'd also forget setting the height value of the <div> as the content will make its own height. You can set a min-height but if the content makes more than the set minimum height it will just push the <div> taller. If you set a specific height and the content makes more it will be truncated (out of view) <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Untitled Document</title> <style> #wrapper { height: 850px; width: 100%; margin-right: auto; margin-left: auto; background-repeat: no-repeat; background-position: center center; background-image: url(../Images/bgdr660.jpg); } #header { background-repeat: no-repeat; clear: none; float: none; height: 203px; background-image: none; background-color:#F90; } #sprymenu { height: 26px; color: #000; text-align: left; font-family: Calibri; font-size: 70%; vertical-align: middle; background-color:#69F; } #leftDiv { clear: none; float: left; height: 360px; width: 20%; text-decoration: none; background-color:#0CC; } #rightDiv { float: left; height: 420px; background-color:#F96; width: 80%; } #footer { height: 60px; clear: both; position: relative; padding-bottom: 20px; background-color:#9F0; }</style> </head> <body> <div id="wrapper"> <div id="header">header</div> <div id="sprymenu">Spry Menu</div> <div id="leftDiv">Left Div</div> <div id="rightDiv">Right Div</div> <div id="footer">Footer</div> </div> </body> </html>

osgood_

osgood_

Activity

Re: Dreamweaver CC and PHP / MySql

Re: Dreamweaver CC Crashes Constantly

Re: Why can't I work with ColdFusion documents?

Re: automating connection string to mysql?

Re: Displaying results of a prepared statement

Re: Displaying results of a prepared statement

Re: how to get the total of a column in php

Re: how to get the total of a column in php

Re: how to get the total of a column in php

Re: email php function repeat region not working

Re: email php function repeat region not working

Re: email php function repeat region not working

Re: Where to go next with Dreamweaver and server-s...

Re: email php function repeat region not working

Re: email php function repeat region not working

Re: Where to go next with Dreamweaver and server-s...

Re: email php function repeat region not working

Re: email php function repeat region not working

Re: email php function repeat region not working

Re: email php function repeat region not working

Re: how to get the total of a column in php

Re: email php function repeat region not working

Re: Where to go next with Dreamweaver and server-s...

Re: HOW do I create a SIMPLE fading slideshow in d...

Re: Make website fit all screen resolutions

Re: Make website fit all screen resolutions

Re: Make website fit all screen resolutions

Re: Make website fit all screen resolutions

Re: Make website fit all screen resolutions

Re: Make website fit all screen resolutions