Replace accounts.php with database

[CuraHack]

Hi, It's me again

I want to replace the accounts.php file with a database connection. The accounts.php files contains a "PHP Array" which can be replaced by a database/table with the same fields (correct me if I'm wrong):
host (text field)
user (text field)
pass (text field)

The problem is I don't have the knowledge to do this

Can anyone help me with this ?

CuraHack Reviewed by CuraHack on 23rd Feb 2011. Replace accounts.php with database Hi, It's me again B-) I want to replace the accounts.php file with a database connection. The accounts.php files contains a "PHP Array" which can be replaced by a database/table with the same fields (correct me if I'm wrong): host (text field) user (text field) pass (text field) The problem is I don't have the knowledge to do this :(( Can anyone help me with this ? Rating: 5

[Lock Down]

How are the fields separated in the file?

[CuraHack]

This is what the accounts.php array looks loke:

$premium_acc["megaupload_com"] = array('user' => 'MyPremiumUsername', 'pass' => 'MyPassword'); 

[Lock Down]

Here is the mysql table create. The unique index will stop you from having the same premium account/user duplicated. But you can have all the unique premium account/user entries you want.

CREATE TABLE `PremiumAccounts` (
    `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
    `account` VARCHAR(255) NOT NULL DEFAULT '',
    `user` VARCHAR(255) NULL DEFAULT NULL,
    `password` VARCHAR(255) NOT NULL DEFAULT '',
    PRIMARY KEY (`id`),
    UNIQUE INDEX `accountuser` (`account`, `user`),
    INDEX `account` (`account`),
    INDEX `user` (`user`)
)
ENGINE=MyISAM
ROW_FORMAT=DEFAULT 

I would assume the file is an include to a php program you already use then. If you need the code to insert/replace the data let me know.