PHP - Moved: Cannot Load Mysql Extension. Please Check Your Php Configuration. - Documentatio

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=311225.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=320482.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=357633.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=305885.0

I am creating a stream page that updates automatically without the page reloading by reloading a div on the page using a timer. However, I only want it to run the update and fade in/fade out when there is a new status in the table. I tried doing it through PHP getting the number of rows in the table on the page itself and then checking the number of rows on an action page, however, the number of rows didnt update when the div was reloaded. I then tried doing it using jquery/javscript but had the same problem.

How can I acheive this?   Thanks in advance

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=318750.0

So I have a big table of about 30-40 columns. Some variables are quite long strings while others are simple tinyint(1) values.   Input into the code is a value or range of values or something that applies to each of the columns.   I need to find which ones are an applicable match to the user request and then load them into php.   Now I know variations can cause something to run more optimally one way or another but this system will get bogged down with lots of requests and lots of data, so any additional performance I give it now will help me down the road. I am just looking for general concepts to help, not specific code tweaking.   I have heard the typical rule is to query mysql as little as possible and do the hard lifting in php but I am not positive this is right.   Since I have to query anyways, should I do a mysql pull using a complex 'WHERE' to do most of the sorting. ie only get rows where a=1, b>5, c="http://google.com", d="3242342323kj4238237489023ejfjf3jrjf8jeifjdjf" ie long string, etc for all 30+columns?   OR I pull the whole DB and do all the sorting in php...   OR I do all the simple sorting in the MySQL query and some of the more complicated sorting in PHP (or vice versa)   Any ideas would help.

I am building a commenting system, it's sort of like facebooks comments. I have it right now so it loads the first last 3 comments in the database, and then there's a button to view all comments. I have it working fine, except when you add another comment to it, and then click the view all comments,


This is the script that loads onload showing the last 3 comments


$limit  = 3;

$query5 = mysql_query("SELECT * FROM sub_comments WHERE status_id='$id' ORDER BY id DESC LIMIT $limit");



This is the php script that runs when you click view more




//($start_id would be 3 in this case)

$query5 = mysql_query("SELECT * FROM sub_comments WHERE status_id='$comment_id' ORDER BY id DESC LIMIT $start_id, 1000");

so to try to show you what's happening:

OnLoad--------------------------------|---When you add more comments, (let's just say u add 1 comment before u click view comments)----
comment 9   --------------------------|   comment 10
comment 8   --------------------------|   comment 9
comment 7   --------------------------|   comment 8
------------------------------------------|   comment 7
----to be loaded onclick-------------|------What's loaded onclick---
comment 6   --------------------------|   comment 7
comment 5   --------------------------|   comment 6
comment 4   --------------------------|   comment 5
comment 3   --------------------------|   comment 4
comment 2   --------------------------|   comment 3
comment 1   --------------------------|   comment 2
------------------------------------------|   comment 1


(see how "comment 7" is being shown twice in a row)

I have a script to write out the number of hits each of my websites got each day of the week since I don't trust Google Analytics spying on my websites. The problem is that I have to query each day individually and count how many instances there are with that domain. Since I setup my database give me the time, location, demographics, etc. on each line I'm not sure how to optimize this further. Help would be greatly appreciated.

Code: [Select]
echo '<table><tr><td>Domain</td>';

foreach($timearray as $t){
echo '<td>'.$t.'</td>';
}
echo '</tr>';
$i = 0;
foreach($urlarray as $u){
$today = date("Y-m-d");
$yesterday = date("Y-m-d", mktime(0,0,0,date("m")  , date("d")-1, date("Y")));
$lastmonth  = date("Y-m-d", mktime(0,0,0,date("m")-1  , date("d")-1, date("Y")));
$twoweeks  = date("Y-m-d", mktime(0,0,0,date("m")  , date("d")-15, date("Y")));
$result3 = mysql_query("SELECT refer,Count(*) as count FROM `approved` WHERE time>'$lastmonth 23:59:59' AND time<'$today' AND refer LIKE '%$u%'");
$row3 = mysql_fetch_array($result3);
$result4 = mysql_query("SELECT refer,Count(*) as count FROM `approved` WHERE time>'$twoweeks 23:59:59' AND time<'$today' AND refer LIKE '%$u%'");
$row4 = mysql_fetch_array($result4);
if($row3['count']==0){echo "<tr style='background:red'>";}elseif($row4['count']>0){echo "<tr style='background:green'>";}elseif($i % 2){echo "<tr style='background:#CCC'>";}else{echo "<tr style='background:#FFF'>";}
echo '<td>'.$u.' '.$row3['count'].' '.$row4['count'].'</td>';
foreach($timearray as $t){
$result = '';
$result = mysql_query("SELECT COUNT(*) AS count FROM `approved` WHERE time LIKE '$t%' AND refer LIKE '%$u%'");
while($row = mysql_fetch_array($result)){
echo '<td>'.$row['count'].'</td>';
}
}
echo '</tr>';
$i++;
}

echo '</tr></table>';

Greetings.  First time poster looking for some PHP help if it can be provided, because I'm confused as hell.

First off, I'll explain my situation.  I'm the IT technician of a small business tasked with ensuring the business' computers and website are running in top shape.  I originally joined as a Data Entry clerk to post products to the business' website, but got promoted when they original IT technician left town to pursue his PhD.  Before he left, he taught me a few things to prepare watching over the website as my new duty, including some PHP and MySQL.  Now, a few months after he's left, I have the glorious task of trying to move our website to a new host because we've apparently outgrown our original host's capabilities.  And being based on PHP with a MySQL database, it's turning out to be OH-so-fun.

So far, I've managed to download our entire website from the old host and given it to our new host to put up as a testing site, to ensure everything works before we switch hosts.  And for the most part, a lot of it has come together nicely, but there's still work needed to be done.  And thus we come to the problem I hope someone here can help with.

Our website has two back-end Admin sections, an older one that used to handle everything, and a newer one that's sleeker but still reads off a lot of data from the older one to work properly.  Normally, when you access those sections, you need to log in first.  Now, in the testing site, when I access those areas, the header of each of those sections now reads <?= $row[title] ?> and if I attempt to log in as normal, it just flashes back to the login page with the fields now cleared of what I typed in.  When I asked about this to see what the problem might be, the new host said it might "at least two misconfigurations on the new server relative to the old server".  So, I've been trying to Google for some help with PHP Configuration Functions, but I don't know if what I'm reading will help me fix the problem.  Would anyone here happen to know what they might mean in this case, because my knowledge of PHP is fairly limited beyond what I was taught to keep the website in order without considering a host change...

Thanks to those who help or can direct me to a place that helps!

Dear All,

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=349871.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=313543.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=317810.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=306339.0