[Bored? Looking for ideas? Here's a list!]

- Query optimizer :: analyzes your queries and database to optimize queries.

- Hack Testing Site :: (Safely tests sites for security issues) You give it a website and it tries to hack it. It then Emails you the results, and how you can fix the issue.

- Categorizer :: Give it a document and it assigns 1 or more categories to it (Science, Math, English, Programming, etc.). Sub-Categories would be cool too.

- Niche Search Engine :: A search engine that searches a persons niche.

- rock paper scissors lizard spock

 

That is all I can think of ATM

[undefined function error]

In the logo function you have extra spaces after:

 

HEREDOC;

 

Their can be NO white space after or before it!

[PHP Snips 2.0]

I forgot to mention, here is a demo account:

 

user: demo

pass: abc!23

[PHP Snips 2.0]

I'd go with Red or Green (not both) as a primary color, and keep the blue accents. It looks like a spam-site landing page. You know one of those "search pages" with links, on a domain that got snatched up.

 

The tweet at the top says "Contains 542 different stopwords or noise words!" What does that mean?

 

I would try changing the font size difference between a header and text to be much more different. (larger headers).

 

Categories/Tags especially in a cloud.

 

I chose green, I kinda like it, but maybe a different color green and I would like it more... What are your thoughts?

 

The tweet you saw had to do with a conversation.

 

The fonts are bigger. If I go any bigger some will wrap to a second line (some spots that's fine others it is not).

[Headers already sent]

(And Pikachu2000 has helped me a million times on this board, it seems.  Best to listen to his advice )

 

And yet you only have 204 posts

 

 

You could try something like this:

 

header("Refresh: 5; Admin.php");
echo "<script language='javascript'>alert('FreeExam database backed up successfully');</script>";

[Display width in php]

Then there is something wrong on your end, because when I tested my solution it worked 100% fine.

 

So maybe your missing some code? What is happening on your side?

[PHP Snips 2.0]

Absolutely hate the twitter feed right below the header. Why are you giving so much priority to that? At least make it so the user can close it

 

We were actually thinking of getting rid of that and putting a tag cloud, or categories (mysql, math, images, etc.) there. What would you think of that?

 

Judging by the home page, I find it difficult to navigate. Where is the main navigation? Categories? Can't really go any further because most of the links are returning 404s.

 

The main nav is now icons on the top right, letter searching is to the right of the searchbar. Which links return 404's?

 

I think the new site needs more color.

 

I have been trying to find more colors to use, but I can't find anything. I have tried orange, but my co-worker says it looks too much like Halloween colors. Any Suggestions?

[replace "-" with "/" in preg_match pattern]

Another option:

 

<?php
function checkDateFormat($date){
@list($m, $d, $y) = explode("/", $date);
if(empty($m) || empty($d) || empty($y) || !checkdate($m, $d, $y))
	return false;
return true;
}

var_dump(checkDateFormat("13/2012"));
var_dump(checkDateFormat("cat"));
var_dump(checkDateFormat("2012-05-05"));
var_dump(checkDateFormat("2012/05/05"));
var_dump(checkDateFormat("12/05/1205"));

[Insert field into other table when 2 other fields match]

why can't you do it on your first query? You can do it without distinct by doing:

 

create table lat_long (coord_id int unsigned primary key, lat decimal(18, 9), long decimal(18, 9));
create unique index lat_long (lat, long) on lat_long;
insert ignore into lat_long (coord_id, lat, long) select id, lat, long from cities;

 

How this works....

1.) First we create our table (you probably already have that)

2.) Next we add a unique index on lat, long so we don't have any duplicates (used for the "ignore" on the following line).

3.) Finally we select every thing from cities and insert into lat_long, if the lat, long is already in there don't insert again (hence "ignore")

[MySQL query with a lot of ANDs and ORs]

parenthesis... not brackets

[Best Way To Do A Search...]

What is your question?

[Display width in php]

Try this:

 

<?php
$ScreenWidth = "undefined";
if(!isset($_GET['screen_check'])){
echo <<<JS
	<script>
	document.location="?ID=$PropertyID&screen_check=done&Width="+screen.width+"&Height="+screen.height;
	</script>
JS;
exit;
}
if(isset($_GET['Width'])){
$ScreenWidth = $_GET['Width'];
} else {
$ScreenWidth = 235;
}
echo "Screen width = $ScreenWidth";
?>

[Foreach Loop Paginate ?]

if you are using a database, you could use this: http://phpsnips.com/snip-94

[Sentences displaying like a paragraph]

are you using nl2br?

[duplicated rows in DB]

Hi

 

I'm not familar with "insert ignore" function. what does "ignore" do?

 

What it will do is it will insert into the database, but if there is a duplicate it will "ignore" the insert. aka the insert won't happen. so, lets say their is a unique index on the "email" column.

 

msyql_query("insert ignore into users (first, last, email) values ('$first', '$last', '$email')");
$id = (int)mysql_insert_id();
if($id > 0){
// Value was inserted
}else{
// Value was not inserted, duplicate was found
}

[Need help with Quotes ' " ' "]

Just like this:

echo "<video controls>
        <source src='$movie' type='video/webm; codecs=\"vp8.0, vorbis\"'/>
</video>";

 

Note: You forgot the semi-colon

[Browser Timeout]

This SO has everything to educate ya.

 

http://stackoverflow.com/questions/1014203/best-way-to-use-googles-hosted-jquery-but-fall-back-to-my-hosted-library-on-go

 

Sorry, that isn't what I am looking for.

[Browser Timeout]

lets say for kicks and giggles Google goes down, or is taking a long time to respond making the page come to a halt, and say my site is using one of their JavaScript files. The page now has to wait until the browser decides to give up and continue on.

 

I don't know if you have ever seen this, but some times when you load a page in Chrome it says "waiting for etc1.static.domain.com" and the page just sits there because the site is down, or has too much traffic and nothing else loads (I have seen this issue with Twitter). If there was a time out of like 10 seconds we wouldn't have to wait 60 seconds for the page to decide that it can not load that item.

[mysql_fetch_row() help plz]

I usually get that when my query is invalid.

 

I also see you don't have "mysql_query" in the code either

[Browser Timeout]

Is there a header that tells the browser to wait for connections to images/js/css/etc for a certain number of seconds, then if the file doesn't respond then cancel/close the request/retrieval?

[Setting up a DNS server]

haha

D: Domain

N: Name

S: Server System

 

FTFY. 

 

 

But then I wouldn't have been redundant.

[Setting up a DNS server]

haha

D: Domain

N: Name

S: Server

 

[image path issue]

Note images should not have periods in their name.

 

Yest they can. Lots of people do it.

[Import from csv file to MySQL using PHP]

MySQL can do this for you...

 

mysql_query("LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name
  FIELDS TERMINATED BY ',' ENCLOSED BY '\"'
  LINES TERMINATED BY '\r\n'
  IGNORE 1 LINES");

[Twitter is down]

I have been using Twitter to advertise my website, It works amazingly!