Sponsored Content
Top Forums Web Development Apache users from MySQL database Post 302857279 by Scott on Wednesday 25th of September 2013 09:50:40 PM
Old 09-25-2013
The simplest way to do that it to put the configuration items (username, password, database name or connection string, etc.) into a configuration file and use the include, or requireonce directive to load the file in each of your PHP files that require it.
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Apache and MySQL as services?

What is the best way to run Apache2 and MySQL as daemons that run on startup? Can anyone give me some scenarios/examples. Thanks in advance! (3 Replies)
Discussion started by: ezekiel61
3 Replies

2. Solaris

Problems starting apache 1.3 with mysql

I've been working on a project to replace one of the my group's primary NIS servers. It also runs mysql and apache, as it is the host for the our team's hardware tracking database and website. Its running apache 1.3, and for some odd reason, I can't get apache to start on system boot. The... (1 Reply)
Discussion started by: godspunk32
1 Replies

3. Shell Programming and Scripting

How to backup a particular Database in MYSQL?

Hi All, Thanks in Advance!! How to backup a particular Databases..through Bash script!! For example i have 6 databases; Anish linux Software Questions Rhce Google these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.... (4 Replies)
Discussion started by: anishkumarv
4 Replies

4. Ubuntu

Mysql apache installation

on ubuntu lamp server how to install mysql and apache? any instructions? (1 Reply)
Discussion started by: srinathk
1 Replies

5. Programming

Mailx recipient from mysql database

Dear All, Can I make Mailx to read recipient address from a mysql database? I already tried emailing with bash script: SUBJECT="TEST" export EMAIL_ADDRESS=`mysql -uroot -pabcde smsd -e "SELECT email FROM recipient"` mysql -uroot -pabcde smsd -e "SELECT ID, SenderName, Body FROM inbox" |... (2 Replies)
Discussion started by: jazzyzha
2 Replies

6. Shell Programming and Scripting

Mailx recipient from mysql database

Dear All, Can I make Mailx to read recipient address from a mysql database? I already tried emailing with bash script: SUBJECT="TEST" export EMAIL_ADDRESS=`mysql -uroot -pabcde smsd -e "SELECT email FROM recipient"` mysql -uroot -pabcde smsd -e "SELECT ID, SenderName, Body FROM inbox" |... (14 Replies)
Discussion started by: jazzyzha
14 Replies

7. Shell Programming and Scripting

File fetching from mysql database

I have a configuration file namely: abcd, that will be use for some service (like gammu) Inside that configuration file: number1 = 66673527 number1 = 8373272 How can I make the file to search the number1 and number2 from a mysql database? Any help will be very appreciated. Thanks (1 Reply)
Discussion started by: jazzyzha
1 Replies

8. Programming

Need help on Insert data to mySQL database

Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method.... (1 Reply)
Discussion started by: aoiregion
1 Replies
MYSQL_PCONNECT(3)							 1							 MYSQL_PCONNECT(3)

mysql_pconnect - Open a persistent connection to a MySQL server

SYNOPSIS
Warning This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include: omysqli_connect(3) with p: host prefix o PDO::__construct with PDO::ATTR_PERSISTENT as a driver option resource mysql_pconnect ([string $server = ini_get("mysql.default_host")], [string $username = ini_get("mysql.default_user")], [string $password = ini_get("mysql.default_password")], [int $client_flags]) DESCRIPTION
Establishes a persistent connection to a MySQL server. mysql_pconnect(3) acts very much like mysql_connect(3) with two major differences. First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection. Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close(3) will not close links established by mysql_pconnect(3)). This type of link is therefore called 'persistent'. o $server - The MySQL server. It can also include a port number. e.g. "hostname:port" or a path to a local socket e.g. ":/path/to/socket" for the localhost. If the PHP directive mysql.default_host is undefined (default), then the default value is 'localhost:3306' o $username - The username. Default value is the name of the user that owns the server process. o $password - The password. Default value is an empty password. o $client_flags - The $client_flags parameter can be a combination of the following constants: 128 (enable LOAD DATA LOCAL handling), MYSQL_CLIENT_SSL, MYSQL_CLIENT_COMPRESS, MYSQL_CLIENT_IGNORE_SPACE or MYSQL_CLIENT_INTERACTIVE. Returns a MySQL persistent link identifier on success, or FALSE on failure. +--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.5.0 | | | | | | | This function will generate an E_DEPRECATED | | | error. | | | | +--------+---------------------------------------------------+ Note Note, that these kind of links only work if you are using a module version of PHP. See the Persistent Database Connections section for more information. Warning Using persistent connections can require a bit of tuning of your Apache and MySQL configurations to ensure that you do not exceed the number of connections allowed by MySQL. Note You can suppress the error message on failure by prepending a @ to the function name. mysql_connect(3), Persistent Database Connections. PHP Documentation Group MYSQL_PCONNECT(3)
All times are GMT -4. The time now is 12:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy