Jump to content
#StayAtHome ×

FF2000

New Members
  • Content Count

    2
  • Joined

  • Last visited

Posts posted by FF2000



  1. //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);
    ?>

  2. 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.