
03.02.2018, 18:35
|
|
Guest
Сообщений: n/a
Провел на форуме: 52834
Репутация:
47
|
|
На коленке написал тебе.
script.php
PHP код:
PHP: [COLOR="#000000"][COLOR="#0000BB"][/COLOR][COLOR="#007700"][/COLOR][COLOR="#0000BB"]real_escape_string[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]htmlspecialchars[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]$_POST[/COLOR][COLOR="#007700"][[/COLOR][COLOR="#DD0000"]"name"[/COLOR][COLOR="#007700"]])); [/COLOR][COLOR="#0000BB"]$category[/COLOR][COLOR="#007700"]=[/COLOR][COLOR="#0000BB"]$connect[/COLOR][COLOR="#007700"]->[/COLOR][COLOR="#0000BB"]real_escape_string[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]htmlspecialchars[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]$_POST[/COLOR][COLOR="#007700"][[/COLOR][COLOR="#DD0000"]"category"[/COLOR][COLOR="#007700"]])); [/COLOR][COLOR="#0000BB"]$check[/COLOR][COLOR="#007700"]=[/COLOR][COLOR="#0000BB"]$_POST[/COLOR][COLOR="#007700"][[/COLOR][COLOR="#DD0000"]"check"[/COLOR][COLOR="#007700"]]; [/COLOR][COLOR="#0000BB"]$message[/COLOR][COLOR="#007700"]=[/COLOR][COLOR="#0000BB"]$connect[/COLOR][COLOR="#007700"]->[/COLOR][COLOR="#0000BB"]real_escape_string[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]htmlspecialchars[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]$_POST[/COLOR][COLOR="#007700"][[/COLOR][COLOR="#DD0000"]"message"[/COLOR][COLOR="#007700"]]));
[/COLOR][COLOR="#0000BB"]$query[/COLOR][COLOR="#007700"]=[/COLOR][COLOR="#DD0000"]"INSERT INTO `tablee` (`name`, `cat`, `check`, `message`) VALUES ('[/COLOR][COLOR="#0000BB"]$name[/COLOR][COLOR="#DD0000"]', '[/COLOR][COLOR="#0000BB"]$category[/COLOR][COLOR="#DD0000"]', '[/COLOR][COLOR="#0000BB"]$check[/COLOR][COLOR="#DD0000"]', '[/COLOR][COLOR="#0000BB"]$message[/COLOR][COLOR="#DD0000"]')"[/COLOR][COLOR="#007700"];
if([/COLOR][COLOR="#0000BB"]$connect[/COLOR][COLOR="#007700"]->[/COLOR][COLOR="#0000BB"]query[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]$query[/COLOR][COLOR="#007700"])) { print([/COLOR][COLOR="#DD0000"]"OK"[/COLOR][COLOR="#007700"]); } else { print([/COLOR][COLOR="#DD0000"]"ERROR"[/COLOR][COLOR="#007700"]); } }
[/COLOR][COLOR="#0000BB"]?>[/COLOR][/COLOR]
PHP код:
PHP: [COLOR="#000000"][COLOR="#0000BB"]CREATE TABLE[/COLOR][COLOR="#007700"]`[/COLOR][COLOR="#DD0000"]database[/COLOR][COLOR="#007700"]`.`[/COLOR][COLOR="#DD0000"]tablee[/COLOR][COLOR="#007700"]` ( `[/COLOR][COLOR="#DD0000"]id[/COLOR][COLOR="#007700"]`[/COLOR][COLOR="#0000BB"]INT[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]11[/COLOR][COLOR="#007700"])[/COLOR][COLOR="#0000BB"]NOT NULL AUTO_INCREMENT[/COLOR][COLOR="#007700"], `[/COLOR][COLOR="#DD0000"]name[/COLOR][COLOR="#007700"]`[/COLOR][COLOR="#0000BB"]VARCHAR[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]32[/COLOR][COLOR="#007700"])[/COLOR][COLOR="#0000BB"]NOT NULL[/COLOR][COLOR="#007700"], `[/COLOR][COLOR="#DD0000"]cat[/COLOR][COLOR="#007700"]`[/COLOR][COLOR="#0000BB"]VARCHAR[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]32[/COLOR][COLOR="#007700"])[/COLOR][COLOR="#0000BB"]NOT NULL[/COLOR][COLOR="#007700"], `[/COLOR][COLOR="#DD0000"]check[/COLOR][COLOR="#007700"]`[/COLOR][COLOR="#0000BB"]INT[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]11[/COLOR][COLOR="#007700"])[/COLOR][COLOR="#0000BB"]NOT NULL[/COLOR][COLOR="#007700"], `[/COLOR][COLOR="#DD0000"]message[/COLOR][COLOR="#007700"]`[/COLOR][COLOR="#0000BB"]VARCHAR[/COLOR][COLOR="#007700"]([/COLOR][COLOR="#0000BB"]128[/COLOR][COLOR="#007700"])[/COLOR][COLOR="#0000BB"]NOT NULL[/COLOR][COLOR="#007700"],[/COLOR][COLOR="#0000BB"]PRIMARY KEY[/COLOR][COLOR="#007700"](`[/COLOR][COLOR="#DD0000"]id[/COLOR][COLOR="#007700"]`))[/COLOR][COLOR="#0000BB"]ENGINE[/COLOR][COLOR="#007700"]=[/COLOR][COLOR="#0000BB"]MyISAM CHARSET[/COLOR][COLOR="#007700"]=[/COLOR][COLOR="#0000BB"]utf8 COLLATE utf8_bin[/COLOR][COLOR="#007700"];[/COLOR][/COLOR]
Сам под свою форму переделай.
|
|
|
|