PHP - Posting Tables Into Xls

can anyone help me as to whay I get this error: Problem with the query: INSERT INTO options (item_id, option ) VALUES('1', 'hi' )
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 'option ) VALUES('1', 'hi' )' at line 1

with this code: Code: [Select]
foreach($_POST["user"] AS $key => $val) {
$user = $val;
$id1 = $_POST['id1'][$key];


$sql = "INSERT INTO options (item_id, option )





VALUES('$id1', '$user' )";
$rs = mysql_query($sql) or die ("Problem with the query: $sql <br />" . mysql_error());


} Code: [Select]
<input type="checkbox" name="yes" id="checkme" /><div id = "extra"> <div id="user"> Enter User Names:<br> <input type="text" name="user[]"/><br></div>
<div id="add_user" style="display: none;"><input type="text" name="user[]"/>

I have this code with clears the input box onclick...
Code: [Select]
<input type="text" name="username" value="Username" onclick="value=''"/>

however is there any way to use php to get the value of username, before its posted?

that way i can make it so it only clears if the value of username is "username"

You guys helped me create a function to gather information for my database. Now I need some help with posting that information.

Function code and Form:
<?php include("opendatabase.php"); ?>

<?php
function createMatchup($week, $game)
{
$query1 = "SELECT team_name 
FROM schedule, teams 
WHERE schedule.week_id = $week 
AND schedule.game_id = $game 
AND schedule.A_team = teams.team_id";

$query2 = "SELECT team_name 
FROM schedule, teams 
WHERE schedule.week_id = $week 
AND schedule.game_id = $game 
AND schedule.H_team = teams.team_id";

$result1 = mysql_fetch_assoc(mysql_query($query1));
$result2 = mysql_fetch_assoc(mysql_query($query2));

$output = "
<input type=\"text\" size = \"3\" name=\"w$weekg$gameA\"> {$result1['team_name']} vs. {$result2['team_name']} 
<input type=\"text\" size = \"3\" name=\"w$weekg$gameH\">";

return $output;

}

$game1 = createMatchup(1, 1);
$game2 = createMatchup(1, 2);
$game3 = createMatchup(1, 3);
$game4 = createMatchup(1, 4);
$game5 = createMatchup(1, 5);
$game6 = createMatchup(1, 6);
$game7 = createMatchup(1, 7);
$game8 = createMatchup(1, 8);
$game9 = createMatchup(1, 9);
$game10 = createMatchup(1, 10);
$game11 = createMatchup(1, 11);
$game12 = createMatchup(1, 12);
$game13 = createMatchup(1, 13);
$game14 = createMatchup(1, 14);
$game15 = createMatchup(1, 15);
$game16 = createMatchup(1, 16);

mysql_close($con);

?>

<form action="insert_spreads.php" method="post">
<?php echo $game1; ?>
<br>
<?php echo $game2; ?>
<br>
<?php echo $game3; ?>
<br>
<?php echo $game4; ?>
<br>
<?php echo $game5; ?>
<br>
<?php echo $game6; ?>
<br>
<?php echo $game7; ?>
<br>
<?php echo $game8; ?>
<br>
<?php echo $game9; ?>
<br>
<?php echo $game10; ?>
<br>
<?php echo $game11; ?>
<br>
<?php echo $game12; ?>
<br>
<?php echo $game13; ?>
<br>
<?php echo $game14; ?>
<br>
<?php echo $game15; ?>
<br>
<?php echo $game16; ?>
<br /><br />
<input type="Submit" value="Submit Spreads">
</form>
I'm wondering if I can use this code for posting to the database (insert_spreads.php):
<?php

header("Location: admin_schedule.php");

include("opendatabase.php");

$w$weekg$gameA=("$_POST['w$weekg$gameA']");
$w$weekg$gameH=("$_POST['w$weekg$gameH']");

$sql="
UPDATE schedule 
SET A_pt_spread= '$w$weekg$gameA',H_pt_spread= '$w$weekg$gameH'
WHERE week_id = '$week'
AND game_id = '$game';

$result = mysql_query($sql) or die(mysql_error().$sql);

mysql_close($con)

?>



Thanks for helping.

TWO questions:

I haven't actually CONNECTED and POSTED.  My form has two input fields that combine in a TOTAL field. I notice that the address bar is carrying TOTAL=input1+input2 when it TRIES to connect.  Do I need to include
the TOTAL field in the database if the info is NOT relavant data? the strg and chick TOTALS? 

Will the database accept PARTIAL data from a form that has 25 field with only 6 being populated for testing?

I am working on a PHP/MySQL authorization script.
The script seems to work initially, but when I try to Login and post the Form (
        echo '<form method="post" action=authorize_1.php">';
   echo '<table>';
   echo '<tr><td>Userid:</td>';
   echo '<td><input type="text" name="userid"></td></tr>';
   echo '<tr><td>Password:</td>';
   echo '<td><input type="password" name="password"></td></tr>';
   echo '<tr><td colspan="2" align="center">';
   echo '<input type="submit" value="Log in"></td></tr>';
   echo '</table></form>';
)
Internet Explorer returns the error that the page is not found.... but I am using one .php file for the authorization so I am sure the page is found because i can see the Login portion.

Any ideas as to what is going wrong?

the code is in a form whose method = "post".
i have failed to echo $r_in. i eed help on this.

$lowest_time = 30 - 14;
$adder = 2*5*9;

echo   '<table width="526" border="0"><tr>
      <td width="169">
      <input type="text" name="$r_in" value="'.$lowest_time.'"  style="width:169px" readonly="readonly" class="text_non_color"/></td>
      <td width="169">
      <input type="text" name="$r_out" value="'.$adder.'"  style="width:169px" readonly="readonly" class="text_non_color"/></td>
      </tr></table>';

might have it nevermind.

i am basically trying to retrieve the response of a chatbot from mysql database with query below. As i run script i don't get any error from the server but it seems the post doesn't take $data2 which is an array that includes the keys "user_id" and "text" that are normally accepted (eg: $dmessage->post('direct_messages/new/wrap_links=true', 'text'->'example', '12345');

As result of the above i can't post to Twitter the chatobot response as the recipient (my other twitter account) doesn't get the answer...what do you think?

Code: [Select]

include_once ('connect.php');

connect_to_database();

$query2 = mysql_query ("SELECT response FROM conversation_log WHERE id = (SELECT MAX(id) FROM conversation_log)") or die (mysql_error());

$row = mysql_fetch_row($query2);

$response = $row[0];

//this is the array with the parameters to be used to send bot responses via Twitter API. It normally takes
$data2 = array("text"=>"$response" , "user_id"=> "$userid");

//this modifies the array values with response e userid fields
$data2["text"] = "$response";
$data2["user_id"] = "$userid";

require_once('config_oauth.php'); // includes the applications Oauth keys

require_once($_SERVER['DOCUMENT_ROOT'].'Program-O/gui/xml/oauth/twitteroauth.php'); //Full path to twitteroauth.php library

$dmessage = new TwitterOAuth($consumer_key,$consumer_secret, $oAuthToken, $oAuthSecret); // create new instance with the credentials

//sends the bot response via Twitter API by going through the array $data2
$dmessage->post('direct_messages/new/wrap_links=true', $data2);

How can I post this variable $healspell when I already have an echo within a php?

Here's what I have:



echo '<p>You cast Nature\'s Cure (Recovered <?=$healspell?>)</p>';


It's not printing anything out at the moment, obviously, and if I just put $healspell, it just echos out: $healspell.

Thanks!

I have an issue with my script, the date for some reason stopped posting after I changed the format in the date() section, I wanted it to post so it shows month-day-year, and it seems for some reason all it accepts is Y-m-d...

Can someone help me out here please?

Code: [Select]
<?php
require_once('connectvars.php');

  if (isset($_POST['submit'])) {
    // Connect to the database
    $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$PO_Date = date('MM "/" DD "/" YY',strtotime($_POST['PO_Date']));
$query = "INSERT INTO ncmr (PO_Date) VALUES ('$PO_Date')";
            mysqli_query($dbc, $query);



// Confirm success with the user
        echo '<p>The date have been successfully entered</p>';
mysqli_close($dbc);

// Clear the score data to clear the form
            $PO_Date = "";
}
echo'<form form id="all" method="post">';
echo '<div id="abd"><span class="b">On:&nbsp;&nbsp;</span><input type="text" name="Added_By_Date" value="" /></div>';
echo '<div id="button"><input type="submit" value="Submit Edits" name="submit" /></div>';
echo '</form>'
?>

Hi guys,

I have a list box.

say the code is
Code: [Select]
<select name="drop1" id="Select1" size="4" multiple="multiple">

    <option value="1">item 1</option>

    <option value="2">item 2</option>

    <option value="3">item 3</option>

    <option value="4">item 4</option>

    <option value="0">All</option>

</select>

The user will select few items.
How do i capture the data through the "POST" method.

Code: [Select]
$data = $_POST['drop'];
would not work coz there is an array if data.

Can any one help or point me in the right direction?

Thanks in advance

Is there anyway to do this:

my form is posting to self, then checking login creds. if they are incorrect it spits out "invaild bla bla" but if they are correct send them to a different page?

here is the short version of what I have.

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

//check inputs vs db

if ($check) {
header("Location: http://". $_SERVER['SERVER_NAME']."/include/process_renew.php");
} else { 
echo "<font color='red'>Username or Password did not match.</font> <br /><br />";
   }
}


}

