Avatar billede dennism Nybegynder
16. oktober 2001 - 18:01 Der er 17 kommentarer og
2 løsninger

PHP - hjælp!

Hej Eksperter

Jeg har tre spørgsmål/opgaver:

1.
Lav et Upload-spript, som skal ligge i \'\\admin\', men som skal uplaode til \'\\images\\profiler\\$id.jpg\'. Men skal også kunne oploade .gif filer!

2.
Hvad er fælgende formular-dimser til, og hvilke skal jeg bruge til hvad ? :
GET
POST
og evt. andre

3.
Hvad er disse Mysql-datatyper til:
TINYINT
SMALLINT
MEDIUMINT
INT
BIGINT
FLOAT
DOUBLE
DECIMAL
DATE
DATETIME
TIMESTAMP
TIME
YEAR
CHAR
VARCHAR
TINYBLOB
TINYTEXT
TEXT
BLOB
MEDIUMBLOB
MEDIUMTEXT
LONGBLOB
LONGTEXT
ENUM
SET
?
_____________

Jeg giver følgende point:
1. Jeg giver 40 point... Grunden til jeg ikke vil give flere er at de fleste har sådan et script, og bare skal rette i det!
2. Jeg giver 10 point... Ikke så svær
3. Jeg giver 20 point...

Jeg giver point til den som kommer med det hurtigste svar, til hverenkelt spm. !
Avatar billede tdaugaard Nybegynder
16. oktober 2001 - 18:04 #1
2. GET bruges til når du vil have form variabler overført via adresselinien.
POST til når det skal \"postes\" til scriptet, dvs. der kan IKKE rettes i variabler undervejs.

GET bruges mest til søgemaskiner, sidevisnings scripts osv. mens POST bruges ved opdatering af f.eks. bruger profiler, uploade af filer osv.

GET har vist begrænsninger på hvor mange data der kan overføres.
Avatar billede myplacedk Nybegynder
16. oktober 2001 - 18:05 #2
\"PHP - hjælp!\" ?
Sidst du spurgte om hjælp her, var emnet \"PHP\".

Det kan altså blive meget bedre!
Det bliver måske nemmere hvis du stiller dine tre spørgsmål, ved at oprette tre spørgsmål!
Avatar billede dennism Nybegynder
16. oktober 2001 - 18:06 #3
-- tdaugaard

OK.. De bruger altså POST på Eksperten! Bare ikke i vores brugerprofil!?
Avatar billede tdaugaard Nybegynder
16. oktober 2001 - 18:07 #4
3.

Fra MySQL SQL referencen:

TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 12 The unsigned range is 0 to 255.

SMALLINT[(M)] [UNSIGNED] [ZEROFILL]
A small integer. The signed range is -32768 to 3276 The unsigned range is 0 to 65535.

MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]
A medium-size integer. The signed range is -8388608 to 838860 The unsigned range is 0 to 16777215.

INT[(M)] [UNSIGNED] [ZEROFILL]
A normal-size integer. The signed range is -2147483648 to 214748364 The unsigned range is 0 to 4294967295.

INTEGER[(M)] [UNSIGNED] [ZEROFILL]
This is a synonym for INT.

BIGINT[(M)] [UNSIGNED] [ZEROFILL]
A large integer. The signed range is -9223372036854775808 to 922337203685477580 The unsigned range is 0 to 18446744073709551615. Note that all arithmetic is done using signed BIGINT or DOUBLE values, so you shouldn\'t use unsigned big integers larger than 9223372036854775807 (63 bits) except with bit functions! Note that \'-\', \'+\', and \'*\' will use BIGINT arithmetic when both arguments are INTEGER values! This means that if you multiply two big integers (or results from functions that return integers) you may get unexpected results if the result is larger than 922337203685477580

FLOAT(precision) [ZEROFILL]
A floating-point number. Cannot be unsigned. precision can be <=24 for a single-precision floating-point number and between 25 and 53 for a double-precision floating-point number. These types are like the FLOAT and DOUBLE types described immediately below. FLOAT(X) has the same range as the corresponding FLOAT and DOUBLE types, but the display size and number of decimals is undefined. In MySQL Version 3.23, this is a true floating-point value. In earlier MySQL versions, FLOAT(precision) always has 2 decimals. This syntax is provided for ODBC compatibility.

FLOAT[(M,D)] [ZEROFILL]
A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -175494351E-38, 0, and 175494351E-38 to 3.402823466E+38. The M is the display width and D is the number of decimals. FLOAT without an argument or with an argument of <= 24 stands for a single-precision floating-point number.

