PHP - Problems With Post.php Submitting Mysql Query

I have a photo album style gallery to build
and
i'm finding it dificult to list all the table names (these are names of photo albums) and then enter the data into a seperate query for each album name (these will change often so i cant keep updating the file as normal. this will then post all the data to the xml file and show the set of photos in the individual albums in a flash file.
can anyone help me where im going wrong at all?



<?php
$dbname = 'cablard';

if (!mysql_connect('localhost', 'cablard', '')) {
    echo 'Could not connect to mysql';
    exit;
}

$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);

if (!$result) {
    echo "DB Error, could not list tables\n";
    echo 'MySQL Error: ' . mysql_error();
    exit;
}

while ($row = mysql_fetch_row($result)) {
    echo "Table: {$row[0]}\n";
}

mysql_free_result($result);



$query = "SELECT * FROM photo ORDER BY id DESC"; 
$result2 = mysql_query ($query)  or die ("Error in query: $query. ".mysql_error());

   
   while ($row = mysql_fetch_array($result2))  
   {                                       
         echo  "
<image>
<date>".$row['date']."</date>
<title>".$row['title']."</title>
<desc>".$row['description']."</desc>
<thumb>".$row['thumb']."</thumb>
<img>".$row['image']."</img>
</image>

";


   }                      
?>


Thanks
James

Hi all,

I have a query that runs just fine from the command line in MySQL, but when I try to run the exact same query using PHP to query the same database I get an error.

The query is:

SELECT Street, City, ZipCode, providers.bWebpage, OpHours.Open, OpHours.Close, lat, lng, ( 3959 * acos( cos( radians('41.757787') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('-88.321416') ) + sin( radians('41.757787') ) * sin( radians( lat ) ) ) ) AS distance FROM Providers, OpHours WHERE providers.bName = OpHours.bName AND OpHours.Close > '17:00:00' HAVING distance < '10' ORDER BY distance LIMIT 0 , 30

Like I stated above, when I run this query from the MySQL command line it returns 12 rows, which is what it should.

But when I try executing the same query via PHP I get this error message:

Invalid query: 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 ''17:00:00' HAVING distance < '10' ORDER BY distance LIMIT 0 , 30' at line 1

The PHP code is thus:

$connection=mysql_connect ($server, $username, $password);
if (!$connection)
   {
      echo 'Connection error';
     die("Not connected : " . mysql_error());
   }

$db_selected = mysql_select_db($database, $connection);
if (!$db_selected)
   {
      echo 'Database selection error' . '\n';
      die ("Can\'t use db : " . mysql_error());
   }

 $query = sprintf("SELECT Street, City, ZipCode, providers.bWebpage, OpHours.Open, OpHours.Close,
 lat, lng, ( 3959 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) )
AS distance FROM Providers, OpHours WHERE providers.bName = OpHours.bName %s HAVING distance < '%s' ORDER BY distance LIMIT 0 , 30",
  mysql_real_escape_string($center_lat),
  mysql_real_escape_string($center_lng),
  mysql_real_escape_string($center_lat),
  mysql_real_escape_string($hours),
  mysql_real_escape_string($radius));

$result = mysql_query($query);

if (!$result)
   {
      die("Invalid query: " . mysql_error());
   }

I've also checked the MySQL logs and they don't report any errors.  I'm running this on a Mac using Snow Leopard.  MySQL version is 5.1.37 and the PHP version is 5.2.11.  If it makes any difference both of these are from MAMP version 1.8.4.

Hello, I have a problem with my login form, when i press the submit button, it returns a valitation error that I made.

The error message is triggered when the submit button isn't pressed, but the form still tries to submit.

session_start();

include "sources/php/class.php";

$e = $_POST['loginname'];
$p = $_POST['loginpass'];
$s = $_POST['submit'];

if(!isset($s)) {
    header('location: '.$_SESSION['psite'].'.php?p=error&ploca=login&pid=0');
    exit();
}

Heres a piece of my code, first i define the variables, then check if the button was pressed, but something is wrong there? - But what?

Hope you can help me.
Thanks in advance.

Hello, I'm new to this forum and I need some help. I'm creating a simple database that it submits data from a user input. Unfortunatly, it's not sending any data to mysql also the form is not validating each field.

Code: [Select]
<?php

if (isset($_POST['submitted'])){

$fields = array(
'email',
'state',
'district',
'gender',
'age',
'profession',
'survey',
);

foreach($fields as $fieldName) {
if(isset($_POST[$fieldName]) and trim($_POST[$fieldName]) !==''){
$fieldName = trim($_POST[$fieldName]);
}else {

$errors[] = "Please enter your". $fieldName .""; //code to validate fields
}
}
if(isset($errors)){

require_once('Connections/encourage.php');

$query = "INSERT INTO participants (email, state, district, gender, age, profession, survey) 
VALUES ('$email', '$state', '$district', '$gender', '$age', '$profession','$survey')"; //databasse connection
   
$result = mysql_query ($query); 

if ($result){

echo '<h1 id="mainhead">Thanks for submitting</hl>
<p>You are now registered</p>';
exit();

}else{

echo '<h1 id="mainhead">System Error</hl>
<p>Your registration could not be completed due to a system error We apologize for any incovience</p>';//gives system error
echo 'p' . mysql_error(). '<br /><br />Query: ' . $query . '</p>';
exit();

}
mysql_close();

} else { 

echo '<h1 id="mainhead">Error!</h1>
<p class="error">The following error(s) occurred:<br />';
foreach($errors as $msg) {
echo " - $msg<br/>\n";
}
echo '</p><p>Please try again.</p><p><br/></p>';
}

}
?>
  <form id="form1" name="form1" method="post" action"registration.php">
  <fieldset class="first">
  <label class="lableone" for="email">Email:* </label>
  <input name="email" value="<?php if(isset($_POST['email'])) echo $_POST['name'];?>"/>
 
  <label for="state"/>State:* </label>
  <input name="state" value="<?php if(isset($_POST['state'])) echo $_POST['state'];?>"/>
 
  <label for="schooldistrict"/>School District:* </label>
  <input name="schooldistrict" value="<?php if(isset($_POST['district'])) echo $_POST['district'];?>" />
 
  <label for="gender">Gender:* </label>
 <select name="gender">
   <option>Choose Your Gender</option>
   <option value="male" <?php echo ($form['gender'] == 'male' ? ' selected' : ''); ?>>Male</option>
   <option value="female"<?php echo ($form['gender'] == 'female' ? ' selected' : ''); ?>>Female</option>
 </select>
 
    <label for="age"/>Your Age:* </label>
  <input name="age" type="text" class="age" maxlength="2" value="<?php if(isset($_POST['age'])) echo $_POST['age'];?>"  />
 
  <label for="profession"/>Profession:* </label>
  <input name="profession" value="<?php if(isset($_POST['age'])) echo $_POST['age'];?>" />
 
  <label for="surveys"/>Willingness to participate in future surveys: </label>
  <input name="surveys" type="checkbox" id="surveys" value="yes" <?php echo ($form['survey'] == 'yes' ? 'checked' : '');?>/>
 
  </fieldset>
<fieldset>
  <input class="btn" name="submit" type="submit" value="Submit" />
<input class="btn" name="reset" type="reset" value="Clear Form" />
<input type="hidden" name="submitted" value="TRUE" />
</fieldset>

  </form>


Can someone help me out? Thanks in advanced! 

hello. i have an issue where the data stored with an image is not saving to a mysql table.
the image data is ok, just not the selections from the dropdown lists.

here is the code

<?php
include ('connect.php');

// Insert any new image into database
if(isset($_POST['xsubmit']) && $_FILES['imagefile']['name'] != "") {
  $fileName = $_FILES['imagefile']['name'];
  $fileSize = $_FILES['imagefile']['size'];
  $fileType = $_FILES['imagefile']['type'];
  $content  = addslashes (file_get_contents($_FILES['imagefile']['tmp_name']));
  $jeweltype = $_POST['jeweltype'];
  $jewelsize = $_POST['jewelsize_in'];
  $jewelcolour = $_POST['jewelcolour_in'];
  $jewelmaterial = $_POST['jewelmaterial_in'];
  $jewelgender = $_POST['jewelgender_in'];

  if(!get_magic_quotes_gpc()) {
    $fileName = addslashes($fileName);
  }

  // Checking file size
  if ($fileSize < 150000) {
    mysql_query ("INSERT into jewel_images (name,size,type,content,jeweltype,jewelsize,jewelcolour,jewelmaterial,jewelgender) "
   . "values ('$fileName','$fileSize','$fileType','$content','$jeweltype','$jewelsize','$jewelcolour','$jewelmaterial','$jewelgender')");
  } else {
    $err = "The Image file to too large!";
  }
}

// Find out about latest image

$gotten = mysql_query("select * from jewel_images order by row_id desc");
$row    = mysql_fetch_assoc($gotten);
$bytes  = $row['content'];

// If this is the image request, send out the image

 if ($_REQUEST['pic'] == 1) {
   header("Content-type: $row[type];");
 print $bytes; 
 }
?>
<html>
<head>
<title>Upload an image to a database</title>
</head>
<body>
  <font color="#FF3333"><?php echo $err ?></font>
  <table>
    <form name="Upload" enctype="multipart/form-data" method="post">
      <tr>
        <td>Upload <input type="file" name="imagefile"><br />
            Jewelery Type:
               <select>
               <?php
               $sql="SELECT jeweltype FROM jeweltypes";
               $result =mysql_query($sql);
               while ($data=mysql_fetch_assoc($result)){
               ?>
               <option value ="jeweltype" ><?php echo $data['jeweltype'] ?></option>
               <?php } ?>
               </select>
               <br />
            Jewelery Size:
               <select>
               <?php
               $sql="SELECT jewelsize FROM jewelsizes";
               $result =mysql_query($sql);
               while ($data=mysql_fetch_assoc($result)){
               ?>
               <option value ="jewelsize" ><?php echo $data['jewelsize'] ?></option>
               <?php } ?>
               </select>
               <br />
            Jewelery Colour:
               <select>
               <?php
               $sql="SELECT jewelcolour FROM jewelcolours";
               $result =mysql_query($sql);
               while ($data=mysql_fetch_assoc($result)){
               ?>
               <option value ="jewelcolour_in" ><?php echo $data['jewelcolour'] ?></option>
               <?php } ?>
               </select>
               <br />
            Jewelery Material:
               <select>
               <?php
               $sql="SELECT jewelmaterial FROM jewelmaterials";
               $result =mysql_query($sql);
               while ($data=mysql_fetch_assoc($result)){
               ?>
               <option value ="jewelmaterial_in" ><?php echo $data['jewelmaterial'] ?></option>
               <?php } ?>
               </select>
               <br />
            Jewelery Gender:
               <select>
               <?php
               $sql="SELECT jewelgender FROM jewelgenders";
               $result =mysql_query($sql);
               while ($data=mysql_fetch_assoc($result)){
               ?>
               <option value ="jewelgender_in" ><?php echo $data['jewelgender'] ?></option>
               <?php } ?>
               </select>
               <br />
        <input type="submit" name="xsubmit" value="Upload">
        </td>
      </tr>
      <tr>
       <td>Latest Image</td>
      </tr>
      <tr>
        <td><img src="?pic=1"></td>
      </tr>
    </form>
 </table>
</body>
</html>


==============================================
here is the query
===============================================

<html> 
<head><title>Your Page Title</title></head> 
<body> 
<?php 
$database="josh_jewel"; 
mysql_connect ("localhost", "xxxxxxxxx", "yyyyyyyyyyyy"); 
@mysql_select_db($database) or die( "Unable to select database"); 
$result = mysql_query( "SELECT jewelcolour FROM jewel_images" ) 
or die("SELECT Error: ".mysql_error()); 
$num_rows = mysql_num_rows($result); 
print "There are $num_rows records.<P>"; 
print "<table width=400 border=1>\n"; 
while ($get_info = mysql_fetch_row($result)){ 
print "<tr>\n"; 
foreach ($get_info as $field) 
print "\t<td><font face=arial size=1/>$field</font></td>\n"; 
print "</tr>\n"; 
} 
print "</table>\n"; 
?> 
</body> 
</html>