I tested it using echo first and it worked fine then replaced the echo with header and now when I submit it just refreshes the page.

is this not possible?

Hi, i have written a form that uses 3 dropdown boxes, one of them being populated from a database.

The form code is as follows;

Code: [Select]
<form id="pointsForm" name="pointsForm" method="post" action="points-engine.php">

<select name="car" id="car">
<?php
        // result of car name collection
        $result = mysql_query ($query);
        
        //Array stored in $cars
        while($cars=mysql_fetch_array($result)){
            
        //option values added by looping through array
        echo "<option value=$cars[id]>$cars[carName]</option>";
        }
?>
</select>

<select name="season" id="season">
<option value="low">Low season</option>
<option value="mid">Mid season</option>
<option value="high">High season</option>
    <option value="peak">Peak season</option>
</select>
   
    <select name="period" id="period">
<option value="day">One day</option>
<option value="weekend">Weekend</option>
<option value="week">One week</option>
</select>

<input type="submit" name="Submit" value="Submit" /> 

</form>
which posts to;

Code: [Select]
<?php

$car=$_POST['car'];
echo $car;

$season=$_POST['season']; 
echo $season;

$period=$_POST['period'];
echo $period;

?>
The initial form code is working fine, the car field is being populated from the database. My problem is the post value for car isn't working...

points-engine.php is echoing $season & $period fine but not $car

can anyone tell me why?

many thanks
Richard

I'm trying to figure out a way to post data directly to a URL. For example:



<?php 
if (isset($_POST["pass"]) && ($_POST["pass"]=="$password")) {

echo "You did it";

?>

<?php 
}
else
{
  echo "<form method=\"post\"><p align=\"left\">";
  echo "<input name=\"pass\" type=\"text\" size=\"25\" maxlength=\"40\"><input value=\"Enter Pass\" type=\"submit\"></form>";
 exit;
} 
?>


Let's assume $password is 'password'. Why can't I simply pass the information through the URL to access the page with something like this:

Code: [Select]
http://mypage.com/the-same-page.php?pass=password

I'm not much of a PHP programmer so please excuse the mess but I'm having a problem with some code. I am able to successfully build a table and assign values to radio buttons based one information in a database. The problem comes when I want to update the database when someone changes a radio button. Everthing works up until the foreach statment. Nothing in the database is being updated, if I replace the sql statement with echo $v; all I get is the word Submit so it's like the rest of the values aren't being included in the form.
<link href="css/demo.css" rel="stylesheet" type="text/css">

<?php
session_start();
// dBase file
        include "dbconfig.php";
if (!$_SESSION["valid_user"])
        {
        // User not logged in, redirect to login page
        Header("Location: index.php");
        }
 //Grab GUID passed in the URL
 $guid=$_GET['guid'];
 // Create query for student name
  $sql = "SELECT FirstName, LastName FROM Students where GUID ='". $guid . "'";
  // Run query
  $result = mssql_query($sql);
  $row= mssql_fetch_assoc($result);
  
