PHP - Getting My Ajax To Pull The Correct Page Results For Lazy Loading.

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=357605.0

I am creating a library app (personal dev) and have ran into some trouble. I'm very new to Ajax and Php   I have a page named addEntryISBN which shows the results of a user search in a div named #results. I want to post the contents of #results to my database. The contents of #results comes from a page named searchISBN.   What is the most effective way of doing this? My code so far is aas follows;   addEntryISBN.php

$(document).ready(function() {
        $('form').on('submit', function (e) {
          e.preventDefault();
          $.ajax({
            type: 'post',
            url: 'searchIsbn.php',
            data: $('form').serialize(),
            success: function (result) { 
            $('.result').html(result);
            }    
          });
return true;
        });
});

<div class="result"</div>

 

Hey guys I am having a bit of a hard time understanding how I can fetch data from my SQL table using AJAX and jQuery, I am sorry if this isn't the right place to post this however I usually get great support here.   I am trying to recreate this filter on the right of the page: http://www.autotrade...arch/used/cars/   So basically I have this code to display the whole MySQL table into a list:

<?php while($row = $results->fetch(PDO::FETCH_ASSOC))
	  {
      echo '
	    <div class="listing-container">
	      <h3 class="model-listing-title clearfix">'.$row["Make"].' '.$row["Model"].' '.$row["Variant"].'</h3>
	      <h3 class="price-listing">£'.number_format($row['Price']).'</h3>
	    </div>
	    <div class="listing-container-spec">
		 <img src="'.(explode(',', $row["PictureRefs"])[0]).'" class="stock-img-finder"/>
		  <div class="ul-listing-container">
		    <ul class="overwrite-btstrp-ul">
		      <li class="diesel-svg list-svg">'.$row["FuelType"].'</li>
		      <li class="saloon-svg list-svg">'.$row["Bodytype"].'</li>
		      <li class="gear-svg list-svg">'.$row["Transmission"].'</li>
		      <li class="color-svg list-svg">'.$row["Colour"].'</li>
		    </ul>
		  </div>
		  <ul class="overwrite-btstrp-ul other-specs-ul h4-style">
		    <li>Mileage: '.number_format($row["Mileage"]).'</li>
		    <li>Engine size: '.$row["EngineSize"].'cc</li>
		  </ul>
		  <button href="#" class="btn h4-style checked-btn hover-listing-btn"><span class="glyphicon glyphicon-ok"></span> History checked 
		  </button>
		  <button href="#" class="btn h4-style more-details-btn hover-listing-btn tst-mre-btn"><span class="glyphicon glyphicon-list"></span> More details 
		  </button>
		  <button href="#" class="btn h4-style test-drive-btn hover-listing-btn tst-mre-btn"><span class="test-drive-glyph"></span> Test drive 
		  </button>
		  <h4 class="h4-style listing-photos-count"><span class="glyphicon glyphicon-camera"></span> 5 More photos</h4>
	    </div>
	      ';
      } ?>

As you can see I am using a while loop to display the whole contents of the table into lists, this includes vehicle data.   I also have this bit of HTML that I will be using as a form to filter the results:

