PHP - Mysql Query Cannot Recognize The Id In Variable Form

Here's what i got, a part of poll script, actually this is for a user with some more priviliges... The problem I am facing is actually that my php code doesn't even recognize the text in HTML Form - the text boxes(at least thats what I think so). I made 2 errors - one if client didnt type the title of poll and one if there are lower than 2 answers. And the problem is Im getting those 2 problems all the time no mather what I type in textboxes
Code: [Select]

<?php 
}
function GetNewPollDetails(){
?>
  <h1>Nova anketa</h1>
<form name="frmAddPoll" action="managepoll.php?method=AddFinal" method="post">
<br />
 
Pitanje Ankete:<input type="text" name="$question" />
<br />
Odogovor 1:<input type="text" name="answer1" />
<br />
Odogovor 2:<input type="text" name="answer2" />
<br />
Odogovor 3:<input type="text" name="answer3" />
<br />
Odogovor 4:<input type="text" name="answer4" />
<br />
Odogovor 5:<input type="text" name="answer5" />
<br />
<input type="submit" value="Napravi" name="napravi" />
</form>
<?php
}

function AddPoll(){

global $question;

global $answer1;

global $answer2;

global $answer3;

global $answer4;

global $answer5;

$numAnswers = 0;

$err = "";



if($answer1 != "")

{ $numAnswers++; }

if($answer2 != "")

{ $numAnswers++; }

if($answer3 != "")

{ $numAnswers++; }

if($answer4 != "")

{ $numAnswers++; }

if($answer5 != "")

{ $numAnswers++; }



if($question == "")

$err .= "<li>You didn't enter a title</li>";


if($numAnswers < 2)

$err .= "<li>You must enter at least two answer choices</li>";


if($err != "")

{

?>

<h1>Incomplete Fields</h1>

You didn't complete all of the details for this poll.

Take a look at the errors below and click the link

below to go back and correct them:

<ul>

<?php echo $err; ?>

</ul>

<a href="javascript:history.go(-1)">Go Back</a>

<?php

return;

}

include("dbvars.php");

@$svrConn = mysql_connect($host, $user, $pw) or die("Couldn't connect to the database server");

@$dbConn = mysql_select_db("websitenforum", $svrConn) or die("Couldn't connect to the database");


$strQuery = "INSERT INTO pollQuestions VALUES(";

$strQuery .= "0, '$question', '$answer1', '$answer2', '$answer3', '$answer4', '$answer5')";

if(mysql_query($strQuery)) {

echo "You made it, yes!";
}
}
?>

Code: [Select]
$genre = $_POST['listMovies'];
$result = mysql_query("SELECT * FROM  movieTable SORT BY title");
$column = 1; define("COLUMNS", 2);
$movieCounter = 0;
echo "<h1>by " .$genre ."</h1><table>";
while ($info = mysql_fetch_array($result)) {
$genre1 = $info['genre1'];
$genre2 = $info['genre2'];
$genre3 = $info['genre3'];
$title =  $info['title'];
        $link = $info['imdbLink'];

       
if ($genre == $genre1 || $genre == $genre2 || $genre == $genre3) {
$movieCounter++;

                if ($column == 1) {echo "<tr>";}
echo "<td><a href='" .$link ."'>".$title ."</a></td>";
$column++;
if ($column > COLUMNS) {
echo "</tr>";
$column = 1;
}             
}
}

echo "<table><tr><td>" .$movieCounter ." movies found.</td></tr></table>";
if ($column > 1 && $column <= COLUMNS) {
while ($column++ <= COLUMNS) echo "<td></td>";
echo "</tr>";
}
echo "</table>";
$genre = "";
now that you have the code, i have 2 questions about this.  first one is this.  whenever i first load this code everything is empty as it should be.  then i select from a form a movie genre and everything work lovely.  the problem is that the movies that are loaded are still there when i come back to the page.  i need a way to clearing this out everytime the code is run, while still displaying the movies.

also .. this is just a php noob question here.  why is that when i run a query like this


Code: [Select]
$result = mysql_query("SELECT * FROM  movieTable SORT BY title");
i cannot use mysql_fetch_array or mysql_fetch_row? 

but it works when i do it like this

Code: [Select]
$result = mysql_query("SELECT * FROM  movieTable");
like i said that's just a noob question that i cannot for the life of me figure out. 

thanks for the help, this forum has been the biggest help to me learning php.

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

