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;
?>
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>";
}
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
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!
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();
$exclude = array("");
foreach ($myItems as $item)
{
if (!in_array(serialize($item->fileName) ,$exclude))
{
$new[] = $item;
array_push($exclude, serialize($item->fileName));
}
}
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>
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
| format |
Description |
Example returned values |
| Day |
— |
— |
| %a |
An abbreviated textual representation of the day |
Sun through Sat |
| %A |
A full textual representation of the day |
Sunday through Saturday |
| %d |
Two-digit day of the month (with leading zeros) |
01 to 31 |
| %e |
Day of the month, with a space preceeding single digits |
1 to 31 |
| %j |
Day of the year, 3 digits with leading zeros |
001 to 366 |
| %u |
ISO-8601 numeric representation of the day of the week |
1 (for Monday) though 7 (for Sunday) |
| %w |
Numeric representation of the day of the week |
0 (for Sunday) through 6 (for Saturday) |
| Week |
— |
— |
| %U |
Week number of the given year, starting with the the first Sunday as the first week |
13 (for the 13th full week of the year) |
| %V |
ISO-8601:1988 week number of the given year, starting with the first week of the year with at least 4 weekdays, with Monday being the start of the week |
01 through 53 (where 53 accounts for an overlapping week) |
| %W |
A numeric representation of the week of the year, starting with the first Monday as the first week |
46 (for the 46th week of the year beginning with a Monday) |
| Month |
— |
— |
| %b |
Abbreviated month name, based on the locale |
Jan through Dec |
| %B |
Full month name, based on the locale |
January through December |
| %h |
Abbreviated month name, based on the locale (an alias of %b) |
Jan through Dec |
| %m |
Two digit representation of the month |
01 (for January) through 12 (for December) |
| Year |
— |
— |
| %C |
Two digit representation of the century (year divided by 100, truncated to an integer) |
19 for the 20th Century |
| %g |
Two digit representation of the year going by ISO-8601:1988 standards (see %V) |
Example: 09 for the week of January 6, 2009 |
| %G |
The full four-digit version of %g |
Example: 2008 for the week of January 3, 2009 |
| %y |
Two digit representation of the year |
Example: 09 for 2009, 79 for 1979 |
| %Y |
Four digit representation for the year |
Example: 2038 |
| Time |
— |
— |
| %H |
Two digit representation of the hour in 24-hour format |
00 through 23 |
| %I |
Two digit representation of the hour in 12-hour format |
01 through 12 |
| %l (lower-case ‘L’) |
Hour in 12-hour format, with a space preceeding single digits |
1 through 12 |
| %M |
Two digit representation of the minute |
00 through 59 |
| %p |
UPPER-CASE ‘AM’ or ‘PM’ based on the given time |
Example: AM for 00:31, PM for 22:23 |
| %P |
lower-case ‘am’ or ‘pm’ based on the given time |
Example: am for 00:31, pm for 22:23 |
| %r |
Same as “%I:%M:%S %p” |
Example: 09:34:17 PM for 21:34:17 |
| %R |
Same as “%H:%M” |
Example: 00:35 for 12:35 AM, 16:44 for 4:44 PM |
| %S |
Two digit representation of the second |
00 through 59 |
| %T |
Same as “%H:%M:%S” |
Example: 21:34:17 for 09:34:17 PM |
| %X |
Preferred time representation based on locale, without the date |
Example: 03:59:16 or 15:59:16 |
| %z |
Either the time zone offset from UTC or the abbreviation (depends on operating system) |
Example: -0500 or EST for Eastern Time |
| %Z |
The time zone offset/abbreviation option NOT given by %z (depends on operating system) |
Example: -0500 or EST for Eastern Time |
| Time and Date Stamps |
— |
— |
| %c |
Preferred date and time stamp based on local |
Example: Tue Feb 5 00:45:10 2009 for February 4, 2009 at 12:45:10 AM |
| %D |
Same as “%m/%d/%y” |
Example: 02/05/09 for February 5, 2009 |
| %F |
Same as “%y-%m-%d” (commonly used in database datestamps) |
Example: 2009-02-05 for February 5, 2009 |
| %s |
Unix Epoch Time timestamp (same as the time() function) |
Example: 305815200 for September 10, 1979 08:40:00 AM |
| %x |
Preferred date representation based on locale, without the time |
Example: 02/05/09 for February 5, 2009 |
| Miscellaneous |
— |
— |
| %n |
A newline character (“\n”) |
— |
| %t |
A Tab character (“\t”) |
— |
| %% |
A literal percentage character (“%”) |
— |
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();
}
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”);
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'];
}