<form class="car-finder-container dflt-container">
	     <h2 class="h2-finder">Car finder</h2>
		 <ul class="toggle-view">
		   <li class="li-toggle">
		    <h4 class="h4-finder-toggle">Make<span class="glyphicon glyphicon-plus glyph-plus-toggle"></span></h4>
		    <div class="panel">
			 <select class="form-control select-box">
				 <option value="make-any">Make (Any)</option>
				 <option value="two">Two</option>
				 <option value="three">Three</option>
				 <option value="four">Four</option>
				 <option value="five">Five</option>
	         </select>
			 <select class="form-control last-select select-box">
				 <option value="model-any">Model (Any)</option>
				 <option value="two">Two</option>
				 <option value="three">Three</option>
				 <option value="four">Four</option>
				 <option value="five">Five</option>
	         </select>
		    </div>
		   </li>
		   <li class="li-toggle">
		    <h4 class="h4-finder-toggle">Body type<span class="glyphicon glyphicon-plus glyph-plus-toggle"></span></h4>
		    <div class="panel">
			 <input id="four-by-four-checkbox" class="float-checkbox" type="checkbox"/>
			 <label for="four-by-four-checkbox" class="label-checkbox">4x4</label>
			 <input id="convertible-checkbox" class="float-checkbox" type="checkbox"/>
			 <label for="convertible-checkbox" class="label-checkbox">Convertible</label>
			 <input id="coupe-checkbox" class="float-checkbox" type="checkbox"/>
			 <label for="coupe-checkbox" class="label-checkbox">Coupe</label>
		    </div>
		  </li>
		  <li class="li-toggle">
		    <h4 class="h4-finder-toggle">Transmission<span class="glyphicon glyphicon-plus glyph-plus-toggle"></span></h4>
		    <div class="panel">
			 <input id="automatic-checkbox" class="float-checkbox" type="checkbox"/>
			 <label for="automatic-checkbox" class="label-checkbox">Automatic</label>
			 <input id="manual-checkbox" class="float-checkbox" type="checkbox"/>
			 <label for="manual-checkbox" class="label-checkbox">Manual</label>
			 <input id="semi-auto-checkbox" class="float-checkbox" type="checkbox"/>
			 <label for="semi-auto-checkbox" class="label-checkbox">Semi automatic</label>
		    </div>
		  </li>
		</ul>
		 <button href="#" class="btn btn-block car-search-button btn-lg btn-success"><span class="glyphicon car-search-g glyphicon-search"></span> Search cars 
		 </button>
		 <h4 class="h4-finder"><a href="#">Try our Smart Search </a><span class="glyphicon info-car-search-g glyphicon-info-sign"></span></h4>
	   </form>

I have noticed that JS and Ajax give a great user experience when it comes to filtering search results, in this HTML template I have added some select elements and check boxes and I am now really stuck.   Does anybody know how I can make exceptions to what SQL results are returned to the front end or know of any tutorials?   Thanks    

hi all,

i have a profile page which is a form that asks users to enter there personal details such as name, location, mobile number etc and saves this info with a mysql database, however when you return to the edit profile page the fields are blank and i want them to pull the details the user has entered (if any) and display it, so if a user entered there name as Lee, then returned to the edit profile page there name field would show lee instead of being empty.

heres my profiles page code, any help would be great

Code: [Select]
<?PHP

session_start();

if (!(isset($_SESSION['username']) && $_SESSION['username'] != '')) {
header ("Location: login.php");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!--
Author: Reality Software
Website: http://www.realitysoftware.ca
Note: This is a free template released under the Creative Commons Attribution 3.0 license,
which means you can use it in any way you want provided you keep the link to the author intact.
-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<link href="style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.auto-style2 {
font-size: 25px;
}
</style>
</head>
<body>
<div id="container">
<!-- header -->
    <div id="header">
    <div id="logo"><a href="#"><span class="orange">SouthWest</span> LAN's</a></div>
        <div id="menu">
        <ul>
            <li><a href="index.php">home</a></li>
            <li><a href="register.php">Register</a></li>
            <li><a href="account.php">My Account</a></li>
            <li><a href="forum.php">Forums</a></li>
            <li><a href="faq.php">FAQ</a></li>
            </ul>
        </div>
    </div>
    <!--end header -->
    <!-- main -->
    <div id="main">
        <div id="content">
        <div id="head_image">
        <div id="slogan"><strong><span class="auto-style2">Organising LAN Parties in the SouthWest</span></strong><br /></div>
            <div id="under_slogan_text"></div>
        </div>
        <div id="text">
        <h1>Edit Profile</h1>
        <br />
        <form name="register" method="post" action="process_p.php">
<table border="0" width="225" align="center">
    <tr>
        <td width="219" bgcolor="#999999">
            <p align="center"><font color="white"><span style="font-size:12pt;">Please fill out as much as possible</span></font></p>
        </td>
    </tr>
    <tr>
        <td width="219">
            <table border="0" width="282" align="center">
                    <tr>
                        <td width="116"><span style="font-size:10pt;">Username: </span></td>
                        <td width="156"><?php echo $_SESSION['username']; ?></td>
                    </tr>
                    <tr>
                        <td width="116"><span style="font-size:10pt;">Email: </span></td>
                        <td width="156"><input type="text" name="email" maxlength="30"></td>
                    </tr>
                <tr>
                    <td width="116"><span style="font-size:10pt;">Real Name: </span></td>
                    <td width="156"><input type="text" name="real_name"></td>
                </tr>
                <tr>
                    <td width="116"><span style="font-size:10pt;">Location: </span></td>
                    <td width="156"><input type="text" name="location"></td>
                </tr>
                <tr>
                    <td width="116"><span style="font-size:10pt;">Mobile Number: </span></td>
                    <td width="156"><input type="text" name="mobile_number"></td>
                </tr>
                <tr>
                    <td width="116"><span style="font-size:10pt;">Instant Messager: </span></td>
                    <td width="156"><input type="text" name="instant_messaging"></td>
                </tr>
                <tr>
                    <td width="116">&nbsp;</td>
                        <td width="156">
                            <p align="right"><input type="submit" name="update" value="Update Profile"></p>
                        </td>
                </tr>
            </table>