DOUBLE[(M,D)] [ZEROFILL]
A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 7976931348623157E+308. The M is the display width and D is the number of decimals. DOUBLE without an argument or FLOAT(X) where 25 <= X <= 53 stands for a double-precision floating-point number.

DOUBLE PRECISION[(M,D)] [ZEROFILL]

REAL[(M,D)] [ZEROFILL]
These are synonyms for DOUBLE.

DECIMAL[(M[,D])] [ZEROFILL]
An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column: \'\'unpacked\'\' means the number is stored as a string, using one character for each digit of the value. The decimal point and, for negative numbers, the \'-\' sign, are not counted in M. If D is 0, values will have no decimal point or fractional part. The maximum range of DECIMAL values is the same as for DOUBLE, but the actual range for a given DECIMAL column may be constrained by the choice of M and D. If D is left out it\'s set to 0. If M is left out it\'s set to 10. Note that in MySQL Version 3.22 the M argument includes the sign and the decimal point.

NUMERIC(M,D) [ZEROFILL]
This is a synonym for DECIMAL.
DATE
A date. The supported range is \'1000-01-01\' to \'9999-12-31\'. MySQL displays DATE values in \'YYYY-MM-DD\' format, but allows you to assign values to DATE columns using either strings or numbers.

DATETIME
A date and time combination. The supported range is \'1000-01-01 00:00:00\' to \'9999-12-31 23:59:59\'. MySQL displays DATETIME values in \'YYYY-MM-DD HH:MM:SS\' format, but allows you to assign values to DATETIME columns using either strings or numbers.

TIMESTAMP[(M)]
A timestamp. The range is \'1970-01-01 00:00:00\' to sometime in the year 203 MySQL displays TIMESTAMP values in YYYYMMDDHHMMSS, YYMMDDHHMMSS, YYYYMMDD, or YYMMDD format, depending on whether M is 14 (or missing), 12, 8 or 6, but allows you to assign values to TIMESTAMP columns using either strings or numbers. A TIMESTAMP column is useful for recording the date and time of an INSERT or UPDATE operation because it is automatically set to the date and time of the most recent operation if you don\'t give it a value yourself. You can also set it to the current date and time by assigning it a NULL value. See section 3.6 Date and Time Types. A TIMESTAMP is always stored in 4 bytes. The M argument only affects how the TIMESTAMP column is displayed. Note that TIMESTAMP(X) columns where X is 8 or 14 are reported to be numbers while other TIMESTAMP(X) columns are reported to be strings. This is just to ensure that one can reliably dump and restore the table with these types!

TIME
A time. The range is \'-838:59:59\' to \'838:59:59\'. MySQL displays TIME values in \'HH:MM:SS\' format, but allows you to assign values to TIME columns using either strings or numbers.

YEAR[(2|4)]
A year in 2- or 4- digit formats (default is 4-digit). The allowable values are 1901 to 2155, and 0000 in the 4-digit year format, and 1970-2069 if you use the 2-digit format (70-69). MySQL displays YEAR values in YYYY format, but allows you to assign values to YEAR columns using either strings or numbers. (The YEAR type is new in MySQL Version 3.22.)

[NATIONAL] CHAR(M) [BINARY]
A fixed-length string that is always right-padded with spaces to the specified length when stored. The range of M is 1 to 255 characters. Trailing spaces are removed when the value is retrieved. CHAR values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given. NATIONAL CHAR (short form NCHAR) is the ANSI SQL way to define that a CHAR column should use the default CHARACTER set. This is the default in MySQL. CHAR is a shorthand for CHARACTER. MySQL allows you to create a column of type CHAR(0). This is mainly useful when you have to be compliant with some old applications that depend on the existence of a column but that do not actually use the value. This is also quite nice when you need a column that only can take 2 values: A CHAR(0), that is not defined as NOT NULL, will only occupy one bit and can only take 2 values: NULL or \"\".

[NATIONAL] VARCHAR(M) [BINARY]
A variable-length string. NOTE: Trailing spaces are removed when the value is stored (this differs from the ANSI SQL specification). The range of M is 1 to 255 characters. VARCHAR values are sorted and compared in case-insensitive fashion unless the BINARY keyword is given. See section 1 Silent Column Specification Changes. VARCHAR is a shorthand for CHARACTER VARYING.

