 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / Flash / Data Integration / December 2007Installing PHP and mySQL for Flash
Which versions PHP and mySQL do I install to test Flash Data Integration? 1. This is my first PHP/mySQL project and also the first one using Flash 8 Pro. 2.I've investigated the mySQL and PHP web sites and they appear to be server based installs. 3. What and/or how do you install mySQL and PHP on the local Windows XP Pro PC so that I can develop and test the Flash data integration, especially since I am not connected to a network when I am authoring content. (My UNIX hosting server does have mySQL and PHP installed though.) Thanks You ought to install: Apache server 2.2 or newer on your computer. After instalation you have local server on your computer and you needn't to use remote server or Internet. Any PHP version Any mySQL version - in this order All three are free (open source) It is necessary to do some changes in configuration files of these programms. It is not complicated but need several pages of text to explain. Try to buy or find in local library book: David Powers. Foundation PHP5 for Flash (2005 edition). It is old but have the best explanation how to install Apache, PHP5 and MySQL and how to configure them to cooperation. The configuration is still he same and will work with Flash CS3. Later, Dreamweaver is the best to manage PHP5, MySQL and Flash files, however it is possible to work without it. Sorry for my English but I am not from English language country :-) Hi You can do what 'istis' suggested -but this seems a harder option. Alternatively, who can google 'LAMP' Linux - Apache - MySql - Php/Perl/Python, there many free ones to download and install Installation is relatively simple and usually comes with plenty of instructions - once installed and setup you can then use localhost as your development location. Hope it helps (see my post above - I am using Windows XP Pro SP1 - not Linux) Do I still install Apache Server 2.2 on the Win XP machine for offline development work? 1. I went to download.com and searched for WAMP and installed http://www.download.com/Web-Developer-Server-Suite/3000-2165_4-10618742.html?tag =lst-0-2 after installing Service Pack 2 as the Apache documentation for Windows said that it needs SP2 for Apache version 2.2 The Web developer suite automatically installed Apache 2.2, PHP 5.0 and mySQL 5. 2. I created an exception in the Windows Firewall titled "Apache" for port 80. 3. Apache WON'T START and gives me error 01 - I can't figure out what's going on. 4. PHP is installed but as WON'T START. 5. mySQL started automatically. 6. I'm reviewing Apache's website but am quite confused about what to do. Hi Seems you have an old copy of Wed Developer Server Suite and you definitely need Windows SP2 for this. Go http://sourceforge.net/projects/webdeveloper/ and get the latest copy of W.D.S.Suite. Its pre-configured for Windows and automatically installs and starts everything you need for localhost development. You will have un-install the previous version, run a Registry Cleaner if you have one, then re-install new version. If all goes well then you can use C:\www as your web root folder. Hope it helps 1. I must thank everyone on this forum for responding. This is trully driving me insane! 2. I have "David Powers. Foundation PHP5 for Flash (2005 edition)" on the way from amazon 3. I followed the procedure and reinstalled Web Developer suite v2.00. I had v1.93. 4. Of the 3 registry cleaners that I downloaded for "free", the all scan for free, but you have to pay to register the product to fix the problems that it finds. Any suggestions for a real free one (AVG Virus Scanner is trully free and great!) 5. I discovered that Apache wouldn't run when IIS was running and gave me error(1). However when IIS is stopped , Apache 2.2, php5, and mySQL 5 are ALL RUNNING according to the Web Developer suite v2.00 console. I put the flashsql_v31.php file in the c:\\www directory as per the instructions of Netdrims and pointed to this path with the Component Inspector and I am still getting the same error. (see my other post) Error opening URL "file://c:\www.flashsql_v31.php?typ=&id=210" I get a different id number everytime I test the sample flash file that came with the component. Any advice? I still haven't gotten a response from Netdrims tech support and would really like to get this thing to work. Thanks OK - your making progress and have a running Web.Dev Suite So that you can develop locally its best to create a folder in your C:\www - any name you want ie: 'flashdevfolder' Place all your html, php, swf's and associated images inside this folder and run it from localhost. Using c:\\localhost\flashdevfolder\target.html or c:\\localhost\flashdevfolder\target.php Substitute these 'target.html' and .target.php' for the actual name of your file. Hope it helps I must thank you again for your consideration in helping me out. "Place all your html, php, swf's and associated images inside this folder and run it from localhost. Using c:\\localhost\flashdevfolder\target.html or c:\\localhost\flashdevfolder\target.php" 1. In order to represent Netdrims properly, I just got an email that I received a 50% refund on the product because I am an academic as per their word they said that they would because I paid full price before learning there was a discount -- however, I still didn't a tech support response (from the same person as who sent the refund - must be a 1 man shop) 2. What does "run from it from localhost" mean? You mean the offline computer that I am developing on? 3. Are you saying that: a) create a c:\www\flashdev folder b) copy the flashsql_v31.php file into the c:\www\flashdev folder? c) rename the flashsql_v31.php file as target.php d) In the SQL component from Netdrims, use the Component Inspector window which points to the flashsql_v31.php file (now target.php) for the filepath write: c:\localhost\flashdev\target.php INSTEAD OF c:\www\flashdev\target.php e) What is the rationale behind doing this (hopefully the David Powers book will explain this)? This is my first time doing this Thanks. BTW - do you know how I change my screen name from MYSCREENNAMEISUNAVAILABLE - there's nothing in the Profile on the Adobe Forum about and I feel like a dork without a screen name like everyone else on the forum. Hi Point 2. localhost is run through a web browser open IE and type c:\\localhost\flashdev\target c:\\localhost points to 127.0.0.1 which equal to entering c:\\www. 3a. yes 3b. yes 3c. No you can leave it as it is - it maybe that this is referenced somewhere inside the flash extension. d. If that is what is needed then do it. Is this extension Flash based or PHP/SQL Based? Dear Mr. FeldKircher: I looked at your blog and saw that you need more space. Perhaps you'd like to consider where I've chosen to host my website on http://www.aplus.net/ someone at my school recommended it and it's cheap, large, and has excellent 24/7 tech support. I have shared UNIX server space of ~170G for ~$120/yr. You can also be hosted on a Windows system but I chose UNIX for the php/mysql development that you're helping me with. I have no problem with bandwidth in using Flash encoded videos via progressive download at native DV resolution 720x480. You can see some of my work if you wish including the project that I did last year for my school. http://www.4themax.com (splash page and flash ads) http://www.4themax.com/home_flash.html (flash home page) http://www.4themax.com/education/di/DI.html (education page) Note: the site is still under construction Thanks again for your help - I'm digesting and working on your last response. Hi I finally found some info relating to your extension - I wouldn't expect too much support from the developer(s) has they've been taken over by another team. Netdrims no longer exists and has been consumed by Flexcubed.com. Unfortunately Flexcubed.com only has a 'in development' homepage - really helpful. I did find a small summary on Actionscript.org - but no config details - will continue to look. So I now know what it should do - but not how......! Thanx for the tip - I'll have a look at www.aplus.net 1. the FlashSQL component that I'm trying to use is a component used in the Flash 8 authoring environment, not in PHP, as you asked. 2. I did as you said, and had Flash publish and HTML and SWF file, after setting up the filepath and datasourcepaths in either the Component Inspector and as an actionscript (using the statements supplied in the help file) 3. I browsed the HTML file with IE INSTEAD OF using "Test" within the Flash Environment. 4. I DIDN'T get a couldn't find flashsql_v31.php file error as before, BUT unfortunately, the SWF kept saying "Loading Data" and nothing came up in the DataGrid. 5. Considering that this company is either defunct or not supporting their product, I am almost considering asking you if I could email you the file and have you get it to work on your WAMP machine so that I could proceed. 6. I have a really timely project for my school in which I am developing a NY State Regents testing web app which will greatly help the students graduate. 7. Yes Coker Isaac of Netdrims has been the only one whom I've received emails albeit some come back undeliverable. 8. I received the David Powers book today on 2nd day Amazon instead of tomorrow and perhaps it'll also have some insight; however, I don't think that he SPECIFICALLY will address how to use this FlashSQL component that I bought on Adobe Exchange from Netdrims which I thought was my easy, elegant solution for my Flash-SQL interface. Thanks for your support. Let me know if you want me to send you the Netdrim FlashSQL file. Hi Yeah send me the file to thefeldkircher@hotmail.com two heads are better than one they say. And any documentation that came with it. 'Loading Data' is a major step forward, now we just need find which one is not talking. This maybe a silly question but you do have an SQL Database configured and filled with data? Is there any login verification needed between the Database and the FlashSql extension? I will have a look at it and let you know as soon as I find something. 1. Web Developer suite console shows BOTH Apache and IIS running now. with mySQL and PHP extensions. 2. I followed the instructions above using either: c:\localhost\flashdev\target.php OR c:\www\flashdev\target.php 3. I also put the MSaccess flashsql.mdb file, sqlsample.fla file in the c:\www\flashdev folder along with target.php in the same file. but to no avail - I'm still getting: Error opening URL "file://c:\www\flashdev\target.php?typ=&id=SOME NUMBER" Arggh! thanks should read "along with target in the same folder" (a copy of my email to netdrims is as follows:) Dear Coker Isaac (netdrims.com tech support - if netdrims is still in business) Thank you for your refund. I am really, really, not trying to be difficult but I am way confused --- your http://www.netdrims.com website is now replaced with a lovely lass selling all kinds of car parts or webcams or insurance or debt consolidation , etc.. While she's beautiful, I really, really want to be able to use your FlashSql component. and flexcubed.com (some affiliate company of yours) is just a picture of a mouse for a PC. I've searched on actionscript.org about your product without a clue. You've put so much wonderful effort into FlashSQL and I am very confused about setting up the filepath/filesource. It appears that I can't proceed without your help despite the generous help of these adobe forum good people. With the absence/change of your various websites from Flash components to cars and lack of email response - it's become really rather frustrating in proceeding. I recognize that your products have been/are free to inexpensive, but I purchased it with the intention of solving mySQL problem. But on the otherhand, since you are offering these components for sale on adobe.com/exchange with a listing of techsupport, I would suppose that someone could get the support they need to be up and running. In this regard, I very nicely collated your help file into MS Word, Pdf, and Flashpaper versions much more suitable for printing into a paper manual and uploaded them to you so that you could provide them to future users so there would be less need for anyone to contact you in the future. Once this first-time use issue is resolved, I similarly intend to send you a readme file that you could distribute along with your product so others needn't go through similar frustration and you could have more peace of mind in not having many people contact you. I've installed Apache,PHP,mySQL under Win XP SP2 with IIs. I just want to be able to get thing working so I can move on using your manual and samples. Please review my posts under "MYSCREENNAMEISUNAVAILABLE" http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid=15&catid=294 &entercat=y This is your man.... http://www.freecfmxhosting.com/developers/view_details.cfm?developer_id=349 Hi Ok!.. This is what I have so far.. 1.. I copied all the files you sent to a Netdrims folder on my Hard drive 2.. I placed flashsql_v31.php and flashsql.mdb to C:\www\flashsql 3.. I opened flashsql.fla and check the settings for the flashsql.mxp 4.. Ran the flashsql.fla in the Flash IDE and clicked 'Load Data' - Output Panel - Connection Error Unknown Database. 5.. Made a few changes but to no avail. 6.. Pointed the flashsql.mxp to an existing Database I have setup in MySQL -(Not .mdb) made the necessary changes to the Actionscript and voila - data arrived. So I can get it to talk to and receive from an mySQL database but not the flashsql.mdb I think this has to do with the localhost connection, because we need a localhost to run php and we have to login in to it. It thinks were looking for a mySQL Database. Will continue until I break it......................... Hi So far everything points to using IIS, MDAC and ODBC with the flashsql.mxp extension when pointed to an .mdb Using webroot of your installed IIS, not the webroot of Web Developer Server Suite. Most of this comes pre-installed with Windows Pro, although you may need to update your MDAC definitions from the Microsoft website. Once installed you can then setup your .mdb as a ODBC source using the ODBC Administrator in Control Panel. Help and Support will show you how to set this up. One thing that concerns me about this extension is that whenever you need to change your Queries then you have to open the .fla every time and modifiy the appropriate code and re-publish a swf. Not very dynamic - or did I miss something......! I will continue for a while longer, but I dont have an IIS service on my machine. 1. I followed Apache's instructions and installed both SP2 and IIS before installing Apache 2.2 2. I had BOTH IIS and Apache running as shown in the Web Developer Suite Console (WDSC) 3. When I browsed http://localhost/, the IIS (Windows Pro logo) page comes up from the Inetpub folder. 4. When I stopped the IIS service and changed startup to manual in WDSC and then Rclicked properties for IIS and changed startup to demand, rebooted, then when I browsed http://localhost/, the directory of the apache install comes up, but not a webpage, "Test for Apache Installation" as shown in David Powers' book, PHP Solutions:Dynamic Web Pages Made Easy 5. I NEED VERIFICATION OF THIS, BUT IT APPEARS THAT THE PROBLEM IS THAT I HAVE BOTH IIS AND APACHE running at the same time and the rootweb of the localhost is not the c:\www of Apache but the Inetpub of IIS 6. According to David Powers' book, p. 22, PHP can run on IIS and he DOESN'T install Apache on a development machine if IIS is already running. 7. What do you recommend? Do I uninstall, Apache, mySQL, PHP and IIS and then reinstall Apache, mySQL, PHP manually following David Powers' configuration parameters? (David Powers ONLY recommends manual configuration because he says the automatic install of Web Development Suite and others is not completely configured correctly.) I would assume then that my webroot would only be c:\www for Apache. Perhaps this component and/or Windows is getting confused by having both webservers IIS and Apache installed -- and therefore the paths to the webroot that the component is using when browsed in IE at the c:\www\flashdev folder containing the database and published HTML/SWF file pair. Thanks Hi Basically you have one of two choices If you intend to use an .mdb then you have to use IIS (this would mean a Windows Hosting Package when you go live). If you intend to use mysql then you would use WDSS. To test your mxp locally then you have to switch of Apache and MySql. On your desktop you should have a WDSS Controller. Double click this - Select Apache and click Stop Service do the same with MySQL. Now you can follow the instructions in your book to setup IIS locally to use your .mdb Remember when you restart your machine Apache and MySQL will restart. Please let me know what happens. The BOTTOM LINE IS: Do I install Apache or IIS or both? (to use with PHP and mySQL) Some of the best advice that I had above was to buy the David Powers books. I unistalled IIS, Apache, PHP, mySQL and reinstalled only Apache with PHP, mySQL, and phpMyAdmin using the manual instructions in PHP: Dynamic Web Pages. I installed EXACTLY the same versions as in his book and followed his instructions exactly. I'm NOT running IIS anymore, just Apache 2.2 my new localhost root is CL/htdocs which David Powers says to create I made a new subfolder C:/htdocs/webdev where I placed all of the files from netdrims that I uploaded to you. When I hit load data, the headers of the file appear in the data grid, but no records (Coker, Isaac, male, 27) nor if I enter data below and submit, does it appear when reloaded. Hi So if understand correctly you now have a connection to the .mdb just no data being returned? Have you made any changes to the path or the login? Hi I tried again to connect to the .mdb using ODBC and DNS - but it still doesn't work. I followed all the instructions in the help/config .pdf you sent me - still doesn't work. When I connected to a MySQL Database then it functions. I will send you instructions how to create a SQL Database via Email. try looking here: http://flashden.net?ref=luke THREADS OF A PRIVATE EMAIL WHEN I FINALLY, THANK G-D, GET THIS TO WORK WITH THE THEFELDKIRCHER'S HELP: > 1. I would like to thank you for your time and patience until I finally > "get it." - Not A Problem > > 2. I followed your instructions, but why do you need use the command line > to insert a table into the flashsql database? I used phpMyAdmin to import > the client.sql as a table which it said it did successfully? - If it works do it. Just verify you something like this inside myPHPAdmin click - Database flashsql - click client - click Browse name sex age country Coker Isaac Male 27 United Kingdom John Bright Male 26 USA Aniter Baker Female 34 USA Jon Chong Female 46 Japan Sandra Wilcox Female 29 Finland > 3. I still don't populate with data but the header populates after > clicking "Load Data" - Now we will slap this baby hard > > 4. When you say "run", I test by publishing the swf/html from Flash, and > use IE to browse the html file. - Inside Flash click ctrl+Enter to run the flashsql.fla > 5. Here are my parameters: > mySQL root is C:\Program Files\MySQL\MySQL Server 5.0\bin (default MySQL [quoted text clipped - 12 lines] > flashsql database as client2.sql which I saved into a subfolder of my > localhost root which David Powers said to make as: This is the crux of the problem - client2.sql is NOT your database - flashsql is your database. Imagine mySQL is a Library full of books. Inside this Library is a Book called flashsql - your database On the first page of this book is written four names, sex, age and country - your client table. A visitor comes along (flashsql.php) and opens the book and reads the first page. The visitor makes a note of these details and posts then back to your flashsql component. Your component then sends them to your list component. > C:/htdocs > [quoted text clipped - 11 lines] > component as it came from netdrims) > dataSource: C:\htdocs\webdev\client2.sql - flashsql only!, just the one word nothing more > filepath: c:\htdocs\webdev\flashsql_v31.php - I have http://localhost/flashsql/flashsql.php but yours might do if not change it to http://localhost/webdev/flashsql_v31.php > host: localhost - This looks to your webroot and processes flashsql.php which opens mySQL > LoadInto: DataGrid OR none - NONE > pword: mySQLrootpassword [quoted text clipped - 15 lines] > component (thought it would save me php coding) and follow David Power's > book, Flash Foundations for PHP5, and hand-code the php and flash files? Never give up.....well almost never.. We only learn when we find the answer Now that it works?, you can try running your flashsql.html, you will need to copy a new version of the .swf to your webroot folder. > Thanks so much. > Kevin Kent ======================================================= Praise G-d and thefeldkircher! We finally slew the Netdrims beast! I followed your instructions and viola! (BTW, browsing the phpMyAdmin client table did show that phpMyAdmin imported the data correctly - which is way easier than the command line) Now I have to figure out how to replicate this with my own database. 1. Netdrims is "back in business" as flexcubed. 2. However, they DID NOT respond to any of my support emails by 12/19/07 3. I WAS ABLE to get the flashsql component to work WITH MY OWN DATABASE by using the Execute method as detailed in the help file INSTEAD of setting the parameters with with Component Inspector. Hi I did find an answer to your problem too, the instance name of your sql component was incorrent in the button actionscript. Could get data but not into the textArea component. Please start a new thread as this is marked 'Answered'. Thanx |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.