This is the link to pull the page

http://127.0.0.1/kudos/?viewkudoid=###

This is the kudo-function.php page

function get_kudo_info($viewkudoid){
	global $wpdb;
    $tablename=acikudos_table_name();
    $viewsql = "SELECT * FROM $tablename WHERE kudoid='$viewkudoid'";
	$viewresult = $wpdb->get_results($viewsql);
    #$vewrow = mysql_fetch_assoc($viewresult);

    return $viewresult;
}

This is the kudo-view.php page

function show_kudos($viewkudoid)
{
   global $wpdb;
   
   $viewkudoid = $_GET['viewkudoid'];
   
   $getthekudo = get_kudo_info($viewkudoid);

    if ($viewkudoid == $getthekudo['kudoid']) {
        
		echo 'Congratulations, you have successfully fixed it!';
    } else {
    echo 'Everything is displayed';
}
	} 

 add_shortcode( 'kudosview', 'show_kudos' );

I know the issue is right in front of me but I can not find it.

When I click on the letter of the alphabet on my form page, it will bring up the results of my query.  I got this part working.  The next part is to be able to click on any of the populated results and have it autofill my form with organization, first name, last name, email address and phone number.   I know that I need to use Ajax and jQuery to accomplish this.    Here is my html

<!-- Letter Search -->
<div class="searchBox span12">

	<h3>Choose the First Letter of the Person's Last Name</h3>
	<ul>
        <li class="alphabets" id="A"><a href="?by=A">A</a></li>
        <li class="alphabets" id="B"><a href="?by=B">B</a></li>
        <li class="alphabets" id="C"><a href="?by=C">C</a></li>
        <li class="alphabets" id="D"><a href="?by=D">D</a></li>
        <li class="alphabets" id="E"><a href="?by=E">E</a></li>
        <li class="alphabets" id="F"><a href="?by=F">F</a></li>
        <li class="alphabets" id="G"><a href="?by=G">G</a></li>
        <li class="alphabets" id="H"><a href="?by=H">H</a></li>
        <li class="alphabets" id="I"><a href="?by=I">I</a></li>
        <li class="alphabets" id="J"><a href="?by=J">J</a></li>
        <li class="alphabets" id="K"><a href="?by=K">K</a></li>
        <li class="alphabets" id="L"><a href="?by=L">L</a></li>
        <li class="alphabets" id="M"><a href="?by=M">M</a></li>
        <li class="alphabets" id="N"><a href="?by=N">N</a></li>
        <li class="alphabets" id="O"><a href="?by=O">O</a></li>
        <li class="alphabets" id="P"><a href="?by=P">P</a></li>
        <li class="alphabets" id="Q"><a href="?by=Q">Q</a></li>
        <li class="alphabets" id="R"><a href="?by=R">R</a></li>
        <li class="alphabets" id="S"><a href="?by=S">S</a></li>
        <li class="alphabets" id="T"><a href="?by=T">T</a></li>
        <li class="alphabets" id="U"><a href="?by=U">U</a></li>
        <li class="alphabets" id="V"><a href="?by=V">V</a></li>
        <li class="alphabets" id="W"><a href="?by=W">W</a></li>
        <li class="alphabets" id="X"><a href="?by=X">X</a></li>
        <li class="alphabets" id="Y"><a href="?by=Y">Y</a></li>
        <li class="alphabets" id="Z"><a href="?by=Z">Z</a></li>
     </ul>
     	<? include('search.php'); ?>
    
</div>
     
<hr style="color:#ccc; margin-bottom:20px;" />

<!-- Main Form -->

