Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
Join author David Gassner as he describes how to add dynamic data to a PHP-enabled web site in Adobe Dreamweaver. This intermediate course shows how to plan and create a MySQL database, define a PHP-enabled site in Dreamweaver, connect the site to the database, and manage and present dynamic data. David also explores Dreamweaver features such as PHP custom class introspection and site-specific code hinting as well as the differences between the CS5 and CS6 versions of the software.
This course was updated on 6/12/2012.
When you generate a script from phpMyAdmin, it can be executed either in another copy of phpMyAdmin or in any other user interface for MySQL. In most cases, if you're working with an Internet Service Provider, you'll have a copy of phpMyAdmin that you can use. If you're working with an independent copy of MySQL, you can download a copy of the MySQL user interface tools from the MySQL web site. The script should work in that software as well. Before you run the script on your remote server, go into the script and make any changes you need.
For example, I'm going to change the name of my database from explorecalifornia, the local name, to exploreremote. Changing this comment doesn't have any actual effect on the database itself. You'll still create the database manually in phpMyAdmin, but then you'll run the script in phpMyAdmin against the new database. I'll save the changes and close the text editor, and then I'll go to phpMyAdmin.
Within phpMyAdmin, I'll create a new database, and I'll name it exploreremote. I'll click Create, and then I'll click the Import button, and I'll navigate to the location of MySQL file, which I've placed in the exercise files area, under the chapter for this folder, 09_deployremote. And then the name of the file is explorecalifornia.sql. I'll select the file and click Go. My new database now has the structure and wherever I've left the insert statements in the actual data.
For example, the admin table still has the same username and password in its one and only record, but the explorers table is empty - that is, there is no data in it, because in the SQL file, I removed all the insert statements. So, whether you move data in addition to the structure is completely up to you. For some tables, you might want to include them in the script, and for others, you might want to use a completely fresh copy of the table. So you've reproduced your database, structure, and data on the remote site, and now you're ready to work with it from your remote web site, and I'll show you how to configure your connections file to do that in another video.
Find answers to the most frequently asked questions about Dreamweaver with PHP and MySQL.
Here are the FAQs that matched your search "":
<?php include('../ZendFramework/library/Zend/Date.php'); ?
<?php echo $_SERVER['DOCUMENT_ROOT']; ?
You can then programmatically modify the include_path variable at runtime with the set_include_path() function. For example, if your physical root folder is /home/myroot, the code might look like this:
<?phpset_include_path('.' . PATH_SEPARATOR .'/home/myroot/ZendFramework/library/Zend');include('Date.php');?
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.