Apache uptime: [code language=”php”] httpd fullstatus | grep uptime [/code] Server uptime: 4 hours 25 minutes 7 seconds MySQL uptime: [code language=”php”] mysqladmin version | grep Uptime [/code] Uptime: 1 hour 26 min 5 sec
Step #1: Install nginx repo Type the following wget command to install nginx yum configuration file: [code language=”php”] # cd /tmp [/code] CentOS Linux v6.x user type the following command: [code language=”php”] # wget http://nginx.org/packages/centos/6/noarch/RPMS/nginx-release-centos-6-0.el6.ngx.noarch.rpm # rpm -ivh nginx-release-centos-6-0.el6.ngx.noarch.rpm [/code] Step #2: Install nginx web-server Type the following yum command to install nginx web-server: [code…
[code language=”javascript”] $(".submit").click(function (){ var fname = $(this).val(); var dataString = ‘fname=’+ fname; $.ajax({ type: "POST", url: "addtodb.php", data: dataString, success: function(){ $(‘.successk’).fadeIn().show(); } }); return answer; }); [/code]
[code language=”sql”] mysqlcheck –auto-repair –check -u username -p dbpassword [/code]
[code language=”php”] $result = mysql_query("SHOW TABLE STATUS LIKE ‘".$table_name."’ "); $row = mysql_fetch_array($result); $next_id = $row[‘Auto_increment’]; [/code]
[code language=”sql”] SELECT city, COUNT(id) AS id FROM YourTable GROUP BY city HAVING COUNT(id) > 3 [/code]
Remove everything after last slash [code language=”php”] $string = ‘AAA/BBB/CCC’; echo preg_replace(‘#[^/]*$#’, ”, $string); [/code] Output: AAA/BBB/ Remove everything after last slash including last slash [code language=”php”] $string = ‘AAA/BBB/CCC’; echo preg_replace(‘#\/[^/]*$#’, ”, $string); [/code] Output: AAA/BBB
[code language=”php”] $str ="AAA/BBB/CCC"; $output = preg_replace(‘/(\/.*)/’, ”, $str); echo $output; [/code] Output: AAA
String Encryption [code language=”php”] $string = "Some String to encrypted"; $key = "secretscode"; $cipher_alg = MCRYPT_RIJNDAEL_128; $iv = mcrypt_create_iv(mcrypt_get_iv_size($cipher_alg, MCRYPT_MODE_ECB), MCRYPT_RAND); $encrypted_string = mcrypt_encrypt($cipher_alg, $key, $string, MCRYPT_MODE_CBC, $iv); print "Encrypted string: ".bin2hex($encrypted_string)." "; [/code] Encrypted string: b7634f7632625ce353d651a771a49c6b308f8c8e7bd2d96a224837f7c65b3ac2 String Decryption [code language=”php”] $decrypted_string = mcrypt_decrypt($cipher_alg, $key, $encrypted_string, MCRYPT_MODE_CBC, $iv); print "Decrypted string: $decrypted_string"; [/code] Decrypted string:…
[code language=”php”] $url = parse_url(‘http://google.com’); $http = curl_init($url); $result = curl_exec($http); $http_status = curl_getinfo($http, CURLINFO_HTTP_CODE); echo $http_status; [/code]