Linux, Apache, MySQL, PHP

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

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

Jassim Rahma20-Dec-11 3:21

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/[^]

How to configure email system in xampp server

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

VickyVicki16-Dec-11 1:41

Re: How to configure email system in xampp server

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

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

Re: How to configure email system in xampp server

24-Dec-11 0:02

Thank you friend Smile | :)

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

Editor for php

VickyVicki15-Dec-11 6:17

15-Dec-11 6:17

Hi Friends,
I am new to php and i m using xampp server to run php .I am using notepad now .I would like to know is there any editor for php .Also I would like to know is it possible to integrate the editor or tool like netbeans with xamp server.Thanks in advance Smile | :)

Re: Editor for php

User 171649215-Dec-11 6:50

User 1716492

15-Dec-11 6:50

There are plenty IDE's and editors out there. You have already said Netbeans. You can also take a look at (1) Notepad++, (2) Aptana, (3) Microsoft Expressions Web, (4) Adobe DreamWeaver, (5) Eclipse. This list is not exhaustive. With the exception of (3) and (4) in my list, the others are free to download and use.

modified 1-Aug-19 21:02pm.

Re: Editor for php

VickyVicki16-Dec-11 1:38