I have a form passing user's search term, ie name.
$pname = mysql_real_escape_string($pname;

Not sure on proper syntax to include this in my select statement.
I also want it to return for partial string matched, like 'mik' for 'mike':

$result = mysql_query(
  "SELECT * FROM guest WHERE name like '$pname'"
);

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.

Here is my code:
// Start MySQL Query for Records
$query = "SELECT codes_update_no_join_1b" .
"SET orig_code_1 = new_code_1,
       orig_code_2 = new_code_2" .
"WHERE concat(orig_code_1, orig_code_2) = concat(old_code_1, old_code_2)";
$results = mysql_query($query) or die(mysql_error());
// End MySQL Query for Records


This query runs perfectly fine when run direct as SQL in phpMyAdmin, but throws this error when running in my script??? Why is this???

Code: [Select]
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 '= new_code_1, orig_code_2 = new_code_2WHERE concat(orig_code_1, orig_c' at line 1

If you also have any feedback on my code, please do tell me. I wish to improve my coding base.

Basically when you fill out the register form, it will check for data, then execute the insert query. But for some reason, the query will NOT insert into the database. In the following code below, I left out the field ID. Doesn't work with it anyways, and I'm not sure it makes a difference.

Code:

  Code: [Select]
mysql_query("INSERT INTO servers (username, password, name, type, description, ip, votes, beta) VALUES ($username, $password, $name, $server_type, $description, $ip, 0, 1)");
Full code:

Code: [Select]
<?php
include_once("includes/config.php");
 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><? $title; ?></title>
<meta http-equiv="Content-Language" content="English" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="style.css" media="screen" />
</head>
<body>
 
<div id="wrap">
 
<div id="header">
<h1><? $title; ?></h1>
<h2><? $description; ?></h2>
</div>
 
<? include_once("includes/navigation.php"); ?>
 
<div id="content">
<div id="right">
<h2>Create</h2>
<div id="artlicles">
<?php
 
if(!$_SESSION['user'])
{
 
        $username = mysql_real_escape_string($_POST['username']);
        $password = mysql_real_escape_string($_POST['password']);
        $name = mysql_real_escape_string($_POST['name']);
        $server_type = mysql_real_escape_string($_POST['type']);
        $description = mysql_real_escape_string($_POST['description']);
 
        if(!$username || !$password || !$server_type || !$description || !$name)
        {

        echo "Note: Descriptions allow HTML. Any abuse of this will result in an IP and account ban. No warnings!<br/>All forms are required to be filled out.<br><form action='create.php' method='POST'><table><tr><td>Username</td><td><input type='text' name='username'></td></tr><tr><td>Password</td><td><input type='password' name='password'></td></tr>";
        echo "<tr><td>Sever Name</td><td><input type='text' name='name' maxlength='35'></td></tr><tr><td>Type of Server</td><td><select name='type'>
       
        <option value='Any'>Any</option>
        <option value='PvP'>PvP</option>
        <option value='Creative'>Creative</option>
        <option value='Survival'>Survival</option>
        <option value='Roleplay'>RolePlay</option>
       
        </select></td></tr>
       
        <tr><td>Description</td><td><textarea maxlength='1500' rows='18' cols='40' name='description'></textarea></td></tr>";
        echo "<tr><td>Submit</td><td><input type='submit'></td></tr></table></form>";
        }
        elseif(strlen($password) < 8)
        {
        echo "Password needs to be higher than 8 characters!";
        }
        elseif(strlen($username) > 13)
        {
                echo "Username can't be greater than 13 characters!";
        }
        else
        {
                $check1 = mysql_query("SELECT username,name FROM servers WHERE username = '$username' OR name = '$name' LIMIT 1");
               
                if(mysql_num_rows($check1) < 0)
                {
                        echo "Sorry, there is already an account with this username and/or server name!";
                }
                else
                {
                        $ip = $_SERVER['REMOTE_ADDR'];

                        mysql_query("INSERT INTO servers (username, password, name, type, description, ip, votes, beta) VALUES ($username, $password, $name, $server_type, $description, $ip, 0, 1)");
                        echo "Server has been succesfully created!";
                }
        }
       
}
else
{
        echo "You are currently logged in!";
}
 
?>
</div>
</div>
 
<div style="clear: both;"> </div>
</div>
 
<div id="footer">
<a href="http://www.templatesold.com/" target="_blank">Website Templates</a> by <a href="http://www.free-css-templates.com/" target="_blank">Free CSS Templates</a> - Site Copyright MCTop
</div>
</div>
 
</body>
</html>

I am trying to allow the user to update a variable he chooses by radio buttons, which they will then input text into a box, and submit, to change some attributes. I really need some help here.  It works just fine until I add the second layer of variables on top of it, and I can't find the answer to this question anywhere.

<?PHP require('connect.php'); ?>

<form action ='' method='post'> <select name="id">

<?php
$extract = mysql_query("SELECT * FROM cars");
   
   while($row=mysql_fetch_assoc($extract)){
   $id = $row['id'];
   $make= $row['make'];
   $model= $row['model'];
   $year= $row['year'];
   $color= $row['color'];

echo "<option value=$id>$color $year $make $model</option>
";}?>

</select>

Which attribute would you like to change?<br />
<input type="radio" name="getchanged" value="make"/>Make<br />
<input type="radio" name="getchanged" value="model"/>Model<br />
<input type="radio" name="getchanged" value="year" />Year<br />
<input type="radio" name="getchanged" value="color"   />Color<br /><br />

   <br /><input type='text' value='' name='tochange'>
   <input type='submit' value='Change' name='submit'>

</form>

//This is where I need help...

<?PHP
if(isset($_POST['submit'])&&($_POST['tochange'])){
mysql_query("
   UPDATE cars
   SET '$_POST[getchanged]'='$_POST[tochange]'
   where id = '$_POST[id]'
         ");}?>

I'm restarting this under a new subject b/c I learned some things after I initially posted and the subject heading is no longer accurate.

What would cause this behavior - when I populate session vars from a MYSQL query, they stick, if I populate them from an MSSQL query, they drop.

It doesn't matter if I get to the next page using a header redirect or a form submit.  I have two session vars I'm loading from a MYSQL query and they remain, the two loaded from MSSQL disappear. 

I have confirmed that all four session vars are loading ok initially and I can echo them out to the page, but when the application moves to next page via redirect or form submit, the two vars loaded from MSSQL are empty. 

Any ideas?

Say I have this query:

site.com?var=1

..I have a form with 'var2' field which submits via get.

Is there a way to produce:

site.com?var=1&var2=formdata

I was hoping there would be a quick way to affix, but can't find any info. Also, the query could sometimes be:

site.com?var2=formdata&var=1

I would have to produce:

site.com?var2=updatedformdata&var=1

Is my only option to further parse the query?

I have this variable that I need to get into my database and I just can't think through it. Here is the code.


$sql = "INSERT INTO names (id, name, color, uploaddate) VALUE (NULL,'$master[2]['dbid']','$color','$time')";


I know I need to escape those quotes around dbid somehow, but I can't seam to get it figured out.  If I have to I will set it = to a different variable, but I don't want to do it that way if I don't have to

 

$id = '9';

$MyQuery = "SELECT * FROM bookings WHERE id = '$id'";
$retrieve = mysql_query($MyQuery) or die(mysql_error());
if(mysql_num_rows($retrieve) != 0):
$row = mysql_fetch_assoc($retrieve);
else:
echo 'No Information';
endif;

echo 'Full Name: ' . ($row['fullname']) . '<br><br>';

The above code is working for me however when I change it to what I do...

$id = ($row['id']);

It tells me I have an undefined row variable... What will fix this? Thanks in advance...

okay i have table named ZAMJENE with 2 rows only row that i need to setup is named id_zamjena and have values 15 and 16

when i do echo on page it work great but when i press button i get only 16 for both entries

full cde is too long so i paste only important parts

$query_zamjene = mysql_query ("SELECT * FROM zamjene  WHERE id_user_1='$moj_id' AND zamjenjeno='0' ORDER BY id_event_1");

echo "<form method='post' action='event_zamjenjen.php'>";


while ($rows = mysql_fetch_array($query_zamjene))
{
$id_zamjena = $rows['id_zamjena'];
$id_event_1 = $rows['id_event_1'];
$id_event_2 = $rows['id_event_2'];
$id_user_2 = $rows['id_user_2'];

echo "$id_zamjena";   // THIS ROW WORKS CORRECTLY
echo "<input name='id_zamjena' type='hidden' value=$id_zamjena>";  // output of this is always 16

echo "<input name='response' type='submit' value='Prihvati zamjenu' />
<input name='response' type='submit' value='Odbaci zamjenu' />
<br>";

}
echo"</form>";

I have a template page that opens with a GO click from a drop-down in a different page. The variable is being passed through to the URL and in the GET statement. However, my PHP code is producing the following error: Quote

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /data/23/2/100/53/2263053/user/2487001/htdocs/myalaskacenter/events/venues/test_venues-results.php on line 52

.
Here is my code: Code: [Select]
<?php
//Assigns the venueCode tothe variable with a more convenient name
$venueURL = $_GET['VenueCode'];
@$DB = mysqli_connect('server','username','password','database');
if (mysqli_connect_errno()){
echo '</blockquote><br/><br /> &nbsp; &nbsp; &nbsp; Sorry, this webpage is temporarily unavailable.<br /> &nbsp; &nbsp; &nbsp; <a href="http://alaskapac.centertix.net/">Click here to search for events.</a>';
} else {
 ?>
<?php
   $Query = "SELECT Events.EventTitle, DATE_FORMAT(Performance.startDateTime, '%W, %M %e, %Y') AS startDate, DATE_FORMAT(Performance.startDateTime, '%h:%i %p') AS startTime, Events.EventID, Events.thumb, Events.ShoWareEventLink, Events.tagline, Performance.category_id, Promoters.Presenter, Promoters.website, Events.startDATE, Events.endDATE, Events.EventOnSaleDate, venues.VenueName FROM ((Events LEFT JOIN Performance ON Events.EventID = Performance.EventID) LEFT JOIN Promoters ON Events.PromoterCode = Promoters.PromoterCode) LEFT JOIN venues ON Performance.VenueCode = venues.VenueCode WHERE venues.VenueCode=".$venueURL." AND Events.group_id=1 AND Performance.category_id!=2 AND Performance.category_id!=5 AND Performance.category_id!=7 AND Performance.category_id!=8 AND Events.EventOnSaleDate IS NOT NULL AND (Performance.PerfType='Public Event' OR Events.EventID='79') AND Performance.endDateTime >= now()-INTERVAL 1 DAY AND Events.PublishDate <= now() AND Events.startDATE IS NOT NULL ORDER BY Performance.startDateTime";
   $Result = mysqli_query($DB,$Query);
   $NumResults = mysqli_num_rows($Result);
?>
<?php
 if($NumResults=0){
    echo "<p class='submenu'>$NumResults Performances</p>";
 }

while ($Row = mysqli_fetch_assoc($Result)){
$eventtitle = $Row['EventTitle'];
$eventDate = $Row['startDate'];
echo '<p><a href="' . $Row['ShoWareEventLink'] . '"><img src="https://alaskapac.centertix.net/UPLImage/' . $Row['thumb'] . '" alt="' . $Row['EventTitle'] . '" title="' . $Row['EventTitle'] . '" align="left" border="0"><span class="Heading3_blue">' . $Row['EventTitle'] . '</span>';
if($Row['FreeEvents']==TRUE){
echo '<img src="/images/free.gif" alt="Free Event" title="Free Event" width="80" height="80" align="right" border="0"></a><br />';
} elseif ($Row['EventOnSaleDate'] <= date("Y-m-d g:i a")){ /** IF ONSALEDATE<=NOW**/
echo '<img src="/images/logos/ctx/BUY_Tickets_gold.gif" alt="Buy Tickets" title="Buy Tickets" width="85" height="32" align="right" border="0"></a><br />';
} else {/** IF ONSALEDATE!<NOW**/
echo '<img src="/images/logos/ctx/AvailableSoon.png" alt="Available Soon" title="Available Soon" align="right" border="0"></a><br /><i>Tickets available ' . date("l, F j, Y", strtotime($Row['EventOnSaleDate'])) . ' at ' . date("g:i a", strtotime($Row['EventOnSaleDate'])) . '.</i>'; /** +ONSALEDATE **/
}
echo '<br />Presented by <a href="' . $Row['website'] .'" target="_blank">' . $Row['Presenter']  . '</a>';
echo '<br />'.$Row['startDate']. ' at ' .  $Row['startTime'].' - '.$Row['VenueName'];
if ($Row['FreeEvents']==TRUE){
echo '<br /><br />'.$Row['BriefDescription'];
}
    echo '<br /><br /></p><hr>';
}
?>
<?php
mysqli_free_result($Result);
mysqli_close($DB);
}
?>
Here is my sample Results page: http://www.myalaskacenter.com/events/venues/test_venues-results.php?VenueCode=ACH