PHP Quiz

[seanf]

Hey everyone,

How about a little quiz? I'll post a question and if you can answer it correctly you can post your own PHP question

Try to answer the question without just running the code

<?php

    $i = 'Z';

    echo ++$i;

?>

Question 1. What will the above code output?

Sean

[Hartmann]

It prints AA. Come on give me something hard

[seanf]

Try to answer the question without just running the code

Only joking! Where's your question?

Sean

[Hartmann]

haha

hmmm... I gotta think of a good one.

[Jeff Lange]

well now he said AA, and everyone knows... ok the answer is AA, can i ask a question now?

[Hartmann]

well now he said AA, and everyone knows... ok the answer is AA, can i ask a question now?

You can post a question in my place... I can't come up with anything good.

[seanf]

Nope, wait for Stephan! Let's hope he comes up with something soon!

[EDIT] He wimped out!

Sean

[Jeff Lange]

ok give me a few minutes here.. I'll think of something...

[seanf]

I'm going to bed. Night all

Sean

[Jeff Lange]

dang, this is harder than I thought it would be.

[Jeff Lange]

how about a question i actually need answered:

i need a regex to match any numerical number, (including a decimal)

(trying not to make it too hard )

[anode]

By decimal, you mean full-stop, right?

[Paul S]

#[0-9]{1,M}\.[0-9]{1,N}#

Where M is the maximum number of digits before the decimal point and N the number of decimals.

[Jeff Lange]

i need it to match any length of numbers before the decimal, and any length after, as well as not requiring the decimal.

[Paul S]

done

#^[0-9]+(\.[0-9]+)?$#

Paul [edit]Fixed minor error

[Jeff Lange]

good work, you win.

(That one was way too easy, but I couldn't think of anything, lol)

[Paul S]

ok, my turn.
This one is mysql & php:
you got 3 tables

table1
-------------------------------
ID name

table2
------------------------------
ID filename TypeID

table3
---------------------------
ID type

The chanllenge is make a query to fetch the following fields, table1.ID, name, filename and type and store them into a new table

newtable
-----------------
ID (must same as table1.id)
name
fliename
type

NOTE: TypeID could be NULL.

Good Luck

[DR_LaRRY_PEpPeR]

you didn't say how the tables are related so i will assume that table2.TypeID references table3.ID and table1.ID references table2.ID (???).

no PHP needed, just 1 query:

CREATE TABLE newtable (
	ID SMALLINT UNSIGNED NOT NULL,
	name VARCHAR(64) NOT NULL,
	filename VARCHAR(64) NOT NULL,
	type VARCHAR(16),
	PRIMARY KEY (ID)
) SELECT t1.ID, t1.name, t2.filename, t3.type FROM table1 t1, table2 t2
	LEFT JOIN table3 t3 ON (t3.ID=t2.TypeID)
	WHERE t2.ID=t1.ID
	ORDER BY t1.ID;

is that right...?

[Jeff Lange]

$query = mysql_query("SELECT
table1.ID,
table1.name,
table2.filename,
table2.TypeID,
table3.type
FROM
table1,table2,table3
WHERE (table1.ID=table2.ID AND table2.ID=table3.ID);");
while ($result = mysql_fetch_array($query))
{
    $result['ID'] = (int) $result['ID'];
    $result['name'] = addslashes($result['name']);
    $result['filename'] = addslashes($result['filename']);
    $result['type'] = addslashes($result['type']);
    mysql_query("INSERT INTO newtable (ID, name, filename, type) VALUES
                ($result[ID], '$result[name]', '$result[filename]', '$result[type]');");
} 

[Jeff Lange]

TypeID is never used in the new table...

[Paul S]

Edit:

That's right, TypeID is not used.
Actually Type ID is not needed in the new table.

Let me check the code ...

[Paul S]

Great! All would share my opinion, due easiness, Matt is the winner, your turn.

(I love when you can reduce all your problems to a single line of code. )

[Anagram]

If I may ask one, let's try this then:

Ok, it's not that hard at all, just to test you guys


What does this do?

<?PHP echo $HTTP_SERVER_VARS["REMOTE_ADDR"]; ?>

[Jeff Lange]

echo's the remote ip address of the user accessing the script, unless it is the isp, in which case, usually, HTTP_X_FORWARDED_FOR is set.

[Jeff Lange]

Great! All would share my opinion, due easiness, Matt is the winner, your turn.

(I love when you can reduce all your problems to a single line of code. [img]images/smilies/biggrin.gif[/img] )

question... who's matt?

(i just didn't see anyone names matt post... i might not know some names though )