Results 1 to 10 of 10
Thread: php + mysql qyery -
Hybrid View
-
16th February 2011 23:40 #1
php + mysql qyery -
,
:
bla.php :Code:<html>... <form method=post action=bla.php> <input type=text name="UN" value="" size=40> <br><input type=submit value="submit> </form> </html>
, -. , echo. , , echo $UN , , - , . . ilo_user varchar(255), text(255) , . ?Code:<?php include 'db.php'; // , sql- - $UN = $_POST[UN]; if ($UN != "") {$query_setuser = "UPDATE serverdata SET ilo_user=".$UN; } else {$query_setuser = "UPDATE serverdata SET ilo_user=ilouser";}; $result_setuser = mysql_query($query_setuser); echo $UN; //header("Location: ie_index.htm"); ?>
,
P.S. ?!?Last edited by vlex; 16th February 2011 at 23:45. Reason: ...
-
16th February 2011 23:45 #2
:
.. .UPDATE serverdata SET ilo_user = '".$UN."'
.
-
16th February 2011 23:52 #3
"".
$_POST[UN] $_POST['UN']; PHP UN POST. , .
, isset($_POST['UN']), .
, if ($UN != "") ?
4-, : UPDATE serverdata SET ilo_user=ilouser ? ilouser?
, {$query_setuser = "UPDATE serverdata SET ilo_user=".$UN; - , , ilo_user - ?
, z0ne , $UN .
-
16th February 2011 23:54 #4
:
$query_setuser = "UPDATE serverdata SET ilo_user=".'$UN' ; -
$query_setuser = "UPDATE serverdata SET ilo_user=".'".$UN."' ; - ... .$UN.
$query_setuser = 'UPDATE serverdata SET ilo_user='.'".$UN."' ; - same shit..
?
-
16th February 2011 23:57 #5
, .
, :
$query_setuser = "UPDATE serverdata SET ilo_user='" . $UN . "'";
-:
$query_setuser = "UPDATE serverdata SET ilo_user='" . mysql_real_escape_string($UN) . "'";
-
17th February 2011 00:03 #6
@tedych:
1) , , - .
2) isset() - ,
3)
4)
'ilouser' 'ilouser'..
5)
---------- 01:01 ---------- 00:59 ----------
... , , , . mysql_real_escape_string() .

---------- 01:03 ---------- 01:01 ----------
?
"UPDATE serverdata SET ilo_user=' " . mysql_real_escape_string($UN) . " ' ";
-
17th February 2011 00:11 #7
mysql-a (). PHP.
, PHP , . , , .
:
UPDATE serverdata SET ilo_user='tuk_stojnostta_na_UN'
mysql .
, $query_setuser,
$query_setuser = "UPDATE serverdata SET ilo_user='" . $UN . "'";
, ' , $UN, , hence . " ' ";
- mysql_real_escape_string() , . - "" .
, , ,
, , , ..
-
17th February 2011 06:47 #8
-
17th February 2011 15:43 #9Registered User
Join Date: Jul:2005
Location: Sofiq
Posts: 2,798
Komodo Edit, PHP, CSS, HTML, JavaScript, . , .
. WHERE.Code:include 'db.php'; // , sql- - $UN = trim(strip_tags($_POST['UN'])); $UN = mysql_real_escape_string(!empty($UN) ? $UN : 'ilouser'); $result_setuser = mysql_query("UPDATE serverdata SET ilo_user='$UN'"); echo $UN; //header("Location: ie_index.htm");
-
17th February 2011 01:12 #10




Reply With Quote
. , . 
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in