.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 4 5 6 7 8 9 10 11 > >>   Sort: Rank

How To Get the Uploaded File Information in the Receiving Script
How To Get the Uploaded File Information in the Receiving Script? - PHP Script Tips - Uploading Files to Web Servers Once the Web server received the uploaded file, it will call the PHP script specified in the form action attribute to process them. This receiving PHP script can get the uploaded file... 2007-04-19, 5162👍, 0💬

How To Quote Date and Time Values in SQL Statements
How To Quote Date and Time Values in SQL Statements? - PHP Script Tips - Working with MySQL Database If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you ... 2007-04-19, 4958👍, 0💬

How To Process the Uploaded Files
How To Process the Uploaded Files? - PHP Script Tips - Uploading Files to Web Servers How to process the uploaded files? The answer is really depending on your application. For example: You can attached the outgoing emails, if the uploaded files are email attachments. You can move them to user's Web... 2007-04-19, 5042👍, 0💬

How To Quote Text Values in SQL Statements
How To Quote Text Values in SQL Statements? - PHP Script Tips - Working with MySQL Database Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax... 2007-04-19, 5198👍, 0💬

How To Move Uploaded Files To Permanent Directory
How To Move Uploaded Files To Permanent Directory? - PHP Script Tips - Uploading Files to Web Servers PHP stores uploaded files in a temporary directory with temporary file names. You must move uploaded files to a permanent directory, if you want to keep them permanently. PHP offers the move_uploade... 2007-04-19, 5428👍, 0💬

How To Detect File Uploading Errors
How To Detect File Uploading Errors? - PHP Script Tips - Uploading Files to Web Servers If there was a problem for a file upload request specified by the &lt;INPUT TYPE=FILE NAME=fieldName...> tag, an error code will be available in $_FILES[$fieldName]['error']. Possible error code values are: U... 2007-04-19, 5382👍, 0💬

How To Update an Existing Rows in a Table
How To Update an Existing Rows in a Table? - PHP Script Tips - Working with MySQL Database Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: &lt;?php include "mysql_conn... 2007-04-19, 5066👍, 0💬

Why Do You Need to Filter Out Empty Files
Why Do You Need to Filter Out Empty Files? - PHP Script Tips - Uploading Files to Web Servers When you are processing uploaded files, you need to check for empty files, because they could be resulted from a bad upload process but the PHP engine could still give no error. For example, if a user typed... 2007-04-19, 4969👍, 0💬

How To Create a Table To Store Files
How To Create a Table To Store Files? - PHP Script Tips - Uploading Files to Web Servers If you using MySQL database and want to store files in database, you need to create BLOB columns, which can holds up to 65,535 characters. Here is a sample script that creates a table with a BLOB column to be us... 2007-04-19, 5217👍, 0💬

How To Query Tables and Loop through the Returning Rows
How To Query Tables and Loop through the Returning Rows? - PHP Script Tips - Working with MySQL Database The best way to query tables and loop through the returning rows is to run the SELECT statement with the catch the mysql_query() function, catch the returning object as a result set, and loop thr... 2007-04-19, 5152👍, 0💬

What Is a Result Set Object
What Is a Result Set Object? - PHP Script Tips - Working with MySQL Database 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 the result set. Once ... 2007-04-19, 5083👍, 0💬

What Are the File Upload Settings in Configuration File
What Are the File Upload Settings in Configuration File? - PHP Script Tips - Uploading Files to Web Servers There are several settings in the PHP configuration file related to file uploading: file_uploads = On/Off - Whether or not to allow HTTP file uploads. upload_tmp_dir = directory - The temporar... 2007-04-19, 5704👍, 0💬

How To Insert Rows Based on SELECT Statements
How To Insert Rows Based on SELECT Statements? - PHP Script Tips - Working with MySQL Database If want to insert rows into a table based on data rows from other tables, you can use a sub-query inside the INSERT statement as shown in the following script example: &lt;?php include "mysql_connectio... 2007-04-19, 5026👍, 0💬

How To Uploaded Files to a Table
How To Uploaded Files to a Table? - PHP Script Tips - Uploading Files to Web Servers To store uploaded files to MySQL database, you can use the normal SELECT statement as shown in the modified processing_uploaded_files.php listed below: &lt;?php $con = mysql_connect("localhost", "", ""); mysql_s... 2007-04-19, 5203👍, 0💬

How To Insert Data into a Table
How To Insert Data into a Table? - PHP Script Tips - Working with MySQL Database If you want to insert a row of data into a table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links (id, url) VALUE... 2007-04-19, 4806👍, 0💬

How To Get the Technical Specifications for File Upload
How To Get the Technical Specifications for File Upload? - PHP Script Tips - Uploading Files to Web Servers File upload technical specifications is provided in "Form-based File Upload in HTML - RFC 1867". You can get a copy from http://www.ietf.org/rfc/rfc186 7.txt. 2007-04-19, 5108👍, 0💬

What Is a Session
What Is a Session? - PHP Script Tips - Understanding and Using Sessions A session is a logical object created by the PHP engine to allow you to preserve data across subsequent HTTP requests. There is only one session object available to your PHP scripts at any time. Data saved to the session by a sc... 2007-04-19, 5115👍, 0💬

How To Get the Number of Rows Selected or Affected by a SQL Statement
How To Get the Number of Rows Selected or Affected by a SQL Statement? - PHP Script Tips - Working with MySQL Database There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($rs) - Returns the number of rows selected in a result set obj... 2007-04-19, 5123👍, 0💬

How To Create a Table
How To Create a Table? - PHP Script Tips - Working with MySQL Database 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 NOT NULL" . ", url VARCH... 2007-04-19, 5123👍, 0💬

How To Turn On the Session Support
How To Turn On the Session Support? - PHP Script Tips - Understanding and Using Sessions The session support can be turned on automatically at the site level, or manually in each PHP page script: Turning on session support automatically at the site level: Set session.auto_start = 1 in php.ini. Turni... 2007-04-18, 5168👍, 0💬

How To Save Values to the Current Session
How To Save Values to the Current Session? - PHP Script Tips - Understanding and Using Sessions When session is turned on, a session will be automatically created for you by the PHP engine. If you want to save any values to the session, you can use the pre-defined associative array called $_SESSION.... 2007-04-18, 5330👍, 0💬

How To Run a SQL Statement
How To Run a SQL Statement? - PHP Script Tips - Working with MySQL Database 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 FALSE... 2007-04-18, 5057👍, 0💬

How To Select an Exiting Database
How To Select an Exiting Database? - PHP Script Tips - Working with MySQL Database The first thing after you have created a connection object to the MySQL server is to select the database where your tables are locate, by using the mysql_select_db() function. If your MySQL server is offered by your W... 2007-04-18, 5125👍, 0💬

How To Get the Last ID Assigned by MySQL
How To Get the Last ID Assigned by MySQL? - PHP Script Tips - Working with MySQL Database If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below: &lt;?php include... 2007-04-18, 5724👍, 0💬

<< < … 4 5 6 7 8 9 10 11 > >>   Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML