Linux, Apache, MySQL, PHP

Re: paging like linkedin & facebook

22-Dec-11 22:04

I would like to ask how can i page my result from mysql just like linkedin and facebook where there is a MORE button whsn user click on it will display the more results?

Mohibur Rashid23-Dec-11 2:29

Mohibur Rashid

23-Dec-11 2:29

Take a look at the mysql query with limit

here is two example
First list

SQL

SELECT Something FROM Somewhere where EveryOne LIKE 'SomeOne' LIMIT 0, 30

and when you populate go for:

SQL

SELECT Something FROM SomeWhere where EveryOne LIKE 'SomeOne' LIMIT 30, 30

In the first query you will get first 30 results,
In the second query you will get second 30 results

And you will also have to look at AJAX. Otherwise you will have to reload the entire page everytime

I Want a project using Global.asax file

RashdSiddique22-Dec-11 1:31

RashdSiddique

22-Dec-11 1:31

As mentioned in the above subject please provide me a project using using global.asax file so i can understand the concept of the same.

Please do the needfull.
Thanks and regards.

Re: I Want a project using Global.asax file

Kevin Schaefer3-Jan-12 12:13

Kevin Schaefer

3-Jan-12 12:13

Global.asax files are used with ASP.Net applications, not PHP. You should post in that forum instead. PHP applications can do similar things, however, if you do something like:
<pre lang="PHP">

There really isn't a direct analog for the global.asax file in php.

detect client language

Jassim Rahma21-Dec-11 19:58

21-Dec-11 19:58

I want to know how can I detect the client language so if it's arabic then leave it as www.mydomain.com but if it's english then redirect to www.mydomain.com/en?

Graham Breach21-Dec-11 21:03

Graham Breach

21-Dec-11 21:03

If the user's browser is set up properly, you can use $_SERVER['HTTP_ACCEPT_LANGUAGE'] to find out which languages they prefer to use.

Jassim Rahma22-Dec-11 0:06

22-Dec-11 0:06

does PHP has global file similar to the global or config files in ASP.NET or I should add the language check in every php file in my website?

Graham Breach22-Dec-11 2:41

Graham Breach

22-Dec-11 2:41

No, you would normally put anything you need to use on multiple pages into an include file, then load it on every page using include, require, include_once or require_once.

... unless you are using a framework, then there should be somewhere already that you can put code to execute on each request - but that will depend on the framework.

Or you could possibly skip checking it in PHP at all, and use a .htaccess file to redirect to a different path depending on the Accept-Language header.

jan lucas22-Dec-11 1:04

jan lucas

22-Dec-11 1:04

when I check $_SERVER['HTTP_ACCEPT_LANGUAGE'] on Chrome it gives: "en-GB,en;q=0.8"
any idea what "q=0.8" means?

My logic is impeccable; my arithmetic lets me down.

Luc Pattyn22-Dec-11 2:06

Luc Pattyn

22-Dec-11 2:06

It means Microsoft estimates your command of the English language is 80%, which is pretty good actually. More here[^]

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

jan lucas22-Dec-11 2:23

jan lucas

22-Dec-11 2:23

Luc Pattyn wrote:
It means Microsoft estimates your command of the English language is 80%

Microsoft? Surely it must be Google Chrome who made the estimate?
...and how does it (dare it!) make that estimate?!?

My logic is impeccable; my arithmetic lets me down.

Luc Pattyn22-Dec-11 2:35

Luc Pattyn

22-Dec-11 2:35

You never have tried Google Translate, have you? Google knows zilch about languages.

Big Grin | :-D

Luc Pattyn [My Articles] Nil Volentibus Arduum

Avinashwli23-Dec-11 0:41

Avinashwli

23-Dec-11 0:41

You can redirect using user's timezone also..

paging the result

Jassim Rahma20-Dec-11 3:29

best way to determine mobile device

20-Dec-11 3:29

Hi,

I am currentlly using this code to populate news from my database. I want to know how can I make the same paging the result with NEXT and PREVIOUS button?

PHP

<?php
    $conn = mysql_connect('mysql.jassimrahma.com', 'jassimxxxxx', 'xxxxxxx');
    mysql_select_db("jassimrahma", $conn);
    $result = mysql_query("SELECT news_id, news_title, date_format(created_date, '%d %M %Y') as 'news_date' FROM news ORDER BY created_date DESC, news_id DESC", $conn);

    $affected_rows = mysql_num_rows($result);

    echo "<table width='100%' cellpadding='3' cellspacing='3'>";

    while ($i < $affected_rows)
    {
        $news_id = mysql_result($result, $i ,"news_id");
        $news_title = mysql_result($result, $i ,"news_title");
        $created_date = mysql_result($result, $i ,"news_date");

        echo "<tr>";
        echo "<td align='center' valign='top'>";
        echo "<img src='http://www.jassimrahma.com/images/news_arrow.jpg' alt='Jassim.com News' />";
        echo "</td>";
        echo "<td align='left' valign='top'>";
        echo "<a href='http://www.JassimRahma.com/$news_id' target='_blank'>$news_title</a>";
        echo "</td>";
        echo "</tr>";

        $i++;
    }

    echo "<tr><td align='center' valign='top'></td><td align='left' valign='top'><a href='http://www.JassimRahma.com/news' target='_self'><img src='images/more_news.jpg' alt='Technology News - JassimRahma.com' /></a></td></tr>";
    echo "</table>";
