There are lots of ways to select a random record or row from a database table.Here are some example SQL statements that don't require additional application logic,but each database server requires different SQL syntax.Select a random row with MySQL:Select ...
I am using CentOS Linux for service purpose. Main reason to use CentOS is cheaper hosting for private purpose. Actually MySQL requires periodical optimization process in my experiences, and I use / etc / cron.hourly usually for those kind of bath processi...
I am using Virtual Private Hosting service, and I found that my server has some problem as below. As you can see the CPU occupation rate is more than 300%. So my server response speed is the most slower than I had experiences before. I had read some articl...
Below bash script is for installing gcc 4.9.4 in CentOS 7. For your information,you should have sudo permission to install the above.
STEP 1.Install Let’s Encrypt Certbot Tool.Before you can create free wildcard certificates,you need certbot installed.I’m using an CentOS Server here.To install it,run the following commands: .STEP 2.Generate Let’s Encrypt Wildcard SSL Certificate.After...
In order to mount windows shared folder on CentOS, you need to install some packages like belowAnd the easiest way can mount the folder you want will be like belowIn case that you encounter error message like “mount error(12): Cannot allocate memory to th...
On Centos 6.7,you can check IP address configuration by ifconfig command as below: .The below is the example of files on " / etc / sysconfig / network-scripts". Among above,ifcfg-eth0 and ifcfg-eth1 is wired network,and below is the reference example: .If ...
If you installed Centos in minial installation mode, you should install Apache + PHP + MySQL manually.The followings are the procedure to install Apache + PHP + MySQL:Making apache and mysql to start automatically
The software utility Cron is a time-based job scheduler in Unix-like computer operating systems. People who set up and maintain software environments use cron to schedule jobs (commands or shell scripts) to run periodically at fixed times, dates, or interv...
“mcrypt” is an interface to the mcrypt library, which supports a wide variety of block algorithms such as DES, TripleDES, Blowfish (default), 3-WAY, SAFER-SK64, SAFER-SK128, TWOFISH, TEA, RC2 and GOST in CBC, OFB, CFB and ECB cipher modes. Additionally, ...
When using OAuth 1.0a, it requires timestamp for authentication. The followings are the example of shell commands which can set time information. Setup timezoneTo set the timezone of your system clock do the following:# rm -rf / etc / localtime# ln -...
I am using CentOS with php, and mysql for web service, and sometimes my server is dead by unknown reason so I optimize mysql database and restart web server manually. Following is the first my / etc / cron.hourly / optimze process for seamless servic...
Following code converts EUC-KR format document to UTF8. utfconvert.sh.
edit the file / etc / my.cnfThe file should look like this:Increase 100,000 to the number you desire.After the setting is applied, you should restart your database.
Generate a random number using mt_rand.From the php documentation- "If called without the optional min,max arguments mt_rand() returns a pseudo-random value between 0 and RAND_MAX.If you want a random number between 5 and 15 (inclusive),for example,use mt_...
This commands disables php from rewriting URLs to add a phpsessid, and forces the use of cookie sessions instead. Using cookies is largely thought of as the preferred way to use sessions - both more secure and better for SEO. This can be accomplished by se...
This example shows a very simple form together with the form handling process on a single page. Below is another approach based on Heredoc I like:
Grabs the referring URL - get the HTTP_REFERER and save it to a variable. code snippet: .While not inherently intended for API security,the HTTP_REFERER header can be a valuable tool for implementing an API that restricts access to certain resources based ...
Whatever the formatted string is,strtotime() function convert the formatted date time string to datetime.Following example shows the simple reference can convert date time string whatever the formatted input is.
PHP provides the alternate function which can control time limit that defined in php.ini. Following is the alternate function can control time limit.void set_time_limit (int seconds);Set the number of seconds a script is allowed to run. If this is reached,...
The time () function generates a long string of numbers representing how many seconds have passed since January 1, 1970. It is possible to add and subtract time by adding and subtracting seconds.
The three most basic searches using regular expressions are searching for the strings start, the strings end, or for characters it contains. We can do these using the following symbols:^ indicates the string starts with the specified characters, so "^strcp...
This source code describes how to send email with php with headers .
This code prints array count values
See below as calculator with basic four functions.
In this article we'll make number format like 0001, 0002, 0003 in stead of 1, 2 ,3. It's very easy to do this for your counter, category or product ID. etc.
This basically randomly pick a number between the min and max values. This is made because the rand() and mt_rand() function can not accept numbers larger than 2^31 or 2^63,depend on your processor and complier.
Encryption and password account accessFunction AccountCryptPassword($password,$salt) { if($salt=="") { srand(time()); $random=rand(); $itoa64=". / 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"; ...
This php based script will find numbers and give them a cardinal ending.This can be useful for displaying rankings or results of a competition.The script is easy to install and use .Explanation::addOrdinalSuffix($number): This function adds the appropriate...
URL Rewriter PHP is a short code that can be used to rewrite dynamic PHP urls as URL's that link to static htmlpages.Increases search engine rankings by creating a static system of page linking as well as making all content available. Associated Data for U...