Script School Classroom

School Map: Home / Enroll $ Student Records; Class
$ News @ LIVE Tech Radio * Support/FAQ | Store | FORUMS

Week #1 ADVANCED To-Do Assignment, post here

(#2 2003-08-08 08:56:35) Post Reply

TDavid
php mySQL Perl C/C++
Principal

Enrolled: Mar 2000
Posts: 193
AP: 1

Your Week #1 ADVANCED TO-DO assignment should be posted here in this thread only. You should post your basic to-do assignment first before posting, regardless of your skill level.

If you have specific questions about the Week #1 advanced to-do assignment then please also post them in this thread so that other students can learn from the information and we can collectively build a knowledge base.

Here is the details on what you need to do in this assignment:

Advanced To-Do Assignment for Week #1: Install an SDK on Your local workstation and use phpMyAdmin to create Your test Database and test Your connection to it. Describe the steps you took to do this in your post in this forum. Provide a screenshot of your desktop showing successful installation and put a link up here.

(#9 2003-08-12 15:26:00) Post Reply

Donnie
Need To Set

Enrolled: Aug 2003
Posts: 41
AP: 1

I completed the week 1 advanced to do assignment. I don't really know what to post as proof, but it is done.

(#12 2003-08-13 23:28:14) Post Reply

lizabit
Need To Set

Enrolled: Jul 2003
Posts: 17
AP: 1

downloaded and installed phpdev from firepages and created test database using phpMyAdmin and using php.
Liz

(#15 2003-08-15 11:14:44) Post Reply

TDavid
php mySQL Perl C/C++
Principal

Enrolled: Mar 2000
Posts: 193
AP: 1

Here's the proof: screenshots of it working on your computer ;)

quote:

Provide a screenshot of your desktop showing successful installation and put a link up here.

If you have a digital camera, then take a picture of your desktop and computer and share.

(#16 2003-08-15 11:15:22) Post Reply

TDavid
php mySQL Perl C/C++
Principal

Enrolled: Mar 2000
Posts: 193
AP: 1

oops, and forgot to add the first part, which is the text:

quote:
Describe the steps you took to do this in your post in this forum.

(#19 2003-08-18 23:13:47) Post Reply

lizabit
Need To Set

Enrolled: Jul 2003
Posts: 17
AP: 1

(Revised)
Ok, You're right TD. My apologies.
I downloaded from firepages, dev 423.
I set username and password on my localhost (using phpadmin) then I went to phpmyadmin and created a new database called ssMySQLclass and added a simple table not straying from your format at all. (I am not very adventurous.) I then added data to the table from phpmyadmin but thats about all I am capable of at this stage.
I then created a database using php.
My screen shot can be found at http://www.budgetkitchens.com....ard_at_work.htm

(#33 2003-09-03 15:38:56) Post Reply

Donnie
Need To Set

Enrolled: Aug 2003
Posts: 41
AP: 1

I installed phpdev423 on my machine. I created a database called ssMySQLclass. I then created a table called shoppinglist. I used the onscreen prompts within phpmyadmin. Here is the screen shot:
http://www.dandrenterprises.co...lscreenshot.jpg

I am having one small problem. When I go to Users in phpmyadmin and add a user and a password, I cant connect to the server using this username and password. Any suggestions?

(#34 2003-09-04 04:55:30) Post Reply

logspirit
Need To Set

Enrolled: Oct 2001
Posts: 63
AP: 1

Donnie,
You have to restart the MySQL server for the new user and password changes to take effect. Also be sure that You have applied these grants to the correct database/table etc.
Good Question! Good work!
logspirit

(#36 2003-09-04 05:36:10) Post Reply

logspirit
Need To Set

Enrolled: Oct 2001
Posts: 63
AP: 1

Donnie,
To make my last statement more specific, I'll quote the manual: http://www.mysql.com/doc/en/Pr...ge_changes.html

"Modifications to the grant tables that you perform using GRANT, REVOKE, or SET PASSWORD are noticed by the server immediately."

"If you modify the grant tables manually (using INSERT, UPDATE, etc.), you should execute a FLUSH PRIVILEGES statement or run mysqladmin flush-privileges or mysqladmin reload to tell the server to reload the grant tables. Otherwise, your changes will have no effect until you restart the server. If you change the grant tables manually but forget to reload the privileges, you will be wondering why your changes don't seem to make any difference!"

I believe phpMyAdmin uses the UPDATE command to change the settings, which explains why it is necessary to restart the MySQL server.

logspirit

(#43 2003-09-18 08:46:08) Post Reply

Shrek
Need To Set

Enrolled: Aug 2003
Posts: 33
AP: 1

My Picture Link
http://members.lycos.co.uk/jef.../phpmyadmin.jpg

I have installed
Apache 2.x
PHP 4.x
MySQL 4.0.15
PHPmyAdmin 2.5.3

After Using the PHPmyAdmin to create database ssmysqlclass.

I use the following code to test access..




<? 

$db = mysql_connect("localhost","sqlclass", "sqlclass") or die("Could not connect:". mysql_error()); 

print("Connected successfully<br>"); 



mysql_select_db("ssMySQLclass",$db) 

or die("Could not Connect to database:". mysql_error()); 

print("Connected to Database<br>"); 



?>

(#45 2003-09-23 21:47:21) Post Reply

logspirit
Need To Set

Enrolled: Oct 2001
Posts: 63
AP: 1

Shrek, Good Work! Now You have the tools You'll need to develop Your PHP/MySQL applications!
Happy Programming!
logspirit

View Previous Thread

Print This Page

View Next Thread

School Map: Home / Enroll $ Student Records; Class
$ News @ LIVE Tech Radio * Support/FAQ | Store

Advertising | Link To Us | Privacy
Copyright 2000-2002 Script School Productions / KMR Enterprises
No part of this website may be reproduced, copied and/or distributed in any medium
without express written permission