PHP - Help With Posting To Xml

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);

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"

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!

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[]"/>

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 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>'
?>

might have it nevermind.

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?

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.

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 have a db table with 1500 street names inside - id, tfare, ptown, pcode, area.

The 'area' column is specific to the company i work for and each street belongs to an 'area' number defined by the company.

Currently each area is '0' - unassigned. The company areas are numbered 1 - 18. I need to list each street (LIMIT 10 at a time), and have an input box for the area to be edited and saved.

The following code works perfectly well when dealing with 1 record at a time (LIMIT 0, 1), but breaks when i change the LIMIT to 10.

I'm trying to show the dinosaur management that we need to upgrade our paper, yes, paper system to computers. I'm a transport manager, but in my spare time since 2004 I'm fluent in HTML and CSS, but only in the last few months really decided to give PHP and MySQL a *real* go.

I'm 'guessing' I need to look into arrays for this to work? I've tried searching about but I dont even know how to articulate what i need to search for, so I have to publicly ask for help via this long winded post, sorry

Here is my code:



<?php

include($_SERVER['DOCUMENT_ROOT'].'/!SYSTEM/bootstrap.php');

if(isset($_POST['savearea']))
{
    $id = $_POST['hideID'];
    $area = $_POST['area'];
   
    $sql = "UPDATE bmth_streetindex SET area='$area' WHERE id='$id'";
   
    if ($query = mysql_query($sql)or die(mysql_error()))
        {
         print "saved ???";
        }
}

    // grab data from bmth street index where the area is = 0 (which means its area is un-assigned)
    $sql = "SELECT * FROM bmth_streetindex WHERE area='0' LIMIT 0, 10";
    $rs = mysql_query($sql) or die(mysql_error());


print $HTML::form('action="" name="inputAreaForm" method="POST"')."\n\n";
   
    // 'while' thru and print them 1 at a time
    while($row = mysql_fetch_array($rs))
    {
        $id = $row['id'];
        $tfare = $row['tfare'];
        $ptown = $row['ptown'];
        $pcode = $row['pcode'];
        $area = $row['area'];
        $urlQ = $tfare. ", " .$ptown. ', ' .$pcode;
       
        print "<div>\n";
       
            print "\n<input type=\"hidden\" name=\"hideID\" value=\"$id\">";
           
            print "\n[$id] $tfare, $ptown, $pcode &nbsp;&nbsp;&nbsp;";
            print "\nArea <input type=\"text\" name=\"area\" value=\"$area\" />";
            print "\n<input type=\"submit\" name=\"savearea\" value=\"Save Area\">";
           
            print "\n<a href=\"http://www.google.com/maps?q=$urlQ&hl=en&ie=UTF8&z=17\" target=new>SHOW ON MAP</a>";
           
        print "\n<>\n<hr>\n\n";
    }

print $HTML::endForm();


?>




Thank you for taking the tie to read this, I hope someone can point me in the right direction for what i need to look into making this work

Hi There,

I have a series of submit buttons that I would like to update records in a table when they are pressed. For example, when clicked, I would like them to run the following statement:

update mytable set completed = 1 where colname = $variable

I would then like it to refresh the page.

Is there a way of doing this?

Thanks
Matt

I have a database in which i store articles that contain all type of special characters including slashes, single quotes, double quote etc.

Previously it was working fine, but now after the updating the xampp, things are not going as usual.

I insert are articles using following code

$query = "INSERT INTO `articles` (`source`, `heading`, `description`, `catagory`, `detail`, `date`, `timestamp`)
          values ('$source', '$heading', '$desc', '$catagory', '$detail', '$date', '$timestamp')";

Error I am getting is

Error Running query 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's economy and emphasized that international community should provide its complet' at line 2

Can anybody tell me whats wrong with my script?

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