PHP - Help With Echo And Insert In Db

Can anyone tell me why this is not INSERTing? My array data is coming out just fine.. I've tried everything I can think of and cannot get anything to insert.. Ahhhh!

<?php
  $query = "SELECT RegionID, City FROM geo_cities WHERE RegionID='135'";
  $results = mysqli_query($cxn, $query);
  $row_cnt = mysqli_num_rows($results);
  echo $row_cnt . " Total Records in Query.<br /><br />";
  if (mysqli_num_rows($results)) {
      while ($row = mysqli_fetch_array($results)) {
          $insert_city_query = "INSERT INTO all_illinois SET state_id=$row[RegionID], city_name=$row[City] WHERE id = null" or mysqli_error();
          $insert = mysqli_query($cxn, $insert_city_query);
          if (!$insert) {
              echo "INSERT is NOT working!";
              exit();
          }
          
          echo $row['City'] . "<br />";
          
          echo "<pre>";
          echo print_r($row);
          echo "</pre>";
      }
      //while ($rows = mysqli_fetch_array($results))
      
      } //if (mysqli_num_rows($results))
      
      else {
          echo "No results to get!";
      }
?>

Here is my all_illinois INSERT table structu

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is my source table geo_cities structu

CREATE TABLE IF NOT EXISTS `1` (
  `CityId` varchar(255) NOT NULL,
  `CountryID` varchar(255) NOT NULL,
  `RegionID` varchar(255) NOT NULL,
  `City` varchar(255) NOT NULL,
  `Latitude` varchar(255) NOT NULL,
  `Longitude` varchar(255) NOT NULL,
  `TimeZone` varchar(255) NOT NULL,
  `DmaId` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I'm missing something here. I have a form, and when the submit is pressed, the relevant post data inserts into table one, then I want the last insert id to insert along with other form data into a second table. The first table's still inserting fine, but I can't get that second one to do anything. It leapfrogs over the query and doesn't give an error. EDIT: I forgot to add an error: I get: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usage, why VALUES ('14', '', '123', '','1234', '', '')' at line 1

query:INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company) VALUES ('test 14', 'asdfa', 'asdf', 'adf','asdf', '', '', '', '123', '', '')