<div id="mainForm">
	<form method="post" id="icsForm" class="searchBox span12">
    	     <div id="col1" class"span6">
    	           <h3>Contact Information</h3>
                        <label>Church / Organization:</label><input type="text" name="organization" id="organization" class="span6 upright" /><br />
		        <label>First Name:</label><input type="text" name="firstName" id="firstName" class="span6 upright" />
                        <label>Last Name:</label><input type="text" name="lastName" id="lastName" class="span6 left upright" />
                        <label>Email Address:</label><input type="text" name="email" id="email" class="span6 left upright" />
                        <label>Phone Number:</label><input type="text" name="phone" id="phone" class="span6 left upright" />
        </div>
</div>

Here is my php

if(preg_match("/^[A-Z | a-z]+/", $_POST['name'])){
$name=$_POST['name'];
}

if(isset($_GET['by'])){
$letter=$_GET['by'];

//query to sort by last name

$sql="SELECT contact_id, first_name, last_name, church_org, email_address, phone_number FROM ics_data WHERE last_name LIKE '$letter%' ORDER BY last_name ASC";

//run the query against the mysql query function
$result=mysql_query($sql); 

//count results
$numrows=mysql_num_rows($result);

echo "<p>" .$numrows . " results found for " . $letter . "</p>"; 

//Create while loop and loop through result set
while($row=mysql_fetch_array($result)){

        $first_name=$row['first_name'];
	$last_name=$row['last_name'];
	$church_org=$row['church_org'];
	$email_address=$row['email_address'];
	$phone_number=$row['phone_number'];
	$contact_id=$row['contact_id'];
	
//display the result of the array

echo "<div id=\"search-results\">";
echo "<ul class=\"letter-results\">\n"; 
echo "<li class=\"result-row\">" . "<a href=\"#\" class=\"testclass\">"  .$first_name . " " .$last_name . "". ", &nbsp;" ."" .$church_org ."</a></li>\n";
echo "</ul>";
echo "</div>";
}
}

Here is my Javascript file (Ajax)

