answersLogoWhite

0

The difference between connect() and pconnect, it is simply like a shop when u entering in shop you will open the door and take your iteam come out and close the door that is called connect() in mysql the connection to the mysql database will be automatically closed when the script terminates.

when the door of the shop is already opend and never close it is called pconnect(), open a connection with mysql_pconnect(), the connection will not be closed and will "persist" for future use.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How do you connect to MySQL in C?

This site has a lot of information on how to connect: http://bitdaddys.com/MySQL-ConnectorNet.html


Why do you keep getting this error Warning mysql connect function mysql-connect Can't connect to local MySQL server through socket 'tmpmysql sock' 2 in mntsdbwww2smut360 comhtdocsincc?

Make sure that the MySQL server is running.


How do you connect MySQL to HTML with Microsoft Office Frontpage?

You can't. Frontpage is just an editor, and you can't connect mySQL to HTML. You can do it with PHP, though.


What is offered by MySQL Connect?

Connection to MySQL Using PHP Script To open a database connection, PHP provides the mysqli construct or the mysqli connect() function. On success, this method returns a MySQL link identification; on failure, it returns FALSE. To learn more about data science please visit- Learnbay.co


Is MySQL a server?

MySQL is an open source relational database management system based on SQL queries. It was developed by the Swedish company MySQL AB and is now a subsidiary of Oracle Corporation. Your could use a MySQL Client, for example dbForge Studio for MySQL, to install and connect to MySQL Server as a first steps to get started with MySQL.


How do you run a MySQL query from PHP file?

Here is a simple script that you can do to run a MySQL query after you have set a database up. <?php // Database Settings $db['hostname'] = "localhost"; $db['username'] = "<db username>"; $db['password'] = "<db password>"; $db['database'] = "<db name>"; // Connect to MySQL $connect = mysql_connect($db['hostname'], $db['username'], $db['password']); // Select Database mysql_select_db($db['database'], $connect); // Do MySQL Query mysql_query("INSERT INTO table_name SET field_name = '1234567890'"); // Close MySQL mysql_close($connect); ?> Obviously you will need to use your own MySQL settings and database details, but this gives you a general overview of how you can do it.


How to you connect in mysql database?

Use the following code to connect to your mysql database from the php file. variables are hostname, db_username, db_password - see the code below for the exact connection example. <?php mysql_connect("localhost", "admin", "1admin") or die(mysql_error()); echo "Connected to MySQL<br />"; ?>


How do you connect C offline application with the MySQL database placed at remote server?

We use an online MySQL database for both online and offline applications.


Would HTML5 support or connect if you use mysql as database?

test web


How do you connect db2 and mysql?

Take a shot at adoDB - find it here: adodb.sourceforge.net


Difference between mysql fetch row and mysql fetch array in PHP?

Both return a row in a MySQL database and in most applications can be used interchangeably. The difference is that mysql_fetch_array has an extra argument called $result_type that allows the returned array to be associative (string keys) or numeric (the keys are 0..n). A mysql_fetch_array call with the numeric parameter is equivalent to mysql_fetch_row.


How do you connect to mysql using vb6?

Install the MyODBC database connector.Set up an new ODBC connection to your mysql database in Windows. (This will vary based on your version of Windows)You can use the ADODB extension in VB to connect to your ODBC connection.