< 1 2 3 4 5 6 7 > >>   Sort: Rank

How To Access MySQL Servers through Firewalls
How To Access MySQL Servers through Firewalls? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MyS...
2007-05-10, 5034👍, 0💬

How To Get MySQL Statement Execution Errors
How To Get MySQL Statement Execution Errors? - MySQL FAQs - PHP Connections and Query Execution When you execute a MySQL statement with mysql_query(), and the statement failed, mysql_query() will return the Boolean value FALSE. This is good enough to tell that there is something wrong with that stat...
2007-05-10, 4726👍, 0💬

How To Fix the INSERT Command Denied Error
How To Fix the INSERT Command Denied Error? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The reason for getting the "1142: INSERT command denied" error is that your user accound does not have the INSERT privilege on the table or database. To resolve this error, you need to ask...
2007-05-10, 5162👍, 0💬

How To Insert Data into an Existing Table
How To Insert Data into an Existing Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql ...
2007-05-10, 4865👍, 0💬

What Do You Need to Connect PHP to MySQL
What Do You Need to Connect PHP to MySQL? - MySQL FAQs - PHP Connections and Query Execution If you want to access MySQL database server in your PHP script, you need to make sure that a MySQL API module (extension) is installed and turned on in your PHP engine. PHP 5 now supports two MySQL API exten...
2007-05-10, 4673👍, 0💬

How To Close MySQL Connection Objects
How To Close MySQL Connection Objects? - MySQL FAQs - PHP Connections and Query Execution MySQL connection objects created with mysql_connect() calls should be closed as soon as you have finished all of your database access needs by calling mysql_close($con) function. This will reduce the consumptio...
2007-05-10, 4889👍, 0💬

Can You Select Someone Else Database
Can You Select Someone Else Database? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, they will provide you one database for your use only. There are many other databases on the server for other users. But your user account will hav...
2007-05-10, 4852👍, 0💬

How To Drop an Existing Database
How To Drop an Existing Database? - MySQL FAQs - PHP Connections and Query Execution If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database: $con = mysql_connect('localhost:8888' ,'dev', 'iyf'); $sq...
2007-05-10, 4778👍, 0💬

How To Install PHP on Windows
How To Install PHP on Windows? - MySQL FAQs - PHP Connections and Query Execution The best way to download and install PHP on Windows systems is to: Go to http://www.php.net, which is the official Web site for PHP. Download PHP binary version for Windows in ZIP format. Unzip the downloaded file into...
2007-05-10, 4565👍, 0💬

How To Create a New Database
How To Create a New Database? - MySQL FAQs - PHP Connections and Query Execution A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are a the administrator of the server, you can create a new databases using the CREATE DATABASE ...
2007-05-10, 4733👍, 0💬

What Is a Result Set Object
What Is a Result Set Object? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in t...
2007-05-10, 4965👍, 0💬

How To Run a SQL Statement
How To Run a SQL Statement? - MySQL FAQs - PHP Connections and Query Execution You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status: Returning FA...
2007-05-10, 4761👍, 0💬

How To Create a New Table
How To Create a New Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER ...
2007-05-10, 4702👍, 0💬

How To Check Your PHP Installation
How To Check Your PHP Installation? - MySQL FAQs - PHP Connections and Query Execution PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\...
2007-05-10, 4750👍, 0💬

How To Select an Exiting Database
How To Select an Exiting Database? - MySQL FAQs - PHP Connections and Query Execution The first thing after you have created a connection object to the MySQL server is to select the database where your tables are located, by using the mysql_select_db() function. If your MySQL server is offered by yo...
2007-05-10, 4865👍, 0💬

How To Receive a Cookie from the Browser
How To Receive a Cookie from the Browser? - PHP Script Tips - Understanding and Managing Cookies If you know that a cookie has been sent to the browser when it was visiting the server previously, you can check the built-in $_COOKIE array, which contains all cookies that were sent by the server previ...
2007-04-25, 4801👍, 0💬

How To Send a Cookie to the Browser
How To Send a Cookie to the Browser? - PHP Script Tips - Understanding and Managing Cookies If you want to sent a cookie to the browser when it comes to request your PHP page, you can use the setcookie( ) function. Note that you should call setcookie() function before any output statements. The foll...
2007-04-25, 4889👍, 0💬

How To Test Cookies on a Web Server
How To Test Cookies on a Web Server? - PHP Script Tips - Understanding and Managing Cookies If you want to test cookies with a browser, you need to run a Web server locally, or have access to a Web server remotely. Then you can copy the following PHP cookie test page, setting_receiving_cookies.php, ...
2007-04-25, 4752👍, 0💬

What Is a Persistent Cookie
What Is a Persistent Cookie? - PHP Script Tips - Understanding and Managing Cookies A persistent cookie is a cookie which is stored in a cookie file permanently on the browser's computer. By default, cookies are created as temporary cookies which stored only in the browser's memory. When the browser...
2007-04-25, 5038👍, 0💬

What Is a Cookie
What Is a Cookie? - PHP Script Tips - Understanding and Managing Cookies A cookie is a small amount of information sent by a Web server to a web browser and then sent back unchanged by the browser each time it accesses that server. HTTP cookies are used for authenticating, tracking, and maintaining ...
2007-04-25, 4963👍, 0💬

How To Define a Function with Any Number of Arguments
How To Define a Function with Any Number of Arguments? - PHP Script Tips - Creating Your Own Functions If you want to define a function with any number of arguments, you need to: Declare the function with no argument. Call func_num_args() in the function to get the number of the arguments. Call func...
2007-04-25, 4659👍, 0💬

How To Set a Persistent Cookie
How To Set a Persistent Cookie? - PHP Script Tips - Understanding and Managing Cookies If you want to set a persistent cookie, you can use the setcookie() function with an extra parameter to specify its expiration time. To follow sample script sets 2 persistent cookies to be expired within 7 days: s...
2007-04-25, 4875👍, 0💬

How To Test Persistent Cookies
How To Test Persistent Cookies? - PHP Script Tips - Understanding and Managing Cookies If you want to test persistent cookies, you can copy the following PHP script, setting_persistent_cookies.php ,to your Web server: &lt;?php setcookie("LoginName","FYICent er");setcookie("PreferredColor","Bl ue"...
2007-04-25, 4934👍, 0💬

How To Specify Argument Default Values
How To Specify Argument Default Values? - PHP Script Tips - Creating Your Own Functions If you want to allow the caller to skip an argument when calling a function, you can define the argument with a default value when defining the function. Adding a default value to an argument can be done like thi...
2007-04-25, 4922👍, 0💬

< 1 2 3 4 5 6 7 > >>   Sort: Rank