FRIHOSTFORUMSSEARCHFAQTOSBLOGSCOMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Frihost PHP Account





Gael_Knightley
I am trying to access my Frihost PHP Account at http://www.frih.org/phpmyadmin/. In my account page it specifies that the Username and Password of the Database is required. I am not sure where I can acquire this. Do I need to post more messages to get these parameters?
DoctorBeaver
Click on ACCOUNT at the top of this page and you will see all your settings. The name you need is Control panel username and your password is the same as your password for accessing the forums.
Gael_Knightley
When I supply the username and password, it shows me the form again. I just cannot get through.

I tried all the passwords and username combinations I have on frihost!

It is a pop-up window which shows the server as http://www.frih.org/ and a message saying "phpMyAdmin running on localhost".
Bondings
This is different in DirectAdmin than for cPanel.

You need to login to DirectAdmin and create a database with user there. The username you got/specified there (it will start with your DirectAdmin username and an underscore) and the password should be used for phpMyAdmin.
Gael_Knightley
Ok I created a database and finally managed to log into my phpMyAdmin account.

Now what should I do next?

Do I have to link the database to my web pages to use php or activate it in apache?

I am really confused!

Tables can be created using php right?
Bondings
Gael_Knightley wrote:
Ok I created a database and finally managed to log into my phpMyAdmin account.

Now what should I do next?

Do I have to link the database to my web pages to use php or activate it in apache?

I am really confused!

Tables can be created using php right?

In the php page where you use the database you need to establish a connection to the right database and then use that for a query.

http://be.php.net/manual/en/function.mysql-connect.php
http://be.php.net/manual/en/function.mysql-select-db.php
http://be.php.net/manual/en/function.mysql-query.php

A short example:

Code:

// Settings
$mysql_server = 'localhost';
$mysql_user = 'user';
$mysql_password = 'password';
$mysql_db = 'database_name';

// Connect to mysql
$link = mysql_connect($server, $mysql_user, $mysql_password);
if (!$link) {
    die('Not connected : ' . mysql_error());
}

// Select the right database
$db_selected = mysql_select_db($database_name, $link);
if (!$db_selected) {
    die ('Can\'t use this database: ' . mysql_error());
}

// Query ...
Stubru Freak
Also, it's probably better to make your tables yourself, making them in php requires coding work that isn't really necessary. After that, you can add/delete data from the tables using php.
rvec
Gael_Knightley wrote:
Ok I created a database and finally managed to log into my phpMyAdmin account.

Now what should I do next?

Do I have to link the database to my web pages to use php or activate it in apache?

I am really confused!

Tables can be created using php right?

Just to be clear, you know there is a difference between php and phpmyadmin?
PHP is the scripting language, mysql is the database, phpmyadmin is a script written in php to administrate mysql.
Related topics
The new Account page and Request Mod
PHP Editor in Frihost Direct Admin Server?
FriHost php Configuration
FriHost PHP Parser doesn´t work?
Frihost Directory
Frihost Directory out of beta
Requesting a free FRIHOST web account
Frihost php version
Frihost heeft PHP 4.1 en MySQL 4.0 of hoger?
Frihost Blogs Beta launched!
Session directory permissions issue
Hiccups on "Your Account" page
Open-Realty and Frihost
phpBB Version and FriHost php Compatibility
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.