Jump to content

FF2000

New Members
 View Profile  See their activity

  • Posts

    2

  • Joined

  • Last visited

 Content Type 

Posts posted by FF2000

    Update data after MySQL select

    in PHP Coding Help

    Posted 


    
//Userinfo-modify.php

    
<?php
    
include_once('db.php');
    
$name = $_POST['nev'];
    
$country = $_POST['megye'];
    
$error = "";
    
$city = "";
    
$nodata = "";
    
$ID = 0;

    
if (($country=="Bács-Kiskun")||($country=="Baranya")||($country=="Békés")||($country=="Borsod-Abaúj-Zemplén")||($country=="Csongrád")||
    
($country=="Fejér")||($country=="Győr-Moson-Sopron")||($country=="Hajdú-Bihar")||($country=="Heves")||($country=="Jász-Nagykun-Szolnok")||
    
($country=="Komárom-Esztergom")||($country=="Nógrád")||($country=="Pest")||($country=="Somogy")||($country=="Szabolcs-Szatmár-Bereg")||
    
($country=="Tolna")||($country=="Vas")||($country=="Veszprém")||($country=="Zala"))
    
	{	$city = $_POST['telepules'];
    
		if ($city=="---") $error = "-city";
    
		}
    
	else
    
	{	$error = "-country-city";
    
		}

    
mysqli_set_charset($conn,"utf8");

    
if (($city!="") AND ($name!="")) 
    
{	$query = mysqli_query($conn,"SELECT nev,kor,megye,telepules,utca,mobil,email FROM `nrqadatr` WHERE nev='$name' AND telepules='$city'") 
    
or die("userinfo-modify-36 ".mysqli_error($conn));}	
    
	else
    
		if (($city=="") AND ($name=="")) 
    
		{
    
		$nodata = '1';
    
		echo "Name and city = 0!";
    
		}
    
		else
    
		if (($city!="") AND ($name=="")) 
    
		{$query = mysqli_query($conn,"SELECT nev,kor,megye,telepules,utca,mobil,email FROM `nrqadatr` WHERE telepules='$city'") or die("userinfo-modify-45 ".mysqli_error($conn));}	

    
			else
    
			if (($city=="") AND ($name!="")) 
    
			{$query = mysqli_query($conn,"SELECT nev,kor,megye,telepules,utca,mobil,email FROM `nrqadatr` WHERE nev='$name'") or die("userinfo-modify-49 ".mysqli_error($conn));}	
    
if ($nodata!='1')	
    
	{
    
	$rowcount=mysqli_num_rows($query);
    
	if ($rowcount>0) 
    
	{
    
	echo '<table>';
    
	$arrayofrows = array();
    
	echo '
    
	<table border=1>
    
	<tr style="background-color:#EFFBFB; font-weight:bold; border: 1px solid black;">
    
	<td style="font-size:14px;">ID</td>
    
	<td style="font-size:14px;">Name</td>
    
	<td style="font-size:14px;">City</td>
    
	<td style="font-size:14px;">Age</td>								<td style="font-size:14px;">Address</td>
    
	<td style="font-size:14px;">Mobil</td>
    
	<td style="font-size:14px;">E-mail</td>
    
	<td style="font-size:14px;">Operation</td>							</tr>';
    
	}
    
	else
    
	echo "\r\n<B><font color='red'>A megadott feltételekkel nincsenek adatok.";
    
	while ($data = mysqli_fetch_array($query))
    
	{
    
	$ID = $ID+1;
    
	$data_nev=$data["nev"];
    
	echo '
    
	<tr style="background-color:#EFFBFB; border: 1px solid black;">
    
	<td><input type="radio" name="$kivalasztott_sor" value="AG"></td>				<td style="font-size:14px;">'.$data["nev"].'</td>
    
	<td style="font-size:14px;">'.$data["telepules"].'</td>	
    
	<td style="font-size:14px;">'.$data["kor"].'</td>						<td style="font-size:14px;">'.$data["utca"].'</td>						<td><input type="text" value='.$data["mobil"].'></td>
    
	<td><input type="text" value='.$data["email"].'></td>
    
	<td onclick="cellOnclick()"><a href="#" onclick="linkOnclick()" style="text-decoration: none;">
    
	<input type=button value="UPDATE" myFunction(this); return false;"></button></td>	
    
	</tr>';
    
	}
    
	echo '</table>';
    
}
    
unset($name);
    
unset($kor);
    
unset($country);
    
unset($error);
    
unset($city);
    
unset($nodata);
    
unset ($data_nev);
    
?>

    Update data after MySQL select

    in PHP Coding Help

    Posted

    Hi,

    I am absolutly beginner in PHP, AJAX. In my Wordpress page I have following scene:

    1. input box for name

    2. combobox from country-> combo for cities depend of selected country

    Button for search in MySQL database

     

    After submit the database return result in a table (user, country, city, mobile, email, etc.) with 2 editable (mobile, email) input column and I put Update button in every row.

     

    My questions:

    1) If I change one data on the editable column how can I know the number of row?

    2) How can I run the update script without refresh page?

     

    Thanks for your answer. 

    //UserInfo-modify.php

