PHP Quiz

**seanf** · Apr 3, 2003, 15:32

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 Code:


<?php



    $i = 'Z';



    echo ++$i;



?>

Question 1. What will the above code output?

Sean

**Hartmann** · Apr 3, 2003, 15:39

It prints AA. Come on give me something hard

**seanf** · Apr 3, 2003, 15:44

Originally Posted by seanf

Try to answer the question without just running the code

Only joking! Where's your question?

Sean

**Hartmann** · Apr 3, 2003, 15:51

haha

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

**Jeff Lange** · Apr 3, 2003, 16:24

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

**Hartmann** · Apr 3, 2003, 16:30

Originally Posted by cyborg from dh

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** · Apr 3, 2003, 16:31

Nope, wait for Stephan!

Let's hope he comes up with something soon!

[EDIT] He wimped out!

Sean

**Jeff Lange** · Apr 3, 2003, 16:34

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

**seanf** · Apr 3, 2003, 16:34

I'm going to bed. Night all

Sean

**Jeff Lange** · Apr 3, 2003, 16:41

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

**Jeff Lange** · Apr 3, 2003, 17:18

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** · Apr 3, 2003, 17:45

By decimal, you mean full-stop, right?

**Paul S** · Apr 3, 2003, 17:51

Code:

#[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** · Apr 3, 2003, 18:28

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** · Apr 3, 2003, 18:31

done

Code:

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

Paul [edit]Fixed minor error

**Jeff Lange** · Apr 3, 2003, 18:40

good work, you win.

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

**Paul S** · Apr 3, 2003, 19:40

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** · Apr 3, 2003, 19:59

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:

Code:

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** · Apr 3, 2003, 20:00

PHP Code:


$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** · Apr 3, 2003, 20:01

TypeID is never used in the new table...

**Paul S** · Apr 3, 2003, 20:18

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** · Apr 3, 2003, 20:23

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** · Apr 3, 2003, 20:23

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** · Apr 3, 2003, 20:25

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** · Apr 3, 2003, 20:27

Originally Posted by 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. [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

)