$(document).ready( function() {
	function formfill() {
		var organization = $('#organization').val();
		var firstname = $('#firstname').val();
		var lastname = $('#lastname').val();
		var email = $('#email').val();
		var phone = $('#phone').val();
		$.ajax ({
			method: "GET",
			url: "search.php",
			dataType: 'json',
			data: {
				organization:organization, firstname:firstname, lastname:lastname, email:email, phone:phone
			},
			type: "POST",
			success: function(data) {
				$organization
				$firstname
				$lastname
				$email
				$phone
			},
			
	 	failu  function() {
                alert('fail!');
            }
        });
	}
  

I know that I do not have a reference yet to JSON in my php file and that it is needed.  I'm not solid on the Ajax part.  That is the part that is tripping me up.  I know that I need to make the form autofill when clicking on a specific result returned from my query... but i'm not sure how to do that.   Thank you in advance for any help or advice you can give!!   I am relatively new to programming.  Hopefully I posted this in the right forum as a lot of these technologies overlap.
Edited by kjetterman, 26 September 2014 - 10:23 AM.

Hi. 

I’m hoping someone can help me pull the styling/formatting from a static page onto a category template.  The content is pulling fine, but it's not formatted/styled.

Code used to pull content from static page onto custom category template:

<?php $page = get_page_by_title( 'page-name' );
$content = apply_filters('the_content', $page->post_content);  
echo $content; ?>

With the above code, the content is being pulled, but the formatting and styling is not being pulled.

The following code is adapted to pull the styling/formatting:

<?php $page = get_page_by_title( 'Wedding Venues in Costa Rica' );
$content = apply_filters('the_content', $page->post_content); 
echo do_blocks( $content );>


It did not pull the styling/formatting.

We’re using GeneratePress Pro + Generate Blocks (no page builder).  The static page is built with Gutenberg and GenerateBlocks.

By the way, I'mm not a coder or a developer.  I know a little about this and about that, but this isn't my field of expertise.  

Could someone please suggest what can be done to this code to get it to pull the styling form the static page onto the custom category template?

Thank you very much.

I am still trying to fully comprehend table normalization and I'm not asking anyone to explain it bc it's not a simple thing to explain.   But I'm working on a football website that tracks players stats each week (catches, yards and touchdowns) and it seems like setting it up this way would make it the easiest (maybe laziest?) to retrieve data to display wherever I want...   tablecalled players with these fields: playerid playerfirstname playerlastname week1catches week1yards week1touchdowns week2catches week2yards week2touchdowns ... and so on 17 times till... ... week17catches week17yards week17touchdowns   I know that is likely making most of you want to puke but if doing it this way makes it extremely easy to pull this info for display on the site, why is it so wrong?  Is the problem that it's much slower than what I THINK is the proper way, ie...   table called players with these fields: playerid playerfirstname playerlastname   AND   table called stats with these fields: playerid week catches yards touchdowns   Again, not asking for an explanation of normalization, just if anyone has any quick reasons why the first way is as god awful as I fear it is, I'd appreciate the knowledge.    Thanks!  

hello guys, i have a question,

in some php files i have in the start

<? ob_start(); ?>


<?php

session_start();

........
.....
......


if(isset($_POST['sub_1']))
                                          {
                                         $_SESSION['address_tmp']=$_SESSION['address_tmp']." oK ";
                                         header("location:some_other_page.php#jumpselection");
                                         }


if(isset($_POST['sub_2']))
                                          {
                                         $_SESSION['address2_tmp']=$_SESSION['address2_tmp']." hello ";
                                         header("location:thispage.php#jumpselection");
                                         }



?>

<body>
<form method="post" action="">
<input type="Submit" name="sub_1" value="action1"style="height:3.9em; width:16.5em; font-size:95%;">
</form>
</body>

<body>
<form method="post" action="">
<input type="Submit" name="sub_2" value="action2"style="height:3.9em; width:16.5em; font-size:95%;">
</form>
</body>

<? ob_end_flush(); ?>


but every page have 10-15 buttons every button in the end reloads the same page with   header("location:thispage.php#jumpselection"); or cals another page with   header("location:some_other_page.php#jumpselection");

this works but i notise some lag on the bowser afrer while..

Hi everyone,

Im using the code below to insert an item to auction, then calculate and display the time remaining until the auction ends. As soon as the confirm auction submit button is clicked, the item appears at auction straight away, however the time remaining is 0s, i have to refresh the page in order to get the end time to appear correctly.

Does anybody know why this is happening and what i can do to get the correct end time to appear straight away?

Thanks


<?php

if ($_POST['confirm_auction'])
{

foreach ($_POST['checkbox'] as $checked)

{

$add_auction_query = mysql_query("SELECT * FROM offers WHERE seller='$username' AND buyer='$buyer' AND item='$checked'");

while ($row = mysql_fetch_assoc($add_auction_query))

{

$starting_bid = $row['offer'];

$current_bid = $starting_bid;

$start_date = date("Y-m-d H:i:s");

$end_date = date("Y-m-d H:i:s", strtotime("+1 week"));

mysql_query("INSERT INTO auctions VALUES ('','$checked','$username','$starting_bid','$current_bid','$buyer','1','At Auction','$start_date','$end_date')");

mysql_query("INSERT INTO bids VALUES('','$checked','$username','$buyer','$starting_bid','$start_date')");

mysql_query("UPDATE offers SET seller_status='At Auction',buyer_status='At Auction' WHERE item='$checked'");

}

echo "Offer(s) Sent to Auction";

}
}

$x = 0;
while ($auction_row = mysql_fetch_assoc($auction_query))
{
$then = strtotime($auction_row['end_date']); 
$now = time();
$diff = $then - $now; 

$weeks = floor($diff / (60*60*24*7)); 
$diff = $diff - ($weeks * (60*60*24*7)); 

$days = floor($diff / (60*60*24)); 
$diff = $diff - ($days * (60*60*24)); 

$hours = floor($diff / (60*60)); 
$diff = $diff - ($hours * (60*60)); 

$minutes = floor($diff / 60); 
$diff = $diff - ($minutes * 60); 

$seconds = $diff;
?>
<html>
<table>
    <tr>
        <td>

<?php 
            if ($week > 0) {echo  $weeks . "w ";} 
            if ($days > 0) { echo $days . "d ";} 
            if ($hours > 0) {echo $hours . "h ";} 
            if ($minutes > 0) { echo $minutes . "m ";}   
            if ($hours < 1) {echo $seconds . "s";}
            ?>
        </td>
    </tr>
</table>
</html>
<?php
$x++;
}
?>

Hello PHP Freaks forum,

I am a beginner in web development and seem to be understanding it very quickly, but there is one thing that is putting this into some halt.

I have this code right here, what I want to do is have a "riddle site", where if you answer the riddle correctly, it redirects you to another page (in other words to the next riddle).

Object:
If correct, give access to next page.
If incorrect, stay on page and print "Incorrect".

I've tried to start on it, but the way how HTML and PHP don't mix very well, I feel like in the middle of an ocean feeling helpless.

<html>
 <head>
  <title>PHP Test</title>
 </head>
 <body>
 <p>
<font face="Courier New">ZnJ5cyBwYmFnbnZhcnEgaGFxcmVqbmdyZSBvZXJuZ3V2YXQgbmNjbmVuZ2hm</font>
</p>
CLUE: The base is rotated
 <br/></body>
 
<form action="index-5.php" method="post">
  Answer: <input type="text" name="number" /><br />
</select>
<input name="submit" type="submit">
</form>

 <?php
if(isset($_POST['submit'])){

$number = $_POST['number'];
if ($number == "scuba"){
echo "CORRECT";}
}
?>

</html>


If possible, can you give me an explanation how to do it and a sample of it as well?

Thanks,
Gldnbr

I seem to have a problem with a PHP page I made. When executed on the server, it loads with a filesize 0 and for some browsers, says it does not exist. I believe that the cause is because it is not parsing due to a syntax error. I've busted my @$$ over this code, trying to find the issue, but cannot find it. Here is the whole page's code on pastie: http://pastie.org/1064160

Hi,

So i have a form with 4 text inputs (input1,input2,input3,input4).

When the user puts in 4 correct words, they are redirected to another page.

The words can be checked either via a field in a database or a variable.
Any wrong word in any of the text fields returns the user back to the page.

In other words: When the user clicks submit, we need to make sure all of the words are correct.
If they are not correct, nothing should happen. The user will remain on the page until they enter the correct words.

If the words ARE correct, they are directed to a new page with an image.


I am not sure how to approach this, I tried using if and case, however I am not sure of the combination to make all 4 fields checked before an out is given (ie, the page redirect).

Any help is appreciated.

It's pretty simple to see what I am trying to do here. For some reason all results in the table are the same exact cityName replacing all existing records. The echoed results are correct. I've include a small dump of my table as well.

$query = "SELECT cityName FROM sys_city_dev_2";
      $resource = mysqli_query($cxn, $query) or die("MySQL error: " . mysqli_error($cxn) . "<hr>\nQuery: $query");
      
  while($result = mysqli_fetch_assoc($resource)) {

          $nox = $result['cityName'];

          $toUpper = ucfirst($nox);
  echo "$toUpper" . "<br />";

          $setString = "UPDATE sys_city_dev_2 SET cityName = '" . $toUpper ."' WHERE cityName != ''";
          mysqli_query($cxn,$setString);


      } 

100 Records of table dump (pre running my script above):

--
-- Table structure for table `sys_city_dev_2_backup`
--

CREATE TABLE IF NOT EXISTS `sys_city_dev_2_backup` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Mid` int(11) NOT NULL DEFAULT '0',
  `cityName` varchar(30) NOT NULL DEFAULT '',
  `forder` int(4) NOT NULL DEFAULT '0',
  `disdplay` int(4) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=113970 ;

--
-- Dumping data for table `sys_city_dev_2_backup`
--

INSERT INTO `sys_city_dev_2_backup` (`ID`, `Mid`, `cityName`, `forder`, `disdplay`, `cid`) VALUES
(84010, 1, 'dothan', 0, 0, 0),
(84011, 1, 'alabaster', 0, 0, 0),
(84012, 1, 'birmingham', 0, 0, 0),
(84013, 2, 'flagstaff', 0, 0, 0),
(84014, 1, 'auburn', 0, 0, 0),
(84015, 1, 'florence', 0, 0, 0),
(84016, 1, 'gadsden', 0, 0, 0),
(84017, 1, 'huntsville', 0, 0, 0),
(84018, 1, 'mobile', 0, 0, 0),
(84019, 1, 'montgomery', 0, 0, 0),
(84020, 1, 'tuscaloosa', 0, 0, 0),
(84021, 2, 'mohave valley', 0, 0, 0),
(84022, 2, 'phoenix', 0, 0, 0),
(84023, 2, 'prescott', 0, 0, 0),
(84024, 2, 'sierra vista', 0, 0, 0),
(84025, 2, 'tucson', 0, 0, 0),
(84026, 2, 'yuma', 0, 0, 0),
(84027, 3, 'bakersfield', 0, 0, 0),
(84028, 3, 'chico', 0, 0, 0),
(84029, 3, 'fresno / madera', 0, 0, 0),
(84030, 3, 'gold country', 0, 0, 0),
(84031, 3, 'humboldt county', 0, 0, 0),
(84032, 3, 'imperial', 0, 0, 0),
(84033, 3, 'inland empire', 0, 0, 0),
(84034, 3, 'los angeles', 0, 0, 0),
(84035, 3, 'alhambra', 0, 0, 0),
(84036, 3, 'merced', 0, 0, 0),
(84037, 49, 'fayetteville', 0, 0, 0),
(84038, 49, 'fort smith', 0, 0, 0),
(84039, 49, 'jonesboro', 0, 0, 0),
(84040, 49, 'little rock', 0, 0, 0),
(84041, 49, 'arkadelphia', 0, 0, 0),
(84042, 49, 'texarkana', 0, 0, 0),
(84043, 3, 'modesto', 0, 0, 0),
(84044, 3, 'alta sierra', 0, 0, 0),
(84045, 3, 'alpine', 0, 0, 0),
(84046, 3, 'pedley', 0, 0, 0),
(84047, 3, 'redding', 0, 0, 0),
(84048, 3, 'alondra park', 0, 0, 0),
(84049, 3, 'sacramento', 0, 0, 0),
(84050, 4, 'canon city', 0, 0, 0),
(84051, 3, 'san luis obispo', 0, 0, 0),
(84052, 3, 'santa barbara', 0, 0, 0),
(84053, 3, 'stockton', 0, 0, 0),
(84054, 3, 'aliso viejo', 0, 0, 0),
(84055, 3, 'visalia', 0, 0, 0),
(84056, 3, 'yuba city', 0, 0, 0),
(84057, 4, 'boulder', 0, 0, 0),
(84058, 4, 'colorado springs', 0, 0, 0),
(84059, 4, 'denver', 0, 0, 0),
(84060, 4, 'applewood', 0, 0, 0),
(84061, 4, 'pueblo', 0, 0, 0),
(84062, 4, 'air force academy', 0, 0, 0),
(84063, 5, 'avon', 0, 0, 0),
(84064, 5, 'hartford', 0, 0, 0),
(84065, 5, 'new haven', 0, 0, 0),
(84066, 5, 'ansonia', 0, 0, 0),
(84067, 5, 'fairfield', 0, 0, 0),
(84068, 7, 'daytona beach', 0, 0, 0),
(84069, 7, 'sebastian', 0, 0, 0),
(84070, 5, 'wallingford center', 0, 0, 0),
(84071, 8, 'belvedere park', 0, 0, 0),
(84072, 7, 'sarasota springs', 0, 0, 0),
(84073, 7, 'sandalfoot cove', 0, 0, 0),
(84074, 7, 'san carlos park', 0, 0, 0),
(84075, 7, 'st. augustine', 0, 0, 0),
(84076, 7, 'tallahassee', 0, 0, 0),
(84077, 7, 'safety harbor', 0, 0, 0),
(84078, 7, 'ruskin', 0, 0, 0),
(84079, 8, 'athens-clarke county', 0, 0, 0),
(84080, 8, 'atlanta', 0, 0, 0),
(84081, 8, 'augusta-richmond county', 0, 0, 0),
(84082, 8, 'brunswick', 0, 0, 0),
(84083, 8, 'columbus', 0, 0, 0),
(84084, 8, 'americus', 0, 0, 0),
(84085, 8, 'acworth', 0, 0, 0),
(84086, 8, 'valdosta', 0, 0, 0),
(84087, 10, 'boise', 0, 0, 0),
(84088, 10, 'ammon', 0, 0, 0),
(84089, 10, 'moscow', 0, 0, 0),
(84090, 10, 'blackfoot', 0, 0, 0),
(84091, 10, 'twin falls', 0, 0, 0),
(84092, 10, 'meridian', 0, 0, 0),
(84093, 10, 'jerome', 0, 0, 0),
(84094, 10, 'idaho falls', 0, 0, 0),
(84095, 11, 'addison', 0, 0, 0),
(84096, 10, 'garden city', 0, 0, 0),
(84097, 10, 'eagle', 0, 0, 0),
(84098, 10, 'chubbuck', 0, 0, 0),
(84099, 10, 'caldwell', 0, 0, 0),
(84100, 12, 'bloomington', 0, 0, 0),
(84101, 12, 'evansville', 0, 0, 0),
(84102, 12, 'fort wayne', 0, 0, 0),
(84103, 12, 'indianapolis', 0, 0, 0),
(84104, 12, 'muncie / anderson', 0, 0, 0),
(84105, 12, 'lafayette / west lafayette', 0, 0, 0),
(84106, 12, 'south bend / michiana', 0, 0, 0),
(84107, 12, 'terre haute', 0, 0, 0),
(84108, 12, 'northwest indiana', 0, 0, 0),
(84109, 13, 'ames', 0, 0, 0);

I have a script which registers people to a database, however it doing something very strange.  Whenever I place it into even a single CSS div it adds the registration to the dabase but stops loading the next page (index.php)

I find this totally bizarre as I haven't seen anything like this behave before.  With CSS affecting how PHP works.  Especially when the CSS is not inside the <php> of <form> tags.

Code: [Select]
<?php

include("connect.php");

if($_POST['submit']) {
    $username = mysql_real_escape_string(trim($_POST['username']));
    $password = trim($_POST['password']);
    $password2 = trim($_POST['password2']);
    $email = mysql_real_escape_string(trim($_POST['email']));
    $error = false;
    
    if(!isset($username) || empty($username)) {
        $error = "You need to enter a username.";
    }
    $query = mysql_query("SELECT id FROM users WHERE username = '".$username."' LIMIT 1");
    if(mysql_num_rows($query) > 0 && !$error) {
        $error = "Sorry, that username is already taken!";
    }
    
    if((!isset($password) || empty($password)) && !$error) {
        $error = "You need to enter a password.";
    }
    if((!isset($password2) || empty($password2)) && !$error) {
        $error = "You need to enter your password twice.";
    }
    if($password != $password2 && !$error) {
        $error = "The passwords you entered did not match.";
    }
    
    if((!isset($email) || empty($email)) && !$error) {
        $error = "You need to enter an email.";
    }
    if(preg_match("/[a-zA-Z0-9-.+]+@[a-zA-Z0-9-]+.[a-zA-Z]+/", $email) == 0 && !$error) {
        $error = "The email you entered is not valid.";
    }
    $query = mysql_query("SELECT id FROM users WHERE email = '".$email."' LIMIT 1");
    if(mysql_num_rows($query) > 0 && !$error) {
        $error = "Sorry, that email is already in use!";
    }
    
    if(!$error) {
        $query = mysql_query("INSERT INTO users (username, password, email) VALUES ('".$username."', '".mysql_real_escape_string(md5($password))."', '".$email."')");
        if($query) {
            $message = "Hello ".$_POST['username'].",\r\n\r\nThanks for registering! We hope you enjoy your stay.\r\n\r\nThanks,\r\nJohn Doe";
            $headers = "From: ".$website['name']." <".$website['email'].">\r\n";
            mail($_POST['email'], "Welcome", $message, $headers);
            setcookie("user", mysql_insert_id(), $time);
            setcookie("pass", mysql_real_escape_string(md5($password)), $time);
            header("Location: index.php");
        } else {
            $error = "There was a problem with the registration. Please try again.";
        }
    }
}

?><html>

<head>
<title>Register</title>
</head>

<body>
<form action="" method="post">
    <?php if($error) echo "<span style=\"color:#ff0000;\">".$error."</span><br /><br />"; ?>
    <label for="username">Username: </label> <input type="text" name="username" value="<?php if($_POST['username']) echo $_POST['username']; ?>" /><br />
    <label for="password">Password: </label> <input type="password" name="password" value="<?php if($_POST['password']) echo $_POST['password']; ?>" /><br />
    <label for="password2">Retype Password: </label> <input type="password" name="password2" value="<?php if($_POST['password2']) echo $_POST['password2']; ?>" /><br />
    <label for="email">Email: </label> <input type="text" name="email" value="<?php if($_POST['email']) echo $_POST['email']; ?>" /><br /><br />
    <input type="submit" name="submit" value="Register" />
</form>
</body>