Topic: NOOB Guinnea Pig Needs Hand Holding to Install Access_user (Read 2562 times)
Chicken-run Manager
Posts: 9
66 credits Members referred : 0
« on: Sep 12, 2006, 05:00:43 am »
Okay, I am totally ignorant. I would appreciate it if someone could hold my hand and give me step by step directions to installing Access_user on my server account. I am running a dedicated server with cpanel/whm including mysql. My public html files are in a folder with a path like this ip/~login/public_html . I have domains registered and pointing to my server. I want to install and run Access_user on one of the cpanel virtual accounts I set-up on the server
I already uploaded the files to a directory with this path tjjack.com/classes/access_user
Is this correct?
What is the next thing I do?
I need to create a mysql database? What do I name it?
How do I do this "Use the "users_table.sql" file to create your MySQL table"
Thanks in advance for helping,
Tj Jack
Kill the googlebot
Posts: 6
44 credits Members referred : 0
« Reply #1 on: Sep 12, 2006, 07:33:07 am »
Odds are you have phpMyAdmin available somewhere... it's the easiest way. Simply create your database with it (or with something else, name it whatever you want), then run a SQL command within it, and the command you want to run is in the sql files namely users_table.sql Then, edit db_config.php. There are tutorials out there for using phpMyAdmin, you should google for them.
Moderator Community Supporter?
Jedai Sword Master
Gender:
Posts: 6691
34714 credits Members referred : 374
It's time to use PHP5!
« Reply #2 on: Sep 12, 2006, 08:16:40 am »
tjjack, first you need to learn how to walk before you start running,
you told me that you're reading a basic php book, try their examples first otherwise you will quit with php very soon...
Chicken-run Manager
Posts: 9
66 credits Members referred : 0
Odds are you have phpMyAdmin available somewhere... it's the easiest way. Simply create your database with it (or with something else, name it whatever you want), then run a SQL command within it, and the command you want to run is in the sql files namely users_table.sql Then, edit db_config.php. There are tutorials out there for using phpMyAdmin, you should google for them.
Thanks Phillip
I am semi-familliar with phpmyadmin for mysql and I created the data base named FREE_Members and made myself a user.
I imported the file users_table.sql and got the following message
******************************* CREATE TABLE `users` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `login` varchar( 25 ) NOT NULL default '', `pw` varchar( 32 ) NOT NULL default '', `real_name` varchar( 32 ) NOT NULL default '', `extra_info` varchar( 100 ) NOT NULL default '', `email` varchar( 50 ) NOT NULL default '', `tmp_mail` varchar( 50 ) NOT NULL default '', `access_level` tinyint( 4 ) NOT NULL default '0', `active` enum( 'y', 'n' ) NOT NULL default 'n', PRIMARY KEY ( `id` ) , UNIQUE KEY `user` ( `login` ) , UNIQUE KEY `mail` ( `email` ) ) TYPE = MYISAM ;# MySQL returned an empty result set (i.e. zero rows). # # admin example record for table `users` # INSERT INTO `users` VALUES ( NULL , 'administrator', '40be4e59b9a2a2b5dffb918c0e86b3d7', 'The site administrator', '', 'my@mail.com', '', 10, 'y' );# Affected rows: 1
*******************************
I edit the db_config.php with notepad. And uploaded it to the server.
What next?
Chicken-run Manager
Posts: 9
66 credits Members referred : 0
« Reply #6 on: Sep 12, 2006, 11:34:18 am »
Thanks Nikolas!
You know what they say? "Can't never got anything done!"
I have done a lot of examples in the book butt this is my first attempt to make something work online for the public.
I am tired of STATIC Pages!
Moderator Community Supporter?
Jedai Sword Master
Gender:
Posts: 6691
34714 credits Members referred : 374
I edit the db_config.php with notepad. And uploaded it to the server.
What next?
I you read and understood the book then it should be possible to you to use all the example files...
Moderator Community Supporter?
Jedai Sword Master
Gender:
Posts: 6691
34714 credits Members referred : 374
It's time to use PHP5!
« Reply #8 on: Sep 12, 2006, 11:54:22 am »
Don't get me wrong, we like to help you here, but I don't think that usefull to start using classes as a newbie...
again start with some example code from your book and build with this code you first website.
do you already know what are sessions, database connections, result, multi arrays...? You need knowledge about all this items to be able to build a website with a memeber system.
I can't believe that you don't have questions about the stuff from your book... (I had after reading the first one)
I am a metal monkey!
Administrator Community Supporter?
Jedai Sword Master
Gender:
Posts: 5799
46391 credits Members referred : 3
« Reply #9 on: Sep 12, 2006, 11:59:49 am »
I think what Olaf is trying to say, is that you should start from this board