?>

Re: paging the result

Mohibur Rashid20-Dec-11 21:53

Mohibur Rashid

20-Dec-11 21:53

try the link. It might help you

Jassim Rahma19-Dec-11 0:24

19-Dec-11 0:24

Hi,

What's the best way to determine the mobile device then redirect to the /mobile?

Regards,
Jassim

User 171649219-Dec-11 0:57

User 1716492

19-Dec-11 0:57

As a start, read these, they should help you ...

http://webdesignerwall.com/tutorials/css3-media-queries[^]

http://webdesignerwall.com/tutorials/responsive-design-with-css3-media-queries[^]

then, if necessary, do some Googling and further reading.

[added]

You could have accepted Graham's answer in the Web Dev forum

modified 1-Aug-19 21:02pm.

Mohibur Rashid19-Dec-11 18:00

Mohibur Rashid

19-Dec-11 18:00

Detecting if its a mobile device

Please follow the above link. It looks good

Jassim Rahma19-Dec-11 21:43

19-Dec-11 21:43

Detecting if its a mobile device
 
Please follow the above link. It looks good

but how can I implement it? Do i have to put it in every page? is it possible to put it in one place for the entire application?

Gerben Jongerius19-Dec-11 22:30

Gerben Jongerius

19-Dec-11 22:30

You could do either one of the two.

But I would suggest creating a generic php file with this piece of code in a method. Including that php file in every page and calling that method.

EG:
dection.php <-- contains the check + redirect

Sample index.php:

<?php include_once('detection.php');?>
<!-- rest of document -->

Jassim Rahma20-Dec-11 1:19

20-Dec-11 1:19

sorry but need more help plz

that mentioned code will be placed in a separet file.. that's file.. but it will be between tage? right? then followed by the if($mobile === true)?

so is the following code correct?:

<?php
    function detect_mobile()
    {
        $_SERVER['ALL_HTTP'] = isset($_SERVER['ALL_HTTP']) ? $_SERVER['ALL_HTTP'] : '';

        $mobile_browser = '0';

        $agent = strtolower($_SERVER['HTTP_USER_AGENT']);

        if(preg_match('/(up.browser|up.link|mmp|symbian|smartphone|midp|wap|phone|iphone|ipad|ipod|android|xoom)/i', $agent))
            $mobile_browser++;

        if((isset($_SERVER['HTTP_ACCEPT'])) and (strpos(strtolower($_SERVER['HTTP_ACCEPT']),'application/vnd.wap.xhtml+xml') !== false))
            $mobile_browser++;

        if(isset($_SERVER['HTTP_X_WAP_PROFILE']))
            $mobile_browser++;

        if(isset($_SERVER['HTTP_PROFILE']))
            $mobile_browser++;

        $mobile_ua = substr($agent,0,4);
        $mobile_agents = array(
                            'w3c ','acs-','alav','alca','amoi','audi','avan','benq','bird','blac',
                            'blaz','brew','cell','cldc','cmd-','dang','doco','eric','hipt','inno',
                            'ipaq','java','jigs','kddi','keji','leno','lg-c','lg-d','lg-g','lge-',
                            'maui','maxo','midp','mits','mmef','mobi','mot-','moto','mwbp','nec-',
                            'newt','noki','oper','palm','pana','pant','phil','play','port','prox',
                            'qwap','sage','sams','sany','sch-','sec-','send','seri','sgh-','shar',
                            'sie-','siem','smal','smar','sony','sph-','symb','t-mo','teli','tim-',
                            'tosh','tsm-','upg1','upsi','vk-v','voda','wap-','wapa','wapi','wapp',
                            'wapr','webc','winw','xda','xda-'
                            );

        if(in_array($mobile_ua, $mobile_agents))
            $mobile_browser++;

        if(strpos(strtolower($_SERVER['ALL_HTTP']), 'operamini') !== false)
            $mobile_browser++;

        // Pre-final check to reset everything if the user is on Windows
        if(strpos($agent, 'windows') !== false)
            $mobile_browser=0;

        // But WP7 is also Windows, with a slightly different characteristic
        if(strpos($agent, 'windows phone') !== false)
            $mobile_browser++;

        if($mobile_browser>0)
            return true;
        else
            return false;
    }

    $mobile = detect_mobile();

    if($mobile === true)
        header('Location: blog');
?>

Gerben Jongerius20-Dec-11 1:40

Gerben Jongerius

20-Dec-11 1:40

That would indeed work. If you put the entire function in the external php file and the code below in all files that need the check for mobile devices.

if (detect_mobile()) {
 header('Location: blog');
}

Please note though that the redirect that you put in you code would not work as is. You would need to replace the 'blog' part with a URL to the mobile site.

Jassim Rahma20-Dec-11 2:07