Safety Shaun posted:

I have a huge table of articles I've posted on one of my personal sites and each entry has a tags field as such

art_id, art_name, art_cont, art_tags
1, "title of article 1", "content of article 1", "hello, wooop, omnomnom"
2, "title of article 2, "content of article 2", "jello shots, canabis, gaysex"
3, "title of article 3, "content of article 3", "jello shots, canabis, robin hood"
4, "title of article 4, "content of article 4", "canabis, woop, something else, craigslist"

How would I create an array of all the tags, ordered by any more commonly used ones first? Would I implode them all into a tags array, order by somthing then use an array function to remove dupes? or is there some mythical magical MySQL command that'll accomplish this for me?

MononcQc posted:

Zorilla posted:

Is there a good way to gracefully reject file uploads that are too large? Limits are usually controlled through php.ini or other files that compliment it such as .htaccess, which means PHP is the one throwing a fit when something is too big.

I want to display a user-friendly error if somebody tries to upload gargantuan, unresized images from their 14 MP camera to a website. My guess is that there is some sort of error you could check for on postback, but Google comes back absolutely dry when I look up information on this. Any ideas?

Aturaten posted:

Is there any way to get a DIVs size using PHP? I really need to find this out soon, this image gallery is killing me.

Ned posted:

PHP has no idea of knowing what the page actually looks like in the browser or DOM. jQuery is your friend here.

Ned posted:

I think you should set it with html.
<input type="hidden" name="MAX_FILE_SIZE" value="500" />

MrEnigma posted:

PHP actually has an object for manipulating the DOM (http://us.php.net/dom). The catch is that you need to use output buffering, and you have to operate on it before you dump it out to the user.

There is also PHPquery (http://code.google.com/p/phpquery/) which is compatible with jQuery 1.3 API I believe.

Zorilla posted:

I would advise you to just use tables for this since it's one of the few totally appropriate uses for it in modern web design.

Chopper posted:

This is something I don't get with "Web 2.0" design.

Everyone is so "OMG TABLESSS!!!" that they never use them. I've seem someone display tabular data using floated divs.

You aren't giving in by using tables for displaying data, you are only giving in if you use them for design purposes.

vanjalolz posted:

Whats the best way to get the age of a file in days?

Murodese posted:

http://au.php.net/manual/en/function.filemtime.php

e;

vanjalolz posted:

Whats the best way to get the age of a file in days?

edit:
$now = strtodate("now");
$result = filemtime($file);
$diff = $now - $result;
$days = floor(($diff%2629743.83)/86400) ;

MrEnigma posted:

I can see uses for doing non-tables for data....variable columns, moving stuff way around. Some sites that allow for a theme or something could have some advantage...but yeah...not usually.

Munkeymon posted:

And I guess you could make PHP tell you how may days there are in a year, but I'm going to cross my fingers that nothing changes that for a long time.

Standish posted:

Actually it changed this year.

Munkeymon posted:

Good point. I guess you would have to go back and add up the days from every year unless you were expecting short file lifetimes. Or the PHP devs could make a propper time span object.

Edit: kind of ugly, but it works according to Python's datetime class.

php:

<?
$now = new DateTime();
$ft = new DateTime(date('c',filemtime($filePath)));
//days this year
$diff = intval($now->format('z')) - intval($ft->format('z'));
//days in other years
$ft = intval($ft->format('Y'));
for($i = (intval($now->format('Y'))-1); $i >= $ft; --$i)
{
    $now = new DateTime('Dec 31, '.$i);
    $diff += intval($now->format('z')) + 1;
}
?>

Begby posted:

This should give the exact same result, unless I am missing something.

php:

<?
$secsInDay = 60 * 60 * 24;
$daysOld =  floor((Time() - filemtime($filePath)) / $secsInDay);
?>

Munkeymon posted:

Not every day has that many seconds. http://en.wikipedia.org/wiki/Daylight_saving_time

nbv4 posted:

I have a class that handles printing the DOCTYPE and headers, as well as the footer on each page. At the top of the class declaration, I have all these things defined like so:

Its giving me an error on the line where I define the meta header. Apparently the "EOF" thing is not allowed in the class declaration top part. What other options do I have here that don't include going through each line to escape the quotation marks? The meta header is going to be expanded to about three times the size and I just think it's dumb to have to escape quotation marks like that.

the php website suggests "nowdoc", but I'm using PHP 5.2.X, and those are only allowed in 5.3 and greater.

Munkeymon posted:

Use single quotes to delimit the strings?

Sharktopus posted:

I'm using cakephp and sending this data to the save() function

Project is updating, but User should be populating a projects_users table which keeps track of the HABTM relationship, however nothing is getting done to the projects_users table. According to the documentation, I'm doing everything correctly. Has anyone here successfully gotten a HABTM to update using cakephp?

edit: Also, I've been asking around the cakephp channel on freenode for about a day and nobody there has even aknoleged that I have asked a question.

Stephen posted:

I can't answer your question, but I can tell you that I've spent days trying to figure out why their lovely model system isn't working properly. I ended up using $this->model->query(); more often than not just because I got sick and tired of writing ugly workarounds.

I recommend using a different framework (or none at all). I used CakePHP on three of my last projects and had no end of bugs trying to use their model system. Their documentation and community is absolutely terrible as well, barring a few exceptions.

Zorilla posted:

Or the more context highlighting-friendly way:

php:

<?php

ob_start();
?>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
    <head profile="http://www.w3.org/2005/10/profile">
        <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
        <meta name="DESCRIPTION" content="stupid description goes here." />
        <meta name="KEYWORDS" content="keywordz" />
<?php
$meta_header = ob_get_contents();
ob_end_clean();

?>

Roseo posted:

jasonbar posted:

code:

<?php
$address = empty($address) ? "none" : $address;
$city = empty($city) ? "none" : $city;
echo "Address: $address<br />City: $city";
?>

You should really look into using some framework (I won't recommend one and the overhead / ramp up to getting started may or may not be worth it.) At the very least Smarty it up.

Edit:

Roseo posted:

Yeah, that code's pretty much what I did. No point keeping all the things that're the same between the two states in the variable when all I want is the address or "none".

I'll look into a framework. Are they usually easy to integrate into existing sites or is it better to make the site up from scratch if you use one?

Hammerite posted:

Is this secure? If not is there anything that can easily be done to make it secure?

jasonbar posted:

Relating to only the secureness of the file inclusion, you should be fairly safe. You should really keep commonthings.php outside of the webroot so that there is no chance of anyone actually getting it through their browser.

jasonbar posted:

Relating to only the secureness of the file inclusion, there is nothing inherently insecure about it. You should really keep commonthings.php outside of the webroot so that there is no chance of anyone actually getting it through their browser.

I was recently contracted to fix a lawyers website because "it was showing all of the code." Turns out they had a new system admin who moved everything over to a new server and never setup PHP. Their entire config file with all of their auth. info was available in plaintext. Not cool.

sonic bed head posted:

I have a question about this. How does that really happen? I thought that if a php server is asked to serve a .php file, it would always interpret it before it sends the response to the client. If that's the case, as long as the config stuff isn't being echoed, how could the browser show the plaintext?

sonic bed head posted:

I have a question about this. How does that really happen? I thought that if a php server is asked to serve a .php file, it would always interpret it before it sends the response to the client. If that's the case, as long as the config stuff isn't being echoed, how could the browser show the plaintext?

duck monster posted:

I'd actually strongly discourage doing this, because its not nestable and thus its not scaleable.

If you find later down the track your output needs to be captured for some sort of nefarious cacheing type purpose or whatever, then your kinda hosed.