Database host phpfox
Posted by: totalbmove (---.dllstx.fios.verizon.net)
Date: November 13, 2010 11:11PM

I have wamp and I'm trying to install phpfox onto my local server. It is asking me to configure my database. It asks for database host, database name, database username, and username password. What should I do to get this information. Do I find this information with wamp?

Options: ReplyQuote
Re: Database host phpfox
Posted by: stevenmartin99 (---.b-ras2.blp.dublin.eircom.net)
Date: November 13, 2010 11:18PM

Goto http: //localhost/phpmyadmin


type in a dbname you want and press create . this will make a blank database for you.


go back to the form and fill in


database host = localhost
database name = NAME YOU FILLED IN ABOVE
database username = root
database password = LEAVE BLANK

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: Database host phpfox
Posted by: totalbmove (---.dllstx.fios.verizon.net)
Date: November 14, 2010 12:00AM

Thank you so much. Worked great!

Options: ReplyQuote
Re: Database host phpfox
Posted by: yfastud (Moderator)
Date: November 15, 2010 05:03PM

You should create new db acct for each and all new scripts instead using root for everything, which is a very bad practice

To setup DB account, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: Database host phpfox
Posted by: cakky (---.dsl.bell.ca)
Date: March 20, 2013 04:57PM

stevenmartin99 Wrote:
-------------------------------------------------------
> Goto http: //localhost/phpmyadmin
>
>
> type in a dbname you want and press create .
> this will make a blank database for you.
>
>
> go back to the form and fill in
-------------------------------------------------------

so what if I already have a existed database before using wampserver to install a forum software locally? where should I put that database in?

Thanks,



Edited 1 time(s). Last edit at 03/20/2013 04:59PM by cakky.

Options: ReplyQuote
Re: Database host phpfox
Posted by: RiggsFolly (---.as13285.net)
Date: March 20, 2013 05:03PM

Export it from where it is, and then import it in to wheer you now want it. You can use phpMyAdmin to do that as long as its not to large a database

Options: ReplyQuote
Re: Database host phpfox
Posted by: cakky (---.dsl.bell.ca)
Date: March 20, 2013 05:07PM

RiggsFolly Wrote:
-------------------------------------------------------
> Export it from where it is, and then import it in
> to wheer you now want it. You can use phpMyAdmin
> to do that as long as its not to large a database
------------------------------------------------------

how to import the sql file?
do I just go to

[localhost]
database

and then?

(I am new to this...)

Options: ReplyQuote
Re: Database host phpfox
Posted by: RiggsFolly (---.as13285.net)
Date: March 20, 2013 05:08PM

Basically yes. Lookup a tutorial on the web

Options: ReplyQuote
Re: Database host phpfox
Posted by: zdy (27.17.16.---)
Date: March 21, 2013 07:10AM

<?php
/**
* [PHPFOX_HEADER]
*/

defined('PHPFOX') or exit('NO DICE!');

Phpfox::getLibClass('phpfox.database.dba');

/**
* Database layer for phpFox. All interactions with a database is done via this class.
* It connects to a specific driver such as MySQL or MySQLi or Oracle based on the
* site owners needs.
*
* Example use of an SQL query:
* <code>
* Phpfox::getLib('database')->query('SELECT * FROM user');
* </code>
*
* Example use to get multiple rows from a table:
* <code>
* $aRows = Phpfox::getLib('database')->select('*')
* ->from('user')
* ->where('user_name = \'foo\'')
* ->execute('getRows');
* </code>
*
* Example to insert data into the database:
* <code>
* Phpfox::getLib('database')->insert('user', array(
* 'email' => 'foo@bar.com',
* 'full_name' => 'Full Name'
* )
* );
* </code>
*
* Example to update a record:
* <code>
* Phpfox::getLib('database')->update('user', array('email' => 'foo@bar.com'), 'user_id = 1');
* </code>
*
* Example to delete a record:
* <code>
* Phpfox::getLib('database')->delete('user', 'user_id = 1');
* </code>
*
* @copyright [PHPFOX_COPYRIGHT]
* @author Raymond Benc
* @package Phpfox
* @version $Id: database.class.php 1666 2010-07-07 08:17:00Z Raymond_Benc $
*/
class Phpfox_Database
{
/**
* Holds the drivers object
*
* @var object
*/
private $_oObject = null;

/**
* Loads and initiates the SQL driver that we need to use.
*
*/
public function __construct()
{
if (!$this->_oObject)
{
switch(Phpfox::getParam(array('db', 'driver')))
{
case 'mysqli':
$sDriver = 'phpfox.database.driver.mysqli';
break;
case 'postgres':
$sDriver = 'phpfox.database.driver.postgres';
break;
case 'mssql':
$sDriver = 'phpfox.database.driver.mssql';
break;
case 'oracle':
$sDriver = 'phpfox.database.driver.oracle';
break;
case 'sqlite':
$sDriver = 'phpfox.database.driver.sqlite';
break;
default:
$sDriver = 'phpfox.database.driver.mysql';
break;
}

$this->_oObject = Phpfox::getLib($sDriver);
$this->_oObject->connect(Phpfox::getParam(array('db', 'host')), Phpfox::getParam(array('db', 'user')), Phpfox::getParam(array('db', 'pass')), Phpfox::getParam(array('db', 'name')));
}
}

/**
* Return the object of the storage object.
*
* @return object Object provided by the storage class we loaded earlier.
*/
public function &getInstance()
{
return $this->_oObject;
}
}

?>
www.cusabio.com/ELISA_Kit-84602/ il-6 elisa kit

Options: ReplyQuote


Sorry, only registered users may post in this forum.