PDO_MYSQL is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to MySQL
Category Archives: PHP
PDO
The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for accessing databases in PHP.
Features
- Supports 12 different databases
- Object Mapping
- Supports prepared statements
- Supports multiple statements
- Object oriented interface
- Named parameters
- PDO has built-in support for Large Objects (LOBs).
- When something goes wrong, PDO can throw an instance of its own exception class.
- PDO does not emulate missing database features.
- Placeholders within PDO prepared statements need not be named.
pcre
Perl Compatible Regular Expressions (PCRE) is a regular expression C library inspired by Perl’s external interface, written by Philip Hazel. PCRE’s syntax is much more powerful and flexible than either of the POSIX regular expression flavors and many classic regular expression libraries. The name is misleading, because PCRE is Perl-compatible only if you consider a subset of PCRE’s settings and a subset of Perl’s regular expression facilities.
The PCRE library is incorporated into a number of prominent open-source programs, such as the Apache HTTP Server and the PHP and R scripting languages; and can be incorporated in proprietary software too (BSD license). As of Perl 5.10, PCRE is also available as a replacement for Perl’s default regular expression engine through the re::engine::PCRE module.
mcrypt
mcrypt is a replacement for the popular UNIX crypt command. crypt was a file encryption tool that used an algorithm very close to the World War II enigma cipher, which was broken. Mcrypt provides the same functionality but uses several modern algorithms such as AES. Libmcrypt, Mcrypt’s companion, is a library of code which contains the actual encryption functions and provides an easy method for use.
iconv
iconv is a computer program and a standardized API used to convert between different character encodings.
The iconv API is the standard programming interface for converting character strings from one character encoding to another in Unix-like operating systems. Initially appearing on the HP-UX operating system, it was standardized within XPG4 and is part of the Single UNIX Specification (SUS).
Hash
A hash function is any algorithm or subroutine that maps large data sets, called keys, to smaller data sets. For example, a single integer can serve as an index to an array (cf. associative array). The values returned by a hash function are called hash values, hash codes, hash sums, checksums or simply hashes.
Hash functions are mostly used to accelerate table lookup or data comparison tasks such as finding items in a database, detecting duplicated or similar records in a large file, finding similar stretches in DNA sequences, and so on.
GD Graphics Library
The GD Graphics Library is a graphics software library by Thomas Boutell and others for dynamically manipulating images. Its native programming language is ANSI C, but it has interfaces for many other programming languages. It can create GIFs, JPEGs, PNGs, and WBMPs. Support for drawing GIFs was dropped in 1999 when Unisys revoked the royalty-free license granted to non-commercial software projects for the LZW compression method used by GIFs. When the Unisys patent expired worldwide on July 7, 2004, GIF support was subsequently re-enabled.
GD is extensively used with PHP, where a modified version supporting additional features is included by default as of PHP 4.3 and was an option before that. As of PHP 5.3, a system version of GD may be used as well, to get the additional features that were previously available only to the bundled version of gd.
mysql functions
- mysql_affected_rows – Returns the number affected rows in the last mysql operation
- mysql_client_encoding – Returns the name of the character set
- mysql_close – Close the mysql connection
- mysql_connect – Establish a connection to the mysql server
- mysql_create_db – Create a new database
- mysql_data_seek – move the pointer to the specific row
- mysql_db_name – Returns the database name from selected databases
- mysql_db_query() – Its Deprecated. Sends a MySQL query
- mysql_drop_db – Delete the databse . Its depricated
- mysql_errno – Shows the numerical values of the error messages due to mysql operations
- mysql_error – Shows the error messages due to mysql operations
- mysql_escape_string – Modify the string to use in a mysql query
- mysql_fetch_array – Fetch the result both in a numeric array and associative array
- mysql_fetch_assoc – Fetch the result in a associative array
- mysql_fetch_field – Returns column information
- mysql_fetch_lengths– Returns length of each output
- mysql_fetch_object – Fetch the result as object
- mysql_fetch_row – Returns the rows in an array
- mysql_field_flags – Returns the flags associated with the latest result
- mysql_field_len – Returns the length of a specific field
- mysql_field_name – Return the name of the field in the result
- mysql_field_seek – Can be used to move the result pointer
- mysql_field_table – Returns the table name the specified field is in
- mysql_field_type – Returns the type of the specified field in the result
- mysql_free_result – Free the memory that the result used
- mysql_get_client_info – Returns mysql information
- mysql_get_host_info – Returns the host information
- mysql_get_proto_info – Returns the Protocol information
- mysql_get_server_info – Returns the Server information
- mysql_info – Returns the information about the last query
- mysql_insert_id – Return the id generated the previous query
- mysql_list_dbs – List all the databases
- mysql_list_fields – list all the fields in atable
- mysql_list_processes – List mysql process
- mysql_list_tables – List all the tables
- mysql_num_fields – Returns the number of fields in the result
- mysql_num_rows – Returns the number of rows in the result
- mysql_pconnect – Establish a persistent connection to a MySQL server
- mysql_ping – Can be used to the connection to the server
- mysql_query – send a query to the server
- mysql_real_escape_string – Escapes special characters that a query does not support
- mysql_result – Can be used to display result in a specified row
- mysql_select_db – Used to select a database
- mysql_set_charset – Can be used to set a character set
- mysql_stat – returns current status of the mysql server
- mysql_tablename – Returns the table name of a field
- mysql_thread_id – Returns current thread id
- mysql_unbuffered_query – Send the query to the server and buffering the result
Import data into csv – php
<?php
mysql_connect(“localhost”,”root”,”password”);
mysql_select_db(“phpcodez”); // Dont forget to put correct database name
$filename = “users-csv”.date(‘-Y-M-d-D-H-i-s’).”.csv”;
$fp = fopen($filename, ‘w’) or die (‘file cant be opened’);
$fieldsQry = mysql_query(“SHOW COLUMNS FROM user”);
while ($fields = mysql_fetch_assoc($fieldsQry)) {
$fieldNames[] = $fields[‘Field’];
}
fputcsv($fp, $fieldNames);
$usersQry = mysql_query(“SELECT * FROM user”);
while($userInfo=mysql_fetch_assoc($usersQry)){
fputcsv($fp, $userInfo);$i++;
}
system(“chmod 777 $filename”);
fclose($fp);
echo “Imported “.$i.” items”
?>
Read csv file in php
<?php
$filename = str_replace(“.”,date(‘-Y-M-d-D-H-i-s.’),$_FILES[‘upload’][‘name’]);
echo “<table border=’1′>”;
if (($handle = fopen($filename, “r”)) !== FALSE) {
while (($data = fgetcsv($handle, 1000, “,”)) !== FALSE){ ?>
<tr><?php foreach($data as $values) {?><td > <?php echo $values ?></td><?php } ?></tr>
<?php }
}
echo “</table>”;
?>