<?php
include_once('db.php');
$name = $_POST['nev'];
$country = $_POST['megye'];
$error = "";
$city = "";
$nodata = "";
$ID = 0;

if (($country=="Bács-Kiskun")||($country=="Baranya")||($country=="Békés")||($country=="Borsod-Abaúj-Zemplén")||($country=="Csongrád")||
($country=="Fejér")||($country=="Győr-Moson-Sopron")||($country=="Hajdú-Bihar")||($country=="Heves")||($country=="Jász-Nagykun-Szolnok")||
($country=="Komárom-Esztergom")||($country=="Nógrád")||($country=="Pest")||($country=="Somogy")||($country=="Szabolcs-Szatmár-Bereg")||
($country=="Tolna")||($country=="Vas")||($country=="Veszprém")||($country=="Zala"))
	{	$city = $_POST['telepules'];
		if ($city=="---") $error = "-city";
		}
	else
	{	$error = "-country-city";
		}
	
mysqli_set_charset($conn,"utf8");

if (($city!="") AND ($name!="")) 
{	$query = mysqli_query($conn,"SELECT nev,kor,megye,telepules,utca,mobil,email FROM `nrqadatr` WHERE nev='$name' AND telepules='$city'") or die("userinfo-modify-36 ".mysqli_error($conn));}	
	else
		if (($city=="") AND ($name=="")) 
		{
			$nodata = '1';
			echo "Name and city = 0!";
			}
		else
			if (($city!="") AND ($name=="")) 
			{	$query = mysqli_query($conn,"SELECT nev,kor,megye,telepules,utca,mobil,email FROM `nrqadatr` WHERE telepules='$city'") or die("userinfo-modify-45 ".mysqli_error($conn));}	
	
			else
				if (($city=="") AND ($name!="")) 
				{$query = mysqli_query($conn,"SELECT nev,kor,megye,telepules,utca,mobil,email FROM `nrqadatr` WHERE nev='$name'") or die("userinfo-modify-49 ".mysqli_error($conn));}	
if ($nodata!='1')	
	{

				$rowcount=mysqli_num_rows($query);
						if ($rowcount>0) 
						{
		
							echo '<table>';
							$arrayofrows = array();
							echo '
							<table border=1>
							  <tr style="background-color:#EFFBFB; font-weight:bold; border: 1px solid black;">
							  <td style="font-size:14px;">ID</td>
							  <td style="font-size:14px;">Name</td>
								<td style="font-size:14px;">City</td>
								<td style="font-size:14px;">Age</td>							
								<td style="font-size:14px;">Address</td>
								<td style="font-size:14px;">Mobil</td>
								<td style="font-size:14px;">E-mail</td>
								<td style="font-size:14px;">Operation</td>								
							  </tr>';
						}
						else
							echo "\r\n<B><font color='red'>No data

    //my_script.js
$("#sub").click( function() {
 $.post( $("#myForm").attr("action"), 
         $("#myForm :input").serializeArray(), 
         function(info)
		 { $("#result").html(info); 
   });
 clearInput();
});
 
$("#myForm").submit( function() {
  return false;	
});
 
function clearInput() {
	$("#myForm :input").each( function() {
	   $(this).val('');
	});
}

    .";
			

							while ($data = mysqli_fetch_array($query))
							{
							$ID = $ID+1;
							$data_nev=$data["nev"];
							echo '
							  <tr style="background-color:#EFFBFB; border: 1px solid black;">
							  
								<td><input type="radio" name="$kivalasztott_sor" value="AG"></td>						  
								<td style="font-size:14px;">'.$data["nev"].'</td>
								<td style="font-size:14px;">'.$data["telepules"].'</td>	
								<td style="font-size:14px;">'.$data["kor"].'</td>									
								<td style="font-size:14px;">'.$data["utca"].'</td>								
								<td><input type="text" value='.$data["mobil"].'></td>
								<td><input type="text" value='.$data["email"].'></td>
								<td onclick="cellOnclick()"><a href="#" onclick="linkOnclick()" style="text-decoration: none;">
								<input type=button value="UPDATE" myFunction(this); return false;"></button></td>	
					
							  </tr>';
							}
							echo '</table>';
}
unset($name);
unset($kor);
unset($country);
unset($error);
unset($city);
unset($nodata);
unset ($data_nev);
?>

    //Wordpress (main) page
[insert_php] include '/select_list_cities.php'; [/insert_php] 
<html><head><meta charset="utf-8" /><script src="/ajax_select_cities.js" type="text/javascript"></script>
</head><body><form id="myForm" action="/userInfo-modify.php" method="post">
Name*:<br><input type="text" name="nev">
<p> [insert_php] 
echo $re_html;[/insert_php]<br class="clear" />
<br class="clear" />
<button id="sub">Search</button>
<br><br></form>
<span id="result"></span>
<div id="data"><?php echo $result; ?></div>
<script type="text/javascript" 
src=" http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.1.min.js"></script>
<script src="/my_script.js" type="text/javascript"></script>
</body>
</html>

    php_search.jpg

     

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.