Dreamweaver troubles: Difference between revisions
Created page with 'Here I'll list some problems I've had with Dreamweaver and my solutions, when found. Keep in mind I use Mac versions. ===No table found=== I was working on a database-driven PHP…' |
PHP mysql routines |
||
| Line 5: | Line 5: | ||
I tried several troubleshooting methods, including restarting DW, restarting the computer, deleting the preferences files, deleting the Application Support folder, deleting go-between scripts on the server, and updating the scripts to match the new addresses Network Solutions assigned my databases without telling me. That last one I thought would be it. Nope, although I think it must have been *part* of the problem. While attempting to change site settings, I got a message that the test server was not responding, so I turned on Web Sharing on my Mac, which is the assigned Test Server for my site, and that fixed the problem, probably along with the MySQL server IP address update. DW, although it shouldn't have to, uses the Test Server for all sorts of behind-the-scenes actions, so you might find this hint useful:Keep the Test Server well oiled. | I tried several troubleshooting methods, including restarting DW, restarting the computer, deleting the preferences files, deleting the Application Support folder, deleting go-between scripts on the server, and updating the scripts to match the new addresses Network Solutions assigned my databases without telling me. That last one I thought would be it. Nope, although I think it must have been *part* of the problem. While attempting to change site settings, I got a message that the test server was not responding, so I turned on Web Sharing on my Mac, which is the assigned Test Server for my site, and that fixed the problem, probably along with the MySQL server IP address update. DW, although it shouldn't have to, uses the Test Server for all sorts of behind-the-scenes actions, so you might find this hint useful:Keep the Test Server well oiled. | ||
===Stale PHP/MySQL routines=== | |||
Adobe hasn't changed the way Dreamweaver handles PHP/MySQL connections and queries much since version CS3. According to one notable author, writing in the spring of 2012, CS6 does not use better PHP libraries, like mysqli, for connections, and the routines for recordsets and dynamic texts and actions are the same as ever. Search for mysql on this page: http://foundationphp.com/blog/2012/04/23/my-verdict-on-dreamweaver-cs6/ | |||
However, all the behaviors can be edited by users, since Dreamweaver uses html, javascript, and their markup language edml to tell DW how to interpret dynamic page routines. In the Dreamweaver application package folder you can find those routines and replace PHP's mysql functions with mysqli functions, for example changing mysql_num_rows to mysqli_num_rows. You'd have to change all the functions at once, since a single connection can be only mysql or mysqli, and would require all functions to match the connection. Changing might be as simple as replacing all instances of ''mysql_'' with ''mysqli_''. | |||
[[Category:Computers]] | [[Category:Computers]] | ||
Revision as of 09:04, 31 May 2012
Here I'll list some problems I've had with Dreamweaver and my solutions, when found. Keep in mind I use Mac versions.
No table found
I was working on a database-driven PHP/MySQL page. At first I could work normally, but after a certain hour I couldn't access any tables from any database in Dreamweaver CS5.
I tried several troubleshooting methods, including restarting DW, restarting the computer, deleting the preferences files, deleting the Application Support folder, deleting go-between scripts on the server, and updating the scripts to match the new addresses Network Solutions assigned my databases without telling me. That last one I thought would be it. Nope, although I think it must have been *part* of the problem. While attempting to change site settings, I got a message that the test server was not responding, so I turned on Web Sharing on my Mac, which is the assigned Test Server for my site, and that fixed the problem, probably along with the MySQL server IP address update. DW, although it shouldn't have to, uses the Test Server for all sorts of behind-the-scenes actions, so you might find this hint useful:Keep the Test Server well oiled.
Stale PHP/MySQL routines
Adobe hasn't changed the way Dreamweaver handles PHP/MySQL connections and queries much since version CS3. According to one notable author, writing in the spring of 2012, CS6 does not use better PHP libraries, like mysqli, for connections, and the routines for recordsets and dynamic texts and actions are the same as ever. Search for mysql on this page: http://foundationphp.com/blog/2012/04/23/my-verdict-on-dreamweaver-cs6/
However, all the behaviors can be edited by users, since Dreamweaver uses html, javascript, and their markup language edml to tell DW how to interpret dynamic page routines. In the Dreamweaver application package folder you can find those routines and replace PHP's mysql functions with mysqli functions, for example changing mysql_num_rows to mysqli_num_rows. You'd have to change all the functions at once, since a single connection can be only mysql or mysqli, and would require all functions to match the connection. Changing might be as simple as replacing all instances of mysql_ with mysqli_.
