i post code , result, may 1 can help..
if (isset($_get['id']) && is_numeric($_get['id']) && $_get['id'] > 0) { $id = $_get['id']; echo $login_session_id.$id; include('config.php'); set_time_limit(59); $resultedit = mysql_query($db,"select * rubrica id_utente = '$login_session_id' , id_dispositivo='$id' ")or die(mysql_error());; if (!$resultedit) { die('invalid query: ' . mysql_error()); } if(mysqli_num_rows($resultedit)==1) { echo 'fatto'; while($row = $resultedit ->fetch_assoc()) { echo 'fatto'; $id=$row['id_dispositivo']; $username = $row['username']; $email= $row['email']; $cellulare= $row['mobile']; $casa= $row['home']; $lavoro= $row['work']; renderform($id, $username, $email,$cellulare,$casa,$lavoro,$error); } } else { echo "no results!"; } } else { echo 'error!'; } } result page:
21 18 <---correct! i try directly query , found 1 row want, why here don't go? while test.
all code ->
<?php include('session.php'); ?> <!doctype html> <html> <head> <title>controlpannel</title> <!-- jquery--> <script src="/web/js/jquery.min.js"></script> <!-- custom theme files --> <!--theme-style--> <link href="/web/css/style.css" rel="stylesheet" type="text/css" media="all" /> <!--//theme-style--> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <meta name="keywords" content="panello di controllo applicazione" /> <script type="application/x-javascript"> addeventlistener("load", function() { settimeout(hideurlbar, 0); }, false); function hideurlbar(){ window.scrollto(0,1); } </script> <!--fonts--> <link rel="icon" href="/web/images/logob.png"> <!--//fonts--> </head> <body> <div class="header"> <!----> <div class="header-left"> <div class="logo"> <a href="index.html"><img src="/web/images/logo.png" alt=""></a> </div> <div class="top-nav"> <ul > <li><h1>welcome <?php echo $user_check_email; ?></h1> </li> <li class="active" ><a href="" >rubrica</a></li> <li><a href="promemoria.php" class="black" > promemoria</a></li> <li><a href="sos.php" class="black1"> sos</a></li> <li><a href="imp.php" class="black2" > impostazioni</a></li> <li><a href="logout.php" class="black2" > logout</a></li> </ul> </div> <p class="footer-class">template <a href="" target="_blank">42studios</a> </p> </div> <!----> <!----> <div class="header-top"> <div class="logo-in"> <a href="index.html"><img src="/web/images/logo.png" alt=""></a> </div> <div class="top-nav-in"> <span class="menu"><img src="/web/images/menu.png" alt=""> </span> <ul > <li class="active" ><a href="" >rubrica</a></li> <li><a href="promemoria.php" class="black" > promemoria</a></li> <li><a href="sos.php" class="black1"> sos</a></li> <li><a href="imp.php" class="black2" > impostazioni</a></li> <li><a href="logout.php" class="black2" > logout</a></li> </ul> <script> $("span.menu").click(function(){ $(".top-nav-in ul").slidetoggle(500, function(){ }); }); </script> </div> <div class="clear"> </div> </div> <!----> <div class="content"> <div class="block"> <?php function renderform($id, $username, $email,$cellulare,$casa,$lavoro,$error) { if ($error != '') { echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>'; } ?> <form action="" method="post"> <input type="hidden" name="id" value="<?php echo $id; ?>"/> <div> <p><strong>id:</strong> <?php echo $id; ?></p> <strong>username: *</strong> <input type="text" name="username" value="<?php echo $username; ?>" /><br/> <strong>email: *</strong> <input type="text" name="email" value="<?php echo $email; ?>" /><br/> <strong>cellulare: *</strong> <input type="text" name="mobile" value="<?php echo $cellulare; ?>" /><br/> <strong>casa: *</strong> <input type="text" name="home" value="<?php echo $casa; ?>" /><br/> <strong>lavoro: *</strong> <input type="text" name="work" value="<?php echo $lavoro; ?>" /><br/> <p>* required</p> <input type="submit" name="submit" value="submit"> </div> </form> <?php } include('config.php'); if (isset($_post['submit'])) { echo '1'; if (is_numeric($_post['id'])) { $id = $_post['id']; $username = mysql_real_escape_string(htmlspecialchars($_post['username'])); $email = mysql_real_escape_string(htmlspecialchars($_post['email'])); $cellulare = mysql_real_escape_string(htmlspecialchars($_post['mobile'])); $casa= mysql_real_escape_string(htmlspecialchars($_post['home'])); $lavoro = mysql_real_escape_string(htmlspecialchars($_post['work'])); if ($username == '') { $error = 'error: please fill in required fields!'; renderform($id, $username, $email,$cellulare,$casa,$lavoro,$error); } else { // save data databaserubrica id_utente = '$login_session_id' mysql_query($db,"update rubrica set username='$username',mobile='$cellulare',home='$casa',work='$lavoro',email='$email' id_utente = '$login_session_id' , id_dispositivo='$id'")or die(mysql_error()); header("location: rubrica.php"); } } else { echo 'error!'; } } else { include('config.php'); if ((isset($_get['id'])) && (is_numeric($_get['id'])) && ($_get['id'] > 0)) { $id = $_get['id']; echo $login_session_id.$id; set_time_limit(59); $resultedit = mysql_query($db,"select * rubrica id_utente = '$login_session_id' , id_dispositivo='$id' ")or die(mysql_error());; if (!$resultedit) { die('invalid query: ' . mysql_error()); } if(mysqli_num_rows($resultedit)==1) { echo 'fatto'; while($row = $resultedit ->fetch_assoc()) { echo 'fatto'; $id=$row['id_dispositivo']; $username = $row['username']; $email= $row['email']; $cellulare= $row['mobile']; $casa= $row['home']; $lavoro= $row['work']; renderform($id, $username, $email,$cellulare,$casa,$lavoro,$error); } } else { echo "no results!"; } } else { echo 'error!'; } } ?> ///query <div id="risultato"></div> </div> </div> <div class="clear"> </div> <p class="footer-class-in">copyright © 2015 template <a href="" target="_blank">42studios</a> </p> </div> </body> </html> 
select return null
some issues see directly in code.
1). include files should on top of file. include , required files should @ top.
2). if statement not correct. should use () conditions.
3). function mysql_query accepts parameters in way :-
mysql_query(query, connection) so final code should :-
<?php include('config.php'); if ((isset($_get['id'])) && (is_numeric($_get['id'])) && ($_get['id'] > 0)) { $id = $_get['id']; echo $login_session_id.$id; set_time_limit(59); $resultedit = mysql_query("select * rubrica id_utente = '$login_session_id' , id_dispositivo='$id' ", $db)or die(mysql_error());; if (!$resultedit) { die('invalid query: ' . mysql_error()); } if(mysqli_num_rows($resultedit)==1) { echo 'fatto'; while($row = $resultedit ->fetch_assoc()) { echo 'fatto'; $id=$row['id_dispositivo']; $username = $row['username']; $email= $row['email']; $cellulare= $row['mobile']; $casa= $row['home']; $lavoro= $row['work']; renderform($id, $username, $email,$cellulare,$casa,$lavoro,$error); } } else { echo "no results!"; } } else { echo 'error!'; } } ?> 
Comments
Post a Comment