PHP « Knowledge Base

Articles in the ‘PHP’ Category

How to add MSSQL support in PHP5 cPanel CENTOS

Thursday, June 2nd, 2011

If you want to add MSSQL support in PHP5 cPanel CENTOS, follow the next steps:

1. First, we need to install FreeTDS
wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz tar -zxvf freetds-stable.tgz cd freetds-*

2. Begin the configuration process:
./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --enable-msdblib --enable-dbmfix --with-gnu-ld

Note
Use tdsver=8.0 if you have SQL 2000/2005, tdsver=7.0 if you have SQL 7.0….

3. Compile FreeTDS
make && make install

4. Add the following line in the file /etc/ld.so.conf :
include /usr/local/freetds/lib

5. Run the following command
ldconfig -v

6. Add mssql to compile options of EasyApache
nano /var/cpanel/easy/apache/rawopts/all_php5
and add:
--with-mssql=/usr/local/freetds

7. Run /scripts/easyapache or build it from WHM. You don’t need to select any additional options here. Just build it. Once the build completes, you should now be able to use PHP’s MSSQL connector functions.

Note
If you are running a 64bit OS and get an error about configure: error:
Could not find /usr/local/freetds/lib64/libsybdb.a|so
then you need to do the following:

ln -s /usr/local/freetds/lib/libsybdb.so.5 /usr/lib64/libsybdb.so.5 ln -s /usr/local/freetds/lib/libsybdb.so.5 /usr/local/freetds/lib64/libsybdb.so ldconfig -v

Written by Adrian Pintilie Tags: centos, cPanel, mssql, php
Posted in Apache, cPanel, PHP | No Comments »

How to install PECL uploadprogress for Drupal?

Friday, December 17th, 2010

Installing from cPanel will mostly sure fail. If you want a quick fix, here is how to do it.

Download the latest uploadprogress package from here
wget http://pecl.php.net/get/uploadprogress-1.0.1.tgz tar xvfz uploadprogress-1.0.1.tgz cd uploadprogress-1.0.1 phpize ./configure make make install
Edit /usr/local/lib/php.ini
nano /usr/local/lib/php.ini
and copy paste at the end of the file:
extension=uploadprogress.so
and at last, restart Apache:
service httpd restart

Written by Adrian Pintilie Posted in cPanel, PHP | No Comments »

How to install Memcache in cPanel?

Tuesday, September 28th, 2010

Take a coffee, this is going to be a long process.

Step 1: Configure Apache
Login to cPanel and start EasyApache. At the Exhaustive Option List choose Memcache. Compile Apache & Restart it.

Step 2: Memcache requires LibEvent
LibEvent can be downloaded from Monkey.org. Download the last 1.4.x available version.
wget http://monkey.org/~provos/libevent-1.4.14b-stable.tar.gz tar xvfz libevent-1.4.14b-stable.tar.gz cd libevent-1.4.14b-stable ./configure; make; make install

Step 3: Register LibEvent
nano /etc/ld.so.conf.d/libevent-i386.conf
Add the following text inside:
/usr/local/lib/
and at last, run:
ldconfig

Step 4: Compile and install Memcache (deamon)
Now you can install Memcache with the last version from their site.
wget http://memcached.googlecode.com/files/memcached-1.4.5.tar.gz tar xvfz memcached-1.4.5.tar.gz cd memcached-1.4.5 ./configure; make; make install

Step 5: Install PHP extension for Memcache
Normall, you should be able to do this from cPanel but i get a compiling error. So here is an alternative:
wget http://pecl.php.net/get/memcache-3.0.3.tgz tar xvfz memcache-3.0.3.tgz cd memcache-3.0.3 phpize ./configure make make install
Edit /usr/local/lib/php.ini
nano /usr/local/lib/php.ini
and copy paste at the end of the file:
extension=memcache.so
and at last, restart Apache:
service httpd restart

Step 6: Run Memcache as a deamon on the startup files
nano /etc/memcached.conf
and add inside:
#Memory a usar -m 16 # default port -p 11211 # user to run daemon nobody/apache/www-data -u nobody # only listen locally -l 127.0.0.1
create the startup files
touch /etc/init.d/memcached chmod +x /etc/init.d/memcached
and add inside it
nano /etc/init.d/memcached
the following text

then run:
touch /usr/local/bin/start-memcached chmod +x /usr/local/bin/start-memcached
and add inside the following text

Now, let’s test the scripts:
/etc/init.d/memcached restart
and review if the conf file is parsed ok:
ps aux | grep memcached
and last, add memcached as autostart deamon
/sbin/chkconfig memcached on /sbin/chkconfig --list | grep memcached
it should output:
memcached 0:off 1:off 2:on 3:on 4:on 5:on 6:off

Step 7: Test Memcache in PHP
Create the memcache.php file and add this text
You should have in the browser:
String to store in memcached.

Written by Adrian Pintilie Tags: Apache, cPanel, memcache
Posted in Apache, cPanel, Linux, PHP | 1 Comment »

How to properly save diacritics in MySQL database

Wednesday, January 27th, 2010

To save diacritics in a MySQL database you have 5 steps to follow:

1. Set(create) your database with collation utf8_general_ci;

2. Set(create) your table with utf8_general_ci collation also;

3. Make sure the text fields where you’ll insert diacritics have also the utf8_general_ci collation

4. Convert your string into ‘utf-8′ using any method you like. I recommend using PHP’s multibyte functions

e.g. $my_string = mb_convert_encoding($txt, $charset, mb_detect_encoding($my_string));

where: $my_string is the string that will be inserted

$charset is thecharset where your diacritics are included.

Check also here the Complete list of Popular character encodings

5. Before the insert query execute this query SET NAMES latin2; (if your diacritics are from one of the latin charsets)

Written by Ionut Stan Tags: charset, diacritics, multibyte, MySQL, php, string
Posted in Drupal, MySQL, PHP, Uncategorized | No Comments »

How to detect mobile platforms with PHP?

Friday, October 23rd, 2009

If you seek to detect mobile platforms with PHP you can try the following class:

http://code.google.com/p/php-mobile-detect/

Written by Adrian Pintilie Tags: mobile, php
Posted in PHP | No Comments »

Generating a random serial in php

Thursday, July 23rd, 2009

Here is the code

<?php

function generateSerial($nr, $lenght)
{
$code=”;
for ($i=1;$i<=$nr;$i++)
{
$code = $code.substr(strtoupper(md5(uniqid(rand(), true))), 0, $lenght).’-';
}

return substr($code, 0, strlen($code)-1);

}

echo generateSerial(4,5);

?>

Written by Petrica Danila Tags: generate, php, serial
Posted in PHP | No Comments »

Knowledge Base