Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,199,854 members, 7,972,981 topics. Date: Saturday, 12 October 2024 at 02:21 AM

Djynnius's Posts

Nairaland Forum / Djynnius's Profile / Djynnius's Posts

(1) (of 1 pages)

NYSC / Re: Monthly Budget Of A Youth Corper Serving In The North by djynnius(m): 9:55pm On Jun 18, 2021
Quite impressive, dude earns $74 a month, saves $28 after spending $46 meaning she lives on $1.53 a day. And he/she doesn't tithe, nor does he/she give offerings [I am assuming he/she is Christian]... BTW by UN definition, he/she is living in extreme poverty. No analysis just stating the facts of the statement. My unbiased, unprejudiced POV.

3 Likes

Programming / Re: Pagination by djynnius(m): 3:57am On Jun 28, 2012
My contribution to you. take a look at the function below and hopefully it should help

/*function taking arguments for databse table, 
number of results you wish to display set to a default of 10 and
the current page you are viewing*/
function pagination($table, $num_of_results = 10, $current_page = 1){
/*connection string.*/
/*dont forget to enter the appropriate login credentials and database name.*/
$connect = mysql_connect(localhost, dba_username, dba_password);
$db = mysql_select_db(db_name, $connect);

/*check to see if the page id is set in the url*/
$current_page = (isset($_GET['pid'])) ? $_GET['pid'] : 1;

/*setting url for controls so you dont have to bother about the current url in using the function*/
$page_url = $_SERVER['REQUEST_URI'];
$page_url = explode("?", $page_url);
$page_url = $page_url[0];

/*querry to count all results*/
$sql = "select id from ".$table;
$query = mysql_query($sql);
$total_result_count = mysql_num_rows($query);

/*offset being what number the querry results should begin from to count the set number of results*/
$offset = ($current_page - 1)*$num_of_results;

/*querry to return desired results*/
$sql = "select * from $table limit $offset, $num_of_results";
$query = mysql_query($sql);

/*page controls*/
$p = 1;
$page_num = ceil($total_result_count/$num_of_results); //returns a rounded up value for number of expected pages
if(isset($_GET['pid']) and $_GET['pid'] != 1){
$page_ctrl = "<a href='".$page_url."?pid=".($_GET['pid'] - 1)."'>Previous</a> | ";
} else {
$page_ctrl = "Previous | ";
}
while($p <= $page_num){
$page_ctrl .= "<a href='".$page_url."?pid=".$p."'>".$p."</a>| ";
$p++;
}
if(isset($_GET['pid']) and $_GET['pid'] != $page_num){
$page_ctrl .= "<a href='".$page_url."?pid=".($_GET['pid'] + 1)."'>Next</a> ";
} else {
$page_ctrl .= "Next ";
}
echo $page_ctrl;


/*begin results table*/
echo "<table id='paginated'>"; //usually smart to give the table an id so you can style it later
echo "<tr><thead><tr><th>SN</th><th>ID</th><th>Other Columns</th></tr></thead></tr>";

$i = ($offset + 1);
while($result = mysql_fetch_assoc($query)){
/*dont forget to use the appropriate table names*/
echo "<tr><td>".$i."</td><td>{$result['id']}</td><td>{$result['subject']}</td></tr>";
$i++;
}
echo "</table>";

echo $page_ctrl;

mysql_close();
}



/*to test simply run the function as below replacing the argument with a valid table name*/
pagination("table_name"wink;
Sports / Re: Eguavoen To Assist Lagerback by djynnius(m): 9:42am On Feb 27, 2010
I keep thinking to myself: what ever happened to Samson Siasia? Now we have a world class shoe shiner! Sia One took the Nigerian boys to the finals in 1995 and lost to the Argrntines in the finals, took the remnant of that team to the finals of the subsequent olympics and lost in the finals to the same Argentina, now Batista and Sia One are outta contention for the world cup but Chile was smart enough to take a coach who almost stole the number one spot for south america in the world cup qualifiers.

Look out for Chile in the world cup,
Sports / Re: Am No More A Man Utd Fan by djynnius(m): 2:43pm On Aug 22, 2007
na true oh! after liverpool win lig this season we go get fans everywhere like arsenal man u and chelsea. the one dat beats me is where all em chelsea fans came from folks who never heard of torre andre flo!
Sports / Re: Am No More A Man Utd Fan by djynnius(m): 12:51pm On Aug 21, 2007
no need to decamp. i recall wen i started supportin liverpool, men the yabis wey follow me eh! it was not easy, then came th 2005 champions lig finals, calls and txt mesages nearly kill me, how ac milan go carry liverpool scrub ground, and my fone rang some more after the 1st half!

but man i had the last brag that day. lig hust start and personally if u ask me to predict i still think man u will finish second after liverpool!

check out the www.calabaronline.com poll on who will posibly win the premiership this season. and vote too!
European Football (EPL, UEFA, La Liga) / Re: You'll Never Walk Alone! by djynnius(m): 2:39pm On Jul 09, 2007
well its bin eons since we last won a lig title! i saw a team i thot was the complete team play last season 4 liverpool and now it seems even more complete i hope it can b the first time inalong time dat we win the lig. wot do u think our chances r?
European Football (EPL, UEFA, La Liga) / You'll Never Walk Alone! by djynnius(m): 1:13pm On Jul 07, 2007
Liverpool FC was almost complete last season just there was a problem upfront,  the keeper the envy of the world the man stops penalties better than dudek! knows how to go 4 that ball an all. the back 4 carrager (fantastic), Risse (wow!), finan (the unsung hero), Agger (the boy to watch) and possibly G. Heinze from man u; now heres my fun part the midfield i dare say the best in europe! Alonso-Gerrard, Sissoko-maccerano, kewel-pennant, lucal(the nu kid!), the problem anyone would have identified with such a stingy defence and a great midfield causin a fantastic home record would be the lack of a 20goals a season striker.

Enter Torrez! the 18-19 goals a season striker from Athletico madrid who had to play infromt of a mediocre midfield, what does all this spell? the firt treble in a series for LFC!!!

We never walk alone!

(1) (of 1 pages)

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 24
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.