Breathing Spring

How to add paging in Drupal

this article is taken from http://www.sononix.com/node/270 just placed here for reminder purposes

//This is numbers per page
$num_per_page = 5;

//actual query

$query = “SELECT n.nid, n.created FROM {node} n WHERE n.type = ‘halloffame’ AND n.status = 1 ORDER BY n.created DESC”;

//the count query should be similar to the query above
$count_query = “SELECT COUNT(*) AS row_count FROM {node} n WHERE n.type = ‘halloffame’ AND n.status = 1 ORDER BY n.created DESC”;

//pager_query function
$result = pager_query($query, $num_per_page, 0, $count_query, $user_load->uid);

//dont forget

while ($node = db_fetch_object($result)) {
$output .= node_view(node_load(array(‘nid’ => $node->nid)), 1);
}

$output .= theme(‘pager’, NULL, 5, 0);

print $output;

?>

Starting with SQLITE WITH PHP

First of all you need to make sure that the extension of sqlite is working through the settings in php.ini

Assuming its working, I will make it brief first create a file names create_database.php
And add the following to it


$db= new SQLiteDatabase("db.sqlite");
$db->query("
BEGIN;
CREATE TABLE users (id INTEGER UNSIGNED PRIMARY KEY,
name CHAR(255),
email CHAR(255));
INSERT INTO users (id,name,email) VALUES (NULL,'User1','user1@domain.com');
insert into users (id,name,email) values (NULL, 'user2','user2@lamis.com');
insert into users (id,name,email) values (NULL, 'user3','user3@lamis.com');
COMMIT;
");

This will create a new SQLiteDatabase and a table called users

now create another file call it test_result.php
and add the following to it

$db= new SQLiteDatabase("db.sqlite");
$result = $db->query("Select * from users");
echo "<br><br>++++++ POINTER WAY +++++++<br><br>";
while($result->valid())
{
print_r($result->current());
echo "<br>";
$result->next();
}
echo "<br><br>++++++ ASSOCIATIVE WITH FETCH+++++++<br><br>";
$result = $db->query("Select * from users");
while($row = $result->fetch(SQLITE_ASSOC))
{
print_r($row);
echo "<br>";
}
echo "<br><br>++++++ NUM WITH FETCH+++++++<br><br>";
$result = $db->query("Select * from users");
while($row = $result->fetch(SQLITE_NUM))
{
print_r($row);
echo "<br>";
}
echo "<br><br>++++++ FETCH ALL ++++++<br><br>";
$result = $db->query("Select * from users");
$rows= $result->fetchAll();
foreach($rows as $row)
{
print_r($row);
echo "<br>";
}
echo "<br><br>++++++ FETCH Object ++++++<br><br>";
$result = $db->query("Select * from users");
while($row = $result->fetchObject())
{
print_r($row);
echo "<br> you can call any like this \$row->id<br><br><br>";
}


using curl as post

First of all know this code work for something with no captcha

here how it goes

$url = "http://someurl.com";
$ch = curl_init();


The url is to specify the link for the post


// howmany parameter to post
curl_setopt($ch, CURLOPT_POST, 3);
// the parameter 'username' with its value 'johndoe'
curl_setopt($ch, CURLOPT_POSTFIELDS,"name=".$name."&username=".$username.."&email=".$email);
//TRUE to return the transfer as a string of the return value of curl_exec() instead of outputting it out directly.
curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
$result= curl_exec ($ch);
curl_close ($ch);


We can also add some settings which can be useful , for instance to ignore redirection in the url we can add

curl_setopt($ch,CURLOPT_FOLLOWLOCATION, true);


Here is a link of the set of the things we can add

http://ca3.php.net/manual/en/function.curl-setopt.php

access associative array in_array

so let me explain this
usually we have arrays like this

$my_array= new Array ("US","UK", "FR")
and to search for a value we do
if( in_array("FR", $my_array) )

the problem is when we have an associative array that has several values something like this

$my_array= new Array ("US"=>array(40,50) ,"UK"=>array(46,60) , "FR"=>array(70,50) );

now searching for FR wont be possible with the previous way

so what we do is simple easy add!

if(in_array("FR" ,array_keys($my_array)))

enjoy!

get unique value from XML array

this should work best as far as I know and tried..I used the serialize because oddly it couldnt compare strings

hope it maybe help someone there that needs it

$new=array();

foreach ($myItems as $item)
{
if (!in_array(serialize($item->fileName) ,$exclude))
{
$new[] = $item;
array_push($exclude, serialize($item->fileName));
}
}

div open close

a script that help open three divs only at times, a very good I even used it in joomla news in front page by modifying tempaltes/mytemplate/html/com_content/frontend

<script type=”text/javascript”><!–
function OpenDiv(id) {
var opened_divs = 0;
for (i=1;i<=5;i++) { // so you can add more than 2
var divname = ‘div’+i;
var divstyle = document.getElementById(divname).style;
if(divstyle.display == ‘block’) opened_divs++;
}
var state = document.getElementById(id).style;
if(state.display == ‘block’) {
state.display = ‘none’;
return;
}
else if (state.display == ‘none’){
if(opened_divs < 3) {
state.display = ‘block’;
return;
}
else {
for (j=3;j<=5;j++) {
var new_div = ‘div’+j;
if(document.getElementById(new_div).style.display == ‘block’ && new_div != id) {
document.getElementById(new_div).style.display = ‘none’
document.getElementById(id).style.display = ‘block’
return;
}
}
}
}
}
// –></script>
<div id=”alldivs”><!– all will probably confuse IE = see document.all –>
<a class=”gray” onclick=”OpenDiv(‘div1′);”>DIV 1</a>
<div id=”div1″ style=”display: block;”>Div 1</div>
<a class=”gray” onclick=”OpenDiv(‘div2′);”>DIV 2</a>
<div id=”div2″ style=”display: block;”>Div 2</div>
<a class=”gray” onclick=”OpenDiv(‘div3′);”>DIV 3</a>
<div id=”div3″ style=”display: block;”>Div 3</div>
<a class=”gray” onclick=”OpenDiv(‘div4′);”>DIV 4</a>
<div id=”div4″ style=”display: none;”>Div 4</div>
<a class=”gray” onclick=”OpenDiv(‘div5′);”>DIV 5</a>
<div id=”div5″ style=”display: none;”>Div 5</div>
</div>

JHTML DATE in joomla

with the help of the following PHP date table you can add JHTML date to your code
JHTML::Date($row->date, “%A, %d. %B %Y”);
if you are modifying news then $row->date would be $this->item->created

Wrong And Rights

Switch statements:
// Always assume that the case got not catched

// Wrong

switch ($mode)
{
	case 'mode1':
		// I am doing something here
		break;
	case 'mode2':
		// I am doing something completely different here
		break;
}

// Good

switch ($mode)
{
	case 'mode1':
		// I am doing something here
	break;

	case 'mode2':
		// I am doing something completely different here
	break;

	default:
		// Always assume that the case got not catched
	break;
}

Operations in loop definition:

// On every iteration the sizeof function is called

for ($i = 0; $i < sizeof($post_data); $i++)
{
	do_something();
}

// You are able to assign the (not changing) result within the loop itself

for ($i = 0, $size = sizeof($post_data); $i < $size; $i++)
{
	do_something();
}

root folder path in joomla

to get the root folder path in joomla you can put JPATH_ROOT
to get the folders separator DS
finally your statement should be like this :
require_once(JPATH_ROOT.DS.”thefileyouwanttoinclude.php”);

Stored Procedure and Fetching Result in PHP

ok I assume you know SQL server here now to create a procedure you to to

Stored Procedure-> New Stored Procedure

CREATE procedure dbo.NAME_OF_THE_PROCEDURE
@id int,
@name varchar(250)
As
select * dbo.TABLE_NAME
where
id=@id AND name like @name;
GO

the first two variables refer to the data we will send to the procedure, this will also work on insert.
to fetch the result in PHP first we need to connect PHP to SQL SERVER

$settings;
$db_host = "127.0.0.1"; //THE SQL SERVER IP so you can connect
$ser = "127.0.0.1"; //THE SQL SERVER IP so you can connect
$db_name = "DBNAME"; //DATABASE NAME TO CONNECT
$settings['db_user'] ="username_for_sql";
$settings['db_pass'] = "pass_for_sql";
$settings['dsn'] = "DRIVER={SQL SERVER};" .
"Server=$ser;".
"CommLinks=tcpip(Host=$db_host);" .
"DatabaseName=$db_name;" .
"uid=".$settings['db_user']."; pwd=".$settings['db_pass']."";
$connection=odbc_connect($settings['dsn'], $settings['db_user'] , $settings['db_pass'] ,SQL_CUR_USE_ODBC);


Now finally fetching the Select result (I added how to select Database though its not necessary and only needed if you are switching to another database at the same connection

odbc_exec($connection,"use other_db_name"); //only needed if you are switching database
$query="exec NAME_OF_THE_PROCEDURE 23,'name'"; //23 is the ID, and 'name' is the name
$result=odbc_exec($connection,$query); //result will return the one value fetched
while ($row= odbc_fetch_array($result))
{
$i++;
echo $row['anything1'].$row['someotherfeild'];
}