How to get the Next Auto Increment number in MySQL
In order to get the next Auto Increment number in MySQL just run: SHOW TABLE STATUS LIKE '$tablename'; The result would be in `Auto_Increment`. Voila !
$
grep -r "#software" ./posts
Tag
#software
// 31 matches
MySQL Frequently Used Commands
Selecting a database: mysql> USE database; Listing databases: mysql> SHOW DATABASES; Listing tables in a db: mysql> SHOW TABLES; Describing the format of a table: mysql> DESCRIBE table; Creating a...
Convert a string into an URL safe address
/** * Convert a string into a url safe address. * * @param string $unformatted * @return string */ public function formatURL($unformatted) { $url = strtolower(trim($unformatted)); //replace accent...
Scanning for Viruses Using PHP and ClamAV
Here what I found and like most. PHP Code for directory scanning: // Set the allowed types for reading and upload. $types = array ('jpg', 'jpeg', 'txt'); // Start a variable. $dir_files = array(); //...
What is npviewer.bin? Why it takes all computer's power?
This is a Netscape plugin viewer. It is used, most of the time, to play some Flash animations in Firefox. These are unsuseful commercial ads very often.
PHP Get File Extension
Just some examples: $filename = 'sample.gif'; // 1. The "explode/end" approach $ext = end(explode('.', $filename)); // 2. The "strrchr" approach $ext = substr(strrchr($filename, '.'), 1); // 3. The...
Office 2007 File Format MIME Types for HTTP Content Streaming
Summary Office 2007 introduced new file formats for common document types (Word documents, Excel spreadsheets, and PowerPoint presentations), and has standardized on new MIME types for each new...
PHP: explode() or split()?
Actually explode() isn’t the same as split(). The biggest difference is that explode() takes in parameters a delimiter to split by, while split() takes a regular expression. This means that...
CSS Word-Wrap
This property specifies whether the current rendered line should break if the content exceeds the boundary of the specified rendering box for an element (this is similar in some ways to the...
jsFiddle
JsFiddle is a playground for web developers, a tool which may be used in many ways. One can use it as an online editor for snippets build from HTML, CSS and JavaScript. The code can then be shared...