php_mysql | Karlosp.net

Selecting the most common value from relation

October 7th, 2011 karlosp No comments

MySQL:

SELECT `keyword`, count(`keyword`)<br />
FROM data<br />
GROUP BY `keyword`<br />
ORDER BY count(`keyword`) desc LIMIT 100, 200

Categories: php_mysql Tags:

PHP & JavaScript -> XML communication

January 26th, 2010 karlosp No comments

PLAIN TEXT
PHP:




function unicode_urldecode($url) {


    preg_match_all(&#39;/%u([[:alnum:]]{4})/&#39;, $url, $a);


 


    foreach ($a[1] as $uniord) {


       $utf = &#39;&amp;#x&#39; . $uniord . &#39;;&#39;;


       $url = str_replace(&#39;%u&#39;.$uniord, $utf, $url);


    }    


    return urldecode($url);


}

Usage:

PLAIN TEXT

PHP:

$content = unicode_urldecode($_GET['content']);

Categories: php_mysql Tags:

UTF-8 and apache – mysql – php

December 16th, 2009 karlosp No comments

Settings a LAMP server to work in full unicode UTF-8 :

httpd.conf:

PLAIN TEXT

CODE:

AddCharset UTF-8 .utf8
AddDefaultCharset UTF-8

php.ini

PLAIN TEXT

CODE:

default_charset = "utf-8"

my.cnf

PLAIN TEXT

CODE:

character-set-server=utf8 default-collation=utf8_unicode_ci

In all your PHP scripts :

PLAIN TEXT

CODE:

mysql_query("SET NAMES &apos;utf8&apos;;",$con);

Importing database :

PLAIN TEXT

CODE:

mysql -h host -u username -p password --default_character_set utf8 database <file.sql

Dont forget to add UTF-8 in the head of all your HTML files :

PLAIN TEXT

CODE:

<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>

Categories: php_mysql Tags:

Tutorial: Create a zip file from folders on the fly | Web Development Blog

October 22nd, 2009 karlosp No comments

exec(’zip -r test.zip your_folder/’);

via Tutorial: Create a zip file from folders on the fly | Web Development Blog.

Categories: php_mysql Tags:

PHP post without cUrl

August 29th, 2009 karlosp No comments

PLAIN TEXT

PHP:

<?php
$postdata = http_build_query(
array(
'var1' => 'some content',
'var2' => 'doh'
)
);
$opts = array('http' =>
array(
'method' => 'POST',
'header' => 'Content-type: application/x-www-form-urlencoded',
'content' => $postdata
)
);
$context = stream_context_create($opts);
$result = file_get_contents('http://example.com/submit.php', false, $context);
?>

Categories: php_mysql Tags:

Asynchronous HTTP request in PHP

August 21st, 2009 karlosp No comments

PLAIN TEXT

PHP:

function curl_post_async($url, $params)
{
foreach ($params as $key => &$val) {
if (is_array($val)) $val = implode(',', $val);
$post_params[] = $key.'='.urlencode($val);
}
$post_string = implode('&', $post_params);
$parts=parse_url($url);
$fp = fsockopen($parts['host'],
isset($parts['port'])?$parts['port']:80,
$errno, $errstr, 30);
pete_assert(($fp!=0), "Couldn't open a socket to ".$url." (".$errstr.")");
$out = "POST ".$parts['path']." HTTP/1.1\r\n";
$out.= "Host: ".$parts['host']."\r\n";
$out.= "Content-Type: application/x-www-form-urlencoded\r\n";
$out.= "Content-Length: ".strlen($post_string)."\r\n";
$out.= "Connection: Close\r\n\r\n";
if (isset($post_string)) $out.= $post_string;
fwrite($fp, $out);
fclose($fp);
}

Categories: php_mysql Tags:

Joomla send email with PHP

August 16th, 2009 karlosp 1 comment

PLAIN TEXT

PHP:

<?php
define( '_JEXEC', 1 );
define('JPATH_BASE', dirname(__FILE__) );
define( 'DS', DIRECTORY_SEPARATOR );
require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' );
require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' );
$message =& JFactory::getMailer();
$message->addRecipient("example@gmail.com");
$message->setSubject('Your subject string');
$message->setBody("Your body string\nin double quotes if you want to parse the \nnewlines etc");
$sender = array( 'sender@email.address.org', 'Sender Name' );
$message->setSender($sender);
$message->addAttachment('htaccess.txt');
$sent = $message->send();
if ($sent != 1) echo 'Error sending email';
else
echo "OK";
?>

Categories: php_mysql Tags:

PHP XML traversing

August 3rd, 2009 karlosp No comments

PLAIN TEXT

PHP:

function parse_account_list($xml)
{
$doc = new DOMDocument();
$doc->loadXML($xml);
$entries = $doc->getElementsByTagName('entry');
$i = 0;
$profiles = array();
foreach($entries as $entry)
{
$profiles[$i] = array();
$title = $entry->getElementsByTagName('title');
$profiles[$i]["title"] = $title->item(0)->nodeValue;
$entryid = $entry->getElementsByTagName('id');
$profiles[$i]["entryid"] = $entryid->item(0)->nodeValue;
$properties = $entry->getElementsByTagName('property');
foreach($properties as $property)
{
if (strcmp($property->getAttribute('name'), 'ga:accountId') == 0)
$profiles[$i]["accountId"] = $property->getAttribute('value');
if (strcmp($property->getAttribute('name'), 'ga:accountName') == 0)
$profiles[$i]["accountName"] = $property->getAttribute('value');
if (strcmp($property->getAttribute('name'), 'ga:profileId') == 0)
$profiles[$i]["profileId"] = $property->getAttribute('value');
if (strcmp($property->getAttribute('name'), 'ga:webPropertyId') == 0)
$profiles[$i]["webPropertyId"] = $property->getAttribute('value');
}
$tableId = $entry->getElementsByTagName('tableId');
$profiles[$i]["tableId"] = $tableId->item(0)->nodeValue;
$i++;
}
return $profiles;
}

Categories: php_mysql Tags:

MySQL insert date

June 7th, 2009 karlosp No comments

PLAIN TEXT

PHP:

$add2h = time() + (7 * 60 * 60);
$dt=date("Y-m-d H:i:s", $add2h);
$time = $dt;
$query = "INSERT INTO slovarji (id, language, geslo, time)
VALUES ('', '$language', '$geslo', '$time')";
$results = mysql_query($query) or die
("Could not execute query : $query." . mysql_error());

Categories: php_mysql Tags:

PHP mail() UTF-8

March 17th, 2009 karlosp No comments

PLAIN TEXT

PHP:

function mail_utf8($from, $to, $subject = '(No subject)', $message = '', $header = '') {
$header_ = 'MIME-Version: 1.0' . "\r\n" . 'Content-type: text/html; charset=UTF-8' . "\r\n";
$header_ .= "From: $from\r\n" . "Reply-To: $from\r\n";
mail($to, "=?UTF-8?B?".base64_encode($subject).'?=', $message, $header_ . $header);
}

Categories: php_mysql Tags: mail, php, utf-8

Mysql php generator

February 20th, 2009 karlosp No comments

http://www.turningturnip.co.uk/free-mysql-php-generator/

Categories: php_mysql Tags:

MySql date timezone

November 6th, 2008 karlosp No comments

Knowing the time offset, you can replace all your SQL statements of

PLAIN TEXT

SQL:

SELECT NOW();

with

PLAIN TEXT

SQL:

SELECT DATE_ADD(NOW(), INTERVAL 2 HOUR);

Categories: php_mysql Tags:

PHP date compare

October 26th, 2008 karlosp No comments

PLAIN TEXT

PHP:

$exp_date = "2006-01-16";
$todays_date = date("Y-m-d");
$today = strtotime($todays_date);
$expiration_date = strtotime($exp_date);
if ($expiration_date> $today)
{ $valid = "yes";
}
else { $valid = "no"; }

Categories: php_mysql Tags:

Karlosp.net

Archive

Selecting the most common value from relation

PHP & JavaScript -> XML communication

UTF-8 and apache – mysql – php

Tutorial: Create a zip file from folders on the fly | Web Development Blog

PHP post without cUrl

Asynchronous HTTP request in PHP

Joomla send email with PHP

PHP XML traversing

MySQL insert date

PHP mail() UTF-8

Mysql php generator

MySql date timezone

PHP date compare

Išči

Categories

Archives

Meta