Code: [Select]
if (empty($errors)) {

require_once ('dbconnectionfile.php');

$query = "INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company)
 VALUES ('$description12', '$sn', '$description4', '$cne','$description5', '$description6', '$description7', '$description8',
'$description9', '$description10', '$description11')";

$result = @mysql_query ($query);


if ($result) {

$who_donated=mysql_insert_id();

$query2 = "INSERT INTO tbl_donation (donor_id, donor_expyear, donor_cvv, donor_cardtype, donor_authorization, amount, usage, why)
 VALUES ('$who_donated', '$donate2', '$donate3', '$donate4','$donate5', '$donate6', '$donate7')";
$result2 = @mysql_query ($query2);

if ($result2) {echo "Info was added to both tables! yay!";}

echo "table one filled. Table two was not.";
echo $who_donated;

//header ("Location: http://www.twigzy.com/add_plant.php?var1=$plant_id");

exit();
} else {
echo 'system error. No donation added';

I have a log system that allows 10 logs on each side(Left and right). I am trying to make it so that the left side has the 10 most recent logs, then the right as the next 10. Any ideas?

So I need to echo a row from my database with php, but where i need to echo is already inside an echo. This is my part of my code:


$con = mysql_connect("$host","$username","$password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("main", $con);

$result = mysql_query("SELECT * FROM Vendor");

while($row = mysql_fetch_array($result))
  {
//I need to echo right here  .................. but I get a blank page when I try this. Please Help.
  echo '<option value=$row['vendor_id']>'; echo $row['vendor_id']; echo '</option>';
  }

mysql_close($con);

Result: A Blank page.
Thanks in advance!

Hi   I try to echo out random lines of a html file and want after submit password to whole content of the same html file. I have two Problems. 1st Problem When I echo out the random lines of the html file I don't get just the text but the code of the html file as well. I don't want that. I just want the text. How to do that?

for($x = 1;$x<=40;$x++) {
		$lines = file("$filename.html");
        echo $lines[rand(0, count($lines)-1)]."<br>";
        }

I tried instead of "file("$filename.html");" "readfile("$filename.html");" But then I get the random lines plus the whole content. Is there anything else I can use instead of file so that I get the random lines of text  without the html code?P.S file_get_contents doesn't work either have tried that one.     2nd Problem:   As you could see in my first problem I have a file called $filename.html. After I submit the value of a password I want the whole content. But it is like the program did forget what $filename.html is. How can I make the program remember what $filename.html is? Or with other words how to get the whole content of the html file?   My code:

if($_POST['submitPasswordIT']){
if ($_POST['passIT']== $password ){
$my_file = file_get_contents("$filename.html");
echo $my_file;
}
else{
echo "You entered wrong password";
}
}

If the password isn't correct I get: You entered wrong password. If the password is correct I get nothing. I probably need to create a path to the file "$filename.html", but I don't know exactly how to do that.   

Hello, I'm having a bit of a problem here, all help to this issues would be much appreciated

I am trying to use text boxes to insert numbers into the database based on what is inputed.
If I have a string, like this for example:
$variable = 09385493;

And I want to insert it into the database like this:
mysql_query("INSERT INTO integers(number)
VALUES ('$variable')");

When checking the integers table in my database, looking at the number field, the $variable that was inserted is outputted as
9385493

Notice the number zero was taken out of the front of the number. If the number is double 0's (009385493), both of those zero's would disappear, too.

Thanks

Hi Freaks, You guys helped me yesterday & now I have expanded on what I was doing & now need more help.

From my limited knowledge I'm trying to add theses strings together. (I'm a printer)

Its all adding up correctly until the end.

*$row['markup'] is only multiplying the last string and not the complete echo...I have indicated the last string in blue.

<?php echo ($row['laminating']*$row['qty'])+($row['Stock1']*$row['qty'])+($row['cutting']+$row['production']+$row['additional']+$row['pluscover']+$row['selfcover'])*$row['markup'];?>

What I need to do is add up everything in red and * by my markup value (12%) 
<?php echo ($row['laminating']*$row['qty'])+($row['Stock1']*$row['qty'])+($row['cutting']+$row['production']+$row['additional']+$row['pluscover']+$row['selfcover'])*$row['markup'];?>

any help would be appreciated!
cuzzmunger

Code: [Select]
<?php
$sum_num = mysql_query("SELECT SUM(likes) as totallikes FROM facebook");
echo $sum_num;

?>


i got this result Resource id #27
how to get a number only?
 

I saw that <?=$var?> instead of <?php echo $var; ?> can be used for echo, does it work on every server?

Hi all,

I have a page which simply pulls info from a database by id:
<?php
include ('connect.php');
$id = $_GET['id'];

$query = mysql_query("SELECT * FROM JOBS WHERE id=$id");
if (!$query) {
     echo "Could not run query: " . mysql_error();
     exit;
}
$row = mysql_fetch_row($query);
{
echo "<body><h3>" . $row[1]. "</h3>";
echo "<h4>" . $row[2] . "</h4>";
echo "<h4>" . $row[3] . "</h4>";
echo "<h5>Duties & Responsibilities:</h5><ul>";
echo "<li><strong>" . $row[4] . "</strong>" . $row[5] . "</li>";
echo "<li><strong>" . $row[6] . "</strong>" . $row[7] . "</li>";
echo "<li><strong>" . $row[8] . "</strong>" . $row[9] . "</li>";
echo "<li><strong>" . $row[10] . "</strong>" . $row[11] . "</li>";
}
?>

However in some cases the rows in the database may only contain data upto row 6 for example, how would I go about coding this so that it only displays rows that exist. If row 6 exists then 7 always will too as the information is connected. I am manually added this stuff into phpmyadmin as I do not need a form as once it is complete then it will not need to be added to.

Also row 8 and 9 may contain data but 6 and 7 may not

Many Thanks

Hi
I once found out how to do this 4 years ago but I lost my backups and memory on the matter.

I want this xml to be echoed? out as it is.
When I try the standard echo and print, I get the first two lines of the code in gray when I view the page's source. I get no xml at all.

Code: [Select]
<?xml version="1.0" encoding="utf-8"?>


<!DOCTYPE blah [

<!ELEMENT cart (title, items)>

<!ELEMENT title (#PCDATA)>

<!ELEMENT items (item)+>

<!ELEMENT item (prive, deprive, onprive+)>

<!ELEMENT security (#PCDATA)>

<!ELEMENT answer (#PCDATA)>

<!ATTLIST answer correct (yeah) #IMPLIED>

]>
this is followed by the standard displaying of xml items

could anyone help me over here?
thanks in advance...

What is the correct way to write an if/else statement within an echo? I need to alter this so that I can query to see what data is found and if not correct not to echo the rest of the statement.

Code: [Select]
echo '<td class="productbox">
<h1>' . $product_title . '</h1>
</td>';

So from the above code which is echoed within  the single quotes, what is the correct way to include an if else check on a value from the database.

I know how its done, but just want to save time and write it the correct way within this.

I want to echo this div below but only if there is more than one of these fields missing.  How would I go about this?


<?php 

//only echo all of this if one or more of these fields does not exists so.......


if () {

   echo"

 <div id=\"items_todo\">
           <h3>Members Info</h3><br/>
         <ul>";

if (empty($User['address_L1'])) { echo "<li><a href=\"#\">Update Address</a></li>";} 

 elseif (empty($User['intro'])) {echo "<li><a href=\"#\">About You</a></li>";}

elseif (empty($User['profile_image'])){echo "<li><a href=\"#\">Add Profile Image</a></li>";}

elseif (empty($User['Nickname'])){echo "<li><a href=\"#\">Add A Nickname</a></li>";}
echo"</ul>

 </div>";
    } ?>