// Member only content
//Title and main page information
echo "<div align=\"center\"><p><img src=\"images/EFCTS Logo.jpg\" width=\"600\" height=\"144\" /></p><h1>OCAP DATABASE</h1></div>";
echo "<p><a href=\"logout.php\">Logout</a></p>";
//Build sortable table of student data.
echo "<table id=\"test1\" class=\"sortable-onload-3-reverse rowstyle-alt no-arrow\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";

//query database for table information
$SQLcommand = "SELECT convert(varchar(36), StudentGUID) as StudentGUID, CompetencyLevel, CompetencyName, CompetencyID, Category, convert(varchar(36), CompetencyGUID) as CompetencyGUID FROM VW_StudentSkills WHERE StudentGUID ='". $guid ."'";
$SQLresult = MsSQL_QUERY($SQLcommand);

//Continue building table
echo "<caption>".$row[FirstName]." ".$row[LastName]."</caption>";
echo "<th style=\"-moz-user-select: none;\" class=\"sortable-numeric fd-column-0\"><a title=\"Sort on \"Competency ID\"\" href=\"#\">Competency ID</a></th>";
echo "<th style=\"-moz-user-select: none;\" class=\"fd-column-1 sortable-text reverseSort\"><a title=\"Sort on \"Catagory\"\" href=\"#\">Catagory</a></th>";
echo "<th style=\"-moz-user-select: none;\" class=\"fd-column-2 sortable-text reverseSort\"><a title=\"Sort on \"Competency Name\"\" href=\"#\">Competency Name</a></th>";
echo "<th style=\"-moz-user-select: none;\" class=\"sortable-numeric fd-column-3\"><a title=\"Sort on \"Competency Level\"\" href=\"#\">Competency Level</a></th>";
echo "</tr></thead>";
//Set variables for radio buttons
$a="";
$b="";
$c="";
$d="";

//count the number of rows returned
$count=mysql_num_rows($SQLresult);
//Start form
echo "<form name=\"form1\" method=\"post\" action=\"".$_SERVER['REQUEST_URI']."\">";

$groupnum = 0;
//Build table with SQL data
while($row2=mssql_fetch_array($SQLresult)) 
{

//find the competency level
$complevel = $row2[CompetencyLevel];
if($complevel=="1") $a="checked";
if($complevel=="2") $b="checked";
if($complevel=="3") $c="checked";
if($complevel=="4") $d="checked";
//build the table
echo "<tr class=\"\"><td>".$row2[CompetencyID]."</td><td>".$row2[Category]."</td>";
echo "<td>".$row2[CompetencyName]."</td>";
echo "<td class=\"lft\"><input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"1\"".$a."> 1";
echo "<input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"2\"".$b."> 2";
echo "<input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"3\"".$c."> 3";
echo "<input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"4\"".$d."> 4";
$idarray[]=$row2[CompetencyGUID];
echo "</td></tr>";
$groupnum++;
//clear the variables
$a="";
$b="";
$c="";
$d="";
}

echo "</tbody>";
echo "<input type=\"submit\" name=\"Submit\" value=\"Submit\">";
echo "</form></table>";
echo "<script type=\"text/javascript\" src=\"javascript/tablesort.js\"></script>";

                  if($_POST['Submit'])
                        {
                           echo"submit button detected";
   foreach($_POST as $k=>$v)
                           {                               
                             if($k!="Submit") { 
                              $sqlUpdate = "UPDATE DATA SET COMPETENCYLEVEL = '".$v."' WHERE COMPETENCYGUID = '".$idarray."' AND STUDENGUID = '".$guid."' ";
                              $resultUpdate = mssql_query($sqlUpdate);
  }

                           }
                        }
if($resultUpdate)
                        {    print_r ($_POST); 
echo $resultUpdate;     
echo $sqlUpdate;                  
                                                      
                        }
                        else
                        {
                           echo "Your entry is not completed at this time.............";
   echo $sqlUpdate;
   echo $resultUpdate;
                        }
                    
// Display Member information
//echo "<p>User ID: " . $_SESSION["valid_id"];
//echo "<p>Username: " . $_SESSION["valid_user"];
//echo "<p>Logged in: " . date("m/d/Y", $_SESSION["valid_time"]);

?>