TINYBLOB
TINYTEXT
A BLOB or TEXT column with a maximum length of 255 (2^8 - 1) characters. See section 1 Silent Column Specification Changes.

BLOB
TEXT
A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters. See section 1 Silent Column Specification Changes.

MEDIUMBLOB
MEDIUMTEXT
A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1) characters. See section 1 Silent Column Specification Changes.

LONGBLOB
LONGTEXT
A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters. See section 1 Silent Column Specification Changes. Note that because the server/client protocol and MyISAM tables has currently a limit of 16M per communication packet / table row, you can\'t yet use this the whole range of this type.

ENUM(\'value1\',\'value2\',...)
An enumeration. A string object that can have only one value, chosen from the list of values \'value1\', \'value2\', ..., or NULL. An ENUM can have a maximum of 65535 distinct values.

SET(\'value1\',\'value2\',...)
A set. A string object that can have zero or more values, each of which must be chosen from the list of values \'value1\', \'value2\', ... A SET can have a maximum of 64 members.
Avatar billede dennism Nybegynder
16. oktober 2001 - 18:08 #5
-- myplacedk

Hvad mener du?

Det sidste spm. jeg har oprettet er ikke i PHP...
Det er http://www.eksperten.dk/spm/121614 !
Avatar billede tdaugaard Nybegynder
16. oktober 2001 - 18:08 #6
dennism, som sagt det er kun eksempler. Her bruges POST fordi der kan postes omkring op til 64K data (tekst) i feltet du skriver din kommentar/dit svar i.
Avatar billede dennism Nybegynder
16. oktober 2001 - 18:10 #7
-- tdaugaard

Kan jeg ikke få nr. 3 på dansk ?
Avatar billede tdaugaard Nybegynder
16. oktober 2001 - 18:11 #8
dennism, for 20 point gider jeg sku ik sidde og bruge lang tid på at oversætte hele lortet ... men det kan være du kan finde en dansk manual ..
Avatar billede dennism Nybegynder
16. oktober 2001 - 18:23 #9
-- tdaugaard

Det er rigtigt!
Kan du lave en Uploader ?
Avatar billede dennism Nybegynder
16. oktober 2001 - 18:25 #10
-- tdaugaard

Du er sikret de 30 point!!
Du mangler jeg kun opg. 1 !

Kunne du forstå hvad myplacedk mente ?
Avatar billede tdaugaard Nybegynder
16. oktober 2001 - 18:25 #11
dennism, sagtens men jeg har ikke tid/lyst .. det er da nok heller ikk svært at finde .. prøv på www.solutions2all.dk under Sources ..
Avatar billede dennism Nybegynder
16. oktober 2001 - 18:27 #12
-- tdaugaard

Kan ikke finde noget!

Men det engelske går nok også...
Avatar billede dennism Nybegynder
16. oktober 2001 - 19:28 #13
synes du jeg skal lukke dette spm. og give dig dine 30 point, og så oprette et nyt med titlen Upload-script ?
Avatar billede tdaugaard Nybegynder
16. oktober 2001 - 19:29 #14
dennism, ville nok være en god idé. Man plejer at nøjes et spørgsmål pr. \"spørgsmål\" af den type.
Avatar billede dennism Nybegynder
16. oktober 2001 - 19:32 #15
Undskyld...! ;-)
Avatar billede dennism Nybegynder
16. oktober 2001 - 19:35 #16
.
Avatar billede myplacedk Nybegynder
17. oktober 2001 - 08:22 #17
dennism >> med \"her\" mente jeg her under PHP...
I øvrigt synes jeg ikke, der er nogen der har forklaret get/post særligt godt... ;-)  Selve pointen er i hvert fald ikke nået frem.
Avatar billede dennism Nybegynder
17. oktober 2001 - 09:13 #18
-- myplacedk

Jeg har forstået det som tdaugaard sagde om det!
Så jo, jeg syntes at det er blevet forklaret godt!

Og hvad mener du med at pointene ikker er nået frem ?
Avatar billede myplacedk Nybegynder
17. oktober 2001 - 09:45 #19
Ikke pointene, men pointen - selve årsagen til, at der findes både GET og POST. :)

Gider ikke lige skrive forklaringen, under emnet \"PHP - hjælp!\", med tre spørgsmål, der er lukket.

Du kan læse lidt om det her:
http://www.faqs.org/faqs/www/cgi-faq/section-37.html

Det er ikke så godt forklaret, men der står da det relevante.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester