PHP - Questing About Php Mysql Query And Clearing A Form

Hi Members,   I am search for the reason for the problem why my mysql query cannot fetch data and store in file based on id in $variable form. For example, $sql="SELECT * FROM mytable WHERE mine_id='1234'"; works for me. But when i use $sql="SELECT * FROM mytable WHERE mine_id='$id'";, files are created as empty. I chanaged the quotes and could not store the data in file. So anyone please help me. For more clear, i attach the part of my code

for ($i=0;$i<=10;$i++)
    {

$id=$seqs[$i];
$dbo = new PDO($dbc, $user, $pass);
echo $sql = "SELECT * FROM mine_id WHERE locus_id='$id'";

$qry = $dbo->prepare($sql);
$qry->execute();
$data = fopen('file.csv', 'w');

   while ($row = $qry->fetch(PDO::FETCH_ASSOC))
              {
          fputcsv($data, $row);
             }
    }

Edited by phpnewbie007, 20 November 2014 - 02:17 AM.

I'm having a few issues with a serach function in Internet Explorer, it works fine in firefox which is very annoying.

What basically is happening, is the a form is sumbitting and posting info across, but on itself and then this is transfered into a php variable which is used on the query. Default values have been assigned if the isset of the form is not true.

So I believe the issue is occuring on the " if(isset($_POST['submit'])) " but as stated it works perfectly fine in firefox. Any suggestions? 


Code: [Select]
<?php



print "
<form target='_self' method='POST'>
<table class=''> 
<tr> 
<td>
<input name='vehicle' type='text' id='search_name' size='16'>
<input type='image' src='images/search.gif' alt='Search' name='submit' id='search' value='Search'/>
</td>
</tr>
<tr>
<td>
<select name='filter' id='filter'>
<option value='make' selected='selected'>Filter By</option>
<option value='make'>Vehicle Manufacture</option>
<option value='model'>Vehicle Model</option>
<option value='our_price'>Price</option>
<option value='delivery_time'>Delivery Time</option>
</select>
</td>
</tr>
<tr>
<td>
<input type='radio' name='direction' value='ASC' checked/>Ascending 
<input type='radio' name='direction' value='DESC' />Descending

</td>
</tr>
     </form>
      ";
include "connections/dbconnect.php";

if(isset($_POST['submit'])) 
{
$vehicle = $_POST['vehicle'];
$filter = $_POST['filter']; 
$direction = $_POST['direction']; 
//$rowsPerPage = $_POST['limit']; 
}
else
{
$filter = "make"; 
$direction = "ASC"; 
}  
//$manfactures = "Ford";

if(isset($_GET['limit'])) 
{
$rowsPerPage = $_GET['limit'];;
}
else
{
// how many rows to show per page
$rowsPerPage = 10;
}


// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];

}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;


$car_query = " SELECT * FROM cars WHERE model LIKE '%$vehicle%' OR make LIKE '%$vehicle%' OR model_details LIKE '%$vehicle%' OR search LIKE '%$vehicle%' ORDER BY $filter $direction LIMIT $offset, $rowsPerPage";
$car_result = mysql_query($car_query) or die ("Error in query: $car_query. ".mysql_error()); 
setlocale(LC_MONETARY, 'en_GB');
$fmt = '%i';

// how many rows we have in database
$query   = "SELECT COUNT(model) AS numrows FROM cars";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);

// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav  = '';

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
  $nav .= " $page "; // no need to create a link to current page
   }
   else
   {
  $nav .= " <a href=\"$self?page=$page&limit=$rowsPerPage\">$page</a> ";
   }
}

if ($pageNum > 1)
{
   $page  = $pageNum - 1;
   $prev  = " <a href=\"$self?page=$page&limit=$rowsPerPage\">[Prev]</a> ";

   $first = " <a href=\"$self?page=1&limit=$rowsPerPage\">[First Page]</a> ";
}
else
{
   $prev  = '&nbsp;'; // we're on page one, don't print previous link
   $first = '&nbsp;'; // nor the first page link
}

if ($pageNum < $maxPage)
{
   $page = $pageNum + 1;
   $next = " <a href=\"$self?page=$page&limit=$rowsPerPage\">[Next]</a> ";

   $last = " <a href=\"$self?page=$maxPage&limit=$rowsPerPage\">[Last Page]</a> ";
}
else
{
   $next = '&nbsp;'; // we're on the last page, don't print next link
   $last = '&nbsp;'; // nor the last page link
}



if (mysql_num_rows($car_result) > 0) 
{


...... bringing back all the information from the database

Hey guys,

New to the forum and a newer user of PHP / MySQL.  I am having trouble with some code I've written up.  I don't seem to get any errors when running it, but it's not updating my database the way that it should.  hopefully a simple fix.  I am thinking that it must be on the MySQL side of things. 

Couple of things to start. 

My html form is comprised completely of drop down list inputs.  I'm the only user so I thought this would be the easiest approach.

Because of that I've made my PHP as follows:

Code: [Select]
<?php

$season = $_POST['season'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];
$time = $_POST['time'];
$event = $_POST['event'];
$game = $_POST['game'];
$buyin = $_POST['buyin'];

$connect = mysql_connect('localhost','root','') or die('can not connect');

if ($connect)
{
    echo "connected to database";
}

$db = mysql_select_db('dpl') or die('can not find database');

if ($db)
{
    echo "DPL Selected";
}

$query = sprintf("INSERT INTO events (season , month , day , year , time , event , game , buyin)
    VALUES ('%s' , '%s' , '%s' , '%s' , '%s' , '%s' , '%s' , '%s')",
       $season ,
       $month ,
       $day ,
       $year ,
       $time ,
       $event ,
       $game ,
       $buyin
       );

if ($query)
{
    echo "Your event has been added";
}

?>
My connection is working, my database is selected and I'm even now getting confirmation that my query is working, but when i go to check my database there are no entries in it?

any thoughts?

I've tried the drop down variables as both VARCHAR and TEXT inputs in MySQL, but I can't seem to get it to work.

Any help is greatly appreciated.

I have a Credit Card Payment Form.

A few things...

1.) For non-financial fields, I'm using a "sticky form".

Code: [Select]
<label for="firstName">First Name:</label>
<input id="firstName" name="firstName" class="text" type="text"
maxlength="20" value="<?php echo $firstName; ?>" />

After the user successfully submits the form, how can I erase these values out?

Right now, if you hit the "Back" button, the form data is still there, which isn't very secure?!


2.)  I read somewhere, that HTML secretly cache form values, and there is something you add to your HTML to prevent these - especially on the Credit Card # field.

Any idea what I'm talking about?

BTW, I'm not using Cookies, Sessions, or a DB to store any form data.

Thanks,



Debbie

Hi, I'm quite a newbie to PHP and am doing a website. Have got a login working and the registration half way there, but am now in process of putting validation in Registration form. Have got the errors appearing if domething isn't filled in or if the username is taken however, it clears all the fields and i would like it to keep the values in them if possible. Is there an easy way round this?

I can give my code if needed

Cozzy