[need help with unserialize]

if you're trying to serialize the array just to make the filtering process quicker, that's not the way to go about it. You're over complicating a simple problem.

[HELP WITH XAMPP]

here's the steps you need to backup all your databases http://www.instructables.com/id/Backing-up-your-SQL-database-using-XAMPP-and-phpMy/, the power of google is amazing mate.

[Undefined Variable Error Message]

you're passing undefined variables $likes and $dislikes to $array. Either give them a default value or don't pass them to the array unless they're set.

[storing results]

in that case you need to make an AJAX request.

[storing results]

really not sure what you want, is it something along these lines?

$name = 'stevengoh';
$going = '<span id="'.$name.'">'.$name.'</span>';
echo $going;

[Chrome and Safari not playing nice. Safari identified when Chrome used.]

http://www.php.net/manual/en/function.get-browser.php#101125

ruudrp at live dot nl 28-Nov-2010 11:31

To my surprise I found that none of the get_browser alternatives output the correct name / version combination that I was looking for using Opera or Chrome. They either give the wrong name eg Safari when in fact it should be Chrome and if the ua string includes a version number as with the latest versions of Chrome and Opera the wrong number is reported. So I took bits and pieces from the various examples and combined them and added a check for version.

<?php
function getBrowser() 
{ 
    $u_agent = $_SERVER['HTTP_USER_AGENT']; 
    $bname = 'Unknown';
    $platform = 'Unknown';
    $version= "";

    //First get the platform?
    if (preg_match('/linux/i', $u_agent)) {
        $platform = 'linux';
    }
    elseif (preg_match('/macintosh|mac os x/i', $u_agent)) {
        $platform = 'mac';
    }
    elseif (preg_match('/windows|win32/i', $u_agent)) {
        $platform = 'windows';
    }
    
    // Next get the name of the useragent yes seperately and for good reason
    if(preg_match('/MSIE/i',$u_agent) && !preg_match('/Opera/i',$u_agent)) 
    { 
        $bname = 'Internet Explorer'; 
        $ub = "MSIE"; 
    } 
    elseif(preg_match('/Firefox/i',$u_agent)) 
    { 
        $bname = 'Mozilla Firefox'; 
        $ub = "Firefox"; 
    } 
    elseif(preg_match('/Chrome/i',$u_agent)) 
    { 
        $bname = 'Google Chrome'; 
        $ub = "Chrome"; 
    } 
    elseif(preg_match('/Safari/i',$u_agent)) 
    { 
        $bname = 'Apple Safari'; 
        $ub = "Safari"; 
    } 
    elseif(preg_match('/Opera/i',$u_agent)) 
    { 
        $bname = 'Opera'; 
        $ub = "Opera"; 
    } 
    elseif(preg_match('/Netscape/i',$u_agent)) 
    { 
        $bname = 'Netscape'; 
        $ub = "Netscape"; 
    } 
    
    // finally get the correct version number
    $known = array('Version', $ub, 'other');
    $pattern = '#(?<browser>' . join('|', $known) .
    ')[/ ]+(?<version>[0-9.|a-zA-Z.]*)#';
    if (!preg_match_all($pattern, $u_agent, $matches)) {
        // we have no matching number just continue
    }
    
    // see how many we have
    $i = count($matches['browser']);
    if ($i != 1) {
        //we will have two since we are not using 'other' argument yet
        //see if version is before or after the name
        if (strripos($u_agent,"Version") < strripos($u_agent,$ub)){
            $version= $matches['version'][0];
        }
        else {
            $version= $matches['version'][1];
        }
    }
    else {
        $version= $matches['version'][0];
    }
    
    // check if we have a number
    if ($version==null || $version=="") {$version="?";}
    
    return array(
        'userAgent' => $u_agent,
        'name'      => $bname,
        'version'   => $version,
        'platform'  => $platform,
        'pattern'    => $pattern
    );
} 

// now try it
$ua=getBrowser();
$yourbrowser= "Your browser: " . $ua['name'] . " " . $ua['version'] . " on " .$ua['platform'] . " reports: <br >" . $ua['userAgent'];
print_r($yourbrowser);
?>

[strange problem with php insert code]

what exactly is the problem you are having?

[Im lost :(]

is 'Computer_Price' the correct name of the field?

 

EDIT:

Noticed you changed the second argument of mysql_fetch_array to MYSQL_NUM.

 

Change your while loop to this and it should work fine:

while($row = mysql_fetch_array($result)) 

MYSQL_NUM means the fields are numbered with an index. Which you don't want if you're calling a field by it's name rather than an id.

[Im lost :(]

$results = mysql_select_db ("computers");

is not a resource. You need a mysql_query() which will return either a resource, true or false.

[PHP A HREF TARGET]

You can use javascript to open a new window.

[Online food ordering vs ordering by phone?]

I order online, just another browser tab to add to my sea of browser tabs. Plus some businesses have an ordering tracking time/diagram thing, rather than muting my music so I can hear the front door knock, I can continue to enjoy listening to my music until the order tracker says "have left the shop".

[PHP LOGOUT]

you can't have any output before the header() function. So in your case you can't have that echo() in there.

[Delete row from db]

because the 'value' attribute needs a value.

[Delete row from db]

You're not sending $hours_id to the other file.

[Delete row from db]

[ code ] [ /code ] tags please.

 

<?php

include '../php/config_conn.php';

$querysum = "SELECT SUM(total_time) FROM `coop_hours` where user = '".$_SESSION['user_name']."'";
$resultsum = mysql_query($querysum);
$arr = mysql_fetch_row($resultsum);
$resulthours = $arr[0];

$querytime = "SELECT * FROM `coop_hours` WHERE user = '".$_SESSION['user_name']."' ORDER BY 'date_completed'";
$result = mysql_query($querytime);

$num = mysql_num_rows($result);

mysql_close();


echo "<table width='800' cellpadding='0'><tr>
      <td><strong>Coop Job</strong></td>
      <td align=center><strong>Date Completed</strong></td>
      <td align=center><strong>Total Time</strong></td>
      <td><strong>Comments</strong></td><td>Delete Entry</td></tr>";

$i=0;
while ($i < $num) {
   
$hours_id = mysql_result($result, $i, "hours_id");
$user = mysql_result($result, $i, "user");
$coop_job = mysql_result($result, $i, "coop_job");
$date_completed = mysql_result($result, $i, "date_completed");
$start_time = mysql_result($result, $i, "start_time");
$end_time = mysql_result($result, $i, "end_time");
$total_time = mysql_result($result, $i, "total_time");
$comments = mysql_result($result, $i, "comments");


echo "<tr><td>$coop_job</td>
   <td align=center>$date_completed</td>
   <td align=center>$total_time</td>
   <td>$comments</td>
   <td align=center>
   
   <a href='php/del.php'><img src='images/del.png'></a></td>
   </tr>";

$i++;
}
echo "<tr><td colspan=5><hr></td></tr>";
echo "<tr><td></td><td align=right>Total hours:</td><td align=center>$resulthours</td><td></td></tr>";
echo "<table>";

?>

And here is del.php:

<?php

include '../../php/config_conn.php';

$del_query = ("DELETE FROM coop_hours WHERE hours_id = '".$hours_id."' LIMIT 1");
$result = mysql_query($del_query);

header("Location: http://.../myaccount-testing.php");

?>

[SESSION Variables Lost When Form Posted]

you have session_destroy() in your first bit of code, which destroys the entire session, including $_SESSION['start_time'].

[Block email extension's]

you can use strstr() to find the domain in the string.

[function trouble]

You don't appear to be calling your function at all.

[Error with Search and mysql_fetch_array]

Your code looks alright to me, with the exception of your $_GET[] variables, they need to be filtered and validated. Other then that, practice makes perfect. This code can be significantly shortened and improved, but you will learn where and how you can improve it the more you dive into PHP. Good luck!

[HELP WITH XAMPP]

you obviously didn't back up all of it then, in other words human error. Not a collation error.

[Please help with dynamic table sorting]

really have no idea what you're talking about, could you explain in more detail or post a link to a webpage that has this feature?

[Error with Search and mysql_fetch_array]

You have a logic error, look at where your if/else statements are and what they do, then you'll know where you currently have the mysql_fetch_array() does not make any sense.

[Connection issue with this script]

there's a typo in your connect.php:

$connection = mysq1_connect

it has a one instead of 'L'

$connection = mysql_connect

[Paths issue]

Should I be using my "Config" file with my PHP Includes, or should I *just* be using Relative Path references as some have said?

 

I suppose if I have a simple site structure, things don't change too much, and I don't have too many layers, then typing...

<?php	require_once('../components/content_sticky.inc.php');	?>

 

...isn't that big of a deal?!

 

Shouldn't really have config.php with a heap of includes in it(if that's what you mean?), a config file is usually for variables, arrays or constants that are used in various parts of the website such as database connection details.

 

Relative path references is the way to go, and if you're worried about having to copy/paste includes into multiple files(that's what I think you're talking about?), then you may want to develop some kind of template system.

[QUick Pick Lottery Option]

Volunteer staff and members are helping you out of their own precious free time, no one here HAS to help you. A little respect goes a long way.

 

As far as your code is concerned. In my opinion it would be quicker to recode it differently then to 'tinker' with it. Sometimes you just need to take in the advice, scrap what you have and start over. That way you will avoid hours of some what wasted time and bad headaches.