[Phpsig] Learning php4 and mysql

randall perry phpsig@kalamazoolinux.org
Wed, 11 Sep 2002 12:02:21 -0200


--=======394A43B2=======
Content-Type: text/plain; x-avg-checked=avg-ok-42925CE3; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 8bit

I would suggest playing around on your own servers.  It is better to have a 
development environment to try things out before trying to deploy in the 
real world.  Having a local machine makes updating and displaying web pages 
much quicker.  You could even do a quick mysqldump to backup all of the 
data and schema that you were working on and easily transfer that to the 
production server.  For those who aren't comfortable in Linux, or just do 
their development in Windows, I recommend PHPTriad.  I have distributed 
that Windows app to students of the web devel and database courses I have 
taught.  It is very easy to setup and it runs Apache/php/mysql on Windows 
boxes.  There is a version of Dreamweaver Ultradev that can write the PHP 
MySQL hooks for you.  I have used Dreamweaver UltraDev 4 and that didn't 
have it (so some other version).

Happy coding
Randall Perry
www.fasnap.com
www.Davenport.edu
www.domain-logic.com

At 12:35 PM 9/11/2002 -0400, you wrote:

>Once again I am picking up my books on php and mysql and trying to learn
>to write web applications.
>My current webhost has both php and mysql enabled, and I have had some
>success with very basic scripts in php, and with scripts written by others
>with mysql(although with odd errors).
>However, when I use ssh to try to access mysql on my webhost, I get access
>denied errors.  This is probably intentional on the part of the webhost, I
>have to request to have a database created in mysql by the administrator.
>I don't think the users have direct mysql access permission.
>In order to learn to write web applications, should I download mysql and
>install it on my pc at home (with the intent of figuring out the basics of
>mysql before trying to combine it with php)?  Or should I just work on the
>php applications, which seem to be able to connect to my mysql database on
>my webhost?  That is how I would hope to create real web applications.
>I am very much a beginner at this and I am trying to figure out the best
>way to learn the basics of both php and mysql.  It just seems to be a bit
>of a jump to learn both at the same time.  Its hard to figure out what
>happened when things go wrong.
>--
>Paul VandenBosch
>Guide to Sailing and Cruising Stories
>http://cruisenews.net
>
>
>_______________________________________________
>Phpsig mailing list
>Phpsig@kalamazoolinux.org
>http://www.kalamazoolinux.org/mailman/listinfo/phpsig
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.385 / Virus Database: 217 - Release Date: 9/4/2002

--=======394A43B2=======
Content-Type: text/plain; charset=us-ascii; x-avg=cert; x-avg-checked=avg-ok-42925CE3
Content-Disposition: inline


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.385 / Virus Database: 217 - Release Date: 9/4/2002

--=======394A43B2=======--