paging the result - Linux, Apache, MySQL, PHP Discussion Boards

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?

Re: detect client language

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.

Re: detect client language

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.

Re: detect client language

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

Re: detect client language

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.

Re: detect client language

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

Re: detect client language

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

Jassim Rahma

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

best way to determine mobile device

Jassim Rahma19-Dec-11 0:24

Jassim Rahma

19-Dec-11 0:24

Hi,

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

Regards,
Jassim

Re: best way to determine mobile device

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.

Re: best way to determine mobile device

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

Re: best way to determine mobile device

Jassim Rahma19-Dec-11 21:43

Jassim Rahma

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?

Re: best way to determine mobile device

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 -->

Re: best way to determine mobile device

Jassim Rahma20-Dec-11 1:19

Jassim Rahma

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');
?>

Re: best way to determine mobile device

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.

Re: best way to determine mobile device

Jassim Rahma20-Dec-11 2:07

Jassim Rahma

20-Dec-11 2:07

I am now getting this error:

Parse error: syntax error, unexpected T_VARIABLE in /home/jassimrahma/JassimRahma.com/detection.php on line 4

this is what I put in my index.php 1st line:

<?php
    include_once('detection.php');
    if (detect_mobile()) {
    header('Location: http://m.jassimrahma.com');
    }
?>

and detection.php is here:

<?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;
    }
?>

Re: best way to determine mobile device

Jassim Rahma20-Dec-11 3:21

Jassim Rahma

20-Dec-11 3:21

Thanks

I am using now this and very simple and works fine for me..

http://code.google.com/p/php-mobile-detect/[^]

Re: best way to determine mobile device

Mohibur Rashid19-Dec-11 22:47

Mohibur Rashid

19-Dec-11 22:47

Put it in the initial page. That is the first page user would open. such as index page or login page.

If it figured out that the client device is mobile save that information to session. As a matter of fact its not a big deal. you dont even need to remember whether it is a mobile device or not. But If the set of functions are different for mobile and pc then you can use the session variable to determine about which function to call.

more over when it would redirect to page allocated for mobile do not put any link to those mobile page that redirect to pc pages

Linux Back Track 5

HARISHCHOWDHARY18-Dec-11 20:40

HARISHCHOWDHARY

18-Dec-11 20:40

Please suggest best online resource to learn BackTrack 5's new functionality.

Thanks

Re: Linux Back Track 5

Richard MacCutchan18-Dec-11 23:36

Richard MacCutchan

18-Dec-11 23:36

This one[^].

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

How to configure email system in xampp server

VickyVicki16-Dec-11 1:41

VickyVicki

16-Dec-11 1:41

How to configure mail in the xampp server. I am new to PHP and learning it . I wish to send emails where should I configure it in Xampp .Thanks in Advance Smile | :)

Re: How to configure email system in xampp server

Aniruddha Loya19-Dec-11 8:29

Aniruddha Loya

19-Dec-11 8:29

You need to configure Mercury Mail Transport System that comes with XAMPP
Loads of blogs available about how to go about doing it... one such blog article is here[^]

Imagination is the one weapon in the war against reality!!!
aniruddhaloya.blogspot.com

Re: How to configure email system in xampp server

VickyVicki24-Dec-11 0:02

VickyVicki

24-Dec-11 0:02

Thank you friend Smile | :)

Re: How to configure email system in xampp server

Aniruddha Loya24-Dec-11 7:48

Aniruddha Loya

24-Dec-11 7:48

Welcome

Hope your email server is up and running Smile | :)

P.S. Please accept the answer (if there is a provision to do so)... will help others to know that the solution works

Imagination is the one weapon in the war against reality!!!
aniruddhaloya.blogspot.com

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.