PHP - Moved: Message Box With Auto Post To Page

Hello,
I need to post plenty of data to a file with a java file with a .do extension using a php program.
How do I get to auto-post mass data in php from a database straight to this java file?
Put in mind that each mysql record is posted as its own form as in: <form ...>mysql record</form>

Thanks in advance

original sql
Code: [Select]
-- --------------------------------------------------------

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(6) NOT NULL auto_increment,
  `value` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=243 ;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1, 'Vancouver');

New Sql
Code: [Select]
-- --------------------------------------------------------

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(6) NOT NULL auto_increment,
  `value` varchar(250) NOT NULL default '',
  `code` varchar(12) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=243 ;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1, 'Vancouver', 'BC-50');

PHP code for the job
Code: [Select]
<?php

// PHP5 Implementation - uses MySQLi.
// mysqli('localhost', 'yourUsername', 'yourPassword', 'yourDatabase');
$db = new mysqli('localhost', 'root' ,'password', 'weather');

if(!$db) {
// Show error if we cannot connect.
echo 'ERROR: Could not connect to the database.';
} else {
// Is there a posted query string?
if(isset($_POST['queryString'])) {
$queryString = $db->real_escape_string($_POST['queryString']);

// Is the string length greater than 0?

if(strlen($queryString) >0) {
// Run the query: We use LIKE '$queryString%'
// The percentage sign is a wild-card, in my example of countries it works like this...
// $queryString = 'Uni';
// Returned data = 'United States, United Kindom';

// YOU NEED TO ALTER THE QUERY TO MATCH YOUR DATABASE.
// eg: SELECT yourColumnName FROM yourTable WHERE yourColumnName LIKE '$queryString%' LIMIT 10

$query = $db->query("SELECT your_column FROM your_db_table WHERE your_column LIKE '$queryString%' LIMIT 10");
if($query) {
// While there are results loop through them - fetching an Object (i like PHP5 btw!).
while ($result = $query ->fetch_object()) {
// Format the results, im using <li> for the list, you can change it.
// The onClick function fills the textbox with the result.

// YOU MUST CHANGE: $result->value to $result->your_colum
          echo '<li onClick="fill(\''.$result->value.'\');">'.$result->value.'</li>';
          }
} else {
echo 'ERROR: There was a problem with the query.';
}
} else {
// Dont do anything.
} // There is a queryString.
} else {
echo 'There should be no direct access to this script!';
}
}
?>

What the original code does
1) you start typing your city (eg. Van)
2) when you type the first letter (eg. V), it looks into mysql and auto fills a dropdown menu with all possible cities

What i need it to do
1) you start typing your city (eg. Van)
2) when you type the first letter (eg. V), it looks into mysql and auto fills a dropdown menu with all possible cities
3) when you find your city you click it or press enter, and it POST's the city code as well

now how do i munipulate the script to do that...

another thing, when i put the extra sql entry in "code", the auto fill stopped working, why?

Thanks

Currently I can use php snoopy class to auto login in wordpress, but when I try to use the same method to post some articles in wordpress. It does not work. Any one has any ideas?

I have tried to use httpwatch to monitor the post data and cookies. It seems I have include everything, but still doesn't work.

thanks very much. This really driving me crazy.


<?php 
    include "Snoopy.class.php"; 

    $snoopy = new Snoopy; 

//login part

      $submit_url = "http://localhost/wordpress/wp-login.php";   
      $submit_vars["log"] = "baibai"; //username
      $submit_vars["pwd"] = "123456";  //password
      $submit_vars["rememberme"] = "forever"; 
      $submit_vars["redirect_to"] = "http://localhost/wordpress/wp-admin/";
      $submit_vars["testcookie"] = "1";
      $submit_vars["wp_sumbit"] = "submit"; 
      $snoopy->submit($submit_url,$submit_vars); 

      print $snoopy->results; 

      $snoopy->setcookies();
      $cookies = $snoopy->cookies;
      print_r ($cookies);


//above part runs perfectly

    //post


    $snoopy->fetchform("http://localhost/wordpress/wp-admin/press-this.php");


    print $snoopy->results; 

    preg_match('/name=\"_wpnonce\" value=\"([0-9a-z]+)/',$snoopy->results,$matches);
    print $submit_vars1["_wpnonce"] = $matches[1];


        $submit_vars1["autosave"] = "";
        $submit_vars1["newtag[post_tag]"] = "";
        $submit_vars1["tax_input[post_tag]"] = "";
        $submit_vars1["autosave"] = "";
        $submit_vars1["title"] = "title";
        $submit_vars1["content"] = "content this is what i want post in wordpress";
        $submit_vars1["original_post_status"] = "draft";
        $submit_vars1["prev_status"] = "draft"; 
        $submit_vars1["post_type"] = "text";
        $submit_vars1["publish"] = "&#21457;&#24067;";
        $submit_vars1["_wp_http_referer"] = "/wordpress/wp-admin/press-this.php?u=http%3A%2F%2Flocalhost%2Fwordpress%2Fwp-admin%2Ftools.php&t=%E5%B7%A5%E5%85%B7%20%E2%80%B9%20ekeyvision%20%E2%80%94%20WordPress&s=&v=4";

    $submit_url1 = "http://localhost/wordpress/wp-admin/press-this.php?action=post"; 


    $snoopy->submit($submit_url1,$submit_vars1); 
    print $snoopy->results;


?>


Also I do not want to use XML-RPC to solve this issue, since xml-rpc are not available is some settings. thanks

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=314181.0

Some code from my pages ,   Page1 ( Redirecting page )

<html>
<title>login_redirect.</title>
body>

<form name="redirect" action="http://mysite/page2.php" method="post">
<input type="hidden" name="mac" value="$(mac)">
</form>

<script language="JavaScript">
<!--
document.redirect.submit();
//-->
</script>
</body>
</html>

Page 2 ( select product )

<?php


session_start();

ini_set('display_errors',1);
error_reporting(E_ALL); 

include '../lib/config.php';
include '../lib/opendb.php';

// get user mac adres from redirect post page1
$_SESSION['macid'] = $_POST['mac'];
// set $macid for other use ( maybe not needed, am learning )
$macid = $_SESSION['macid'];

// echo $macid does show mac adress, so variable is not empty here


if (!empty($_POST["submit"]))

{
$product_choice = $_POST['accounttype'];
$query= "SELECT AccountIndex, AccountCost, AccountName FROM AccountTypes WHERE AccountIndex='$product_choice'";
$result = mysql_query($query) or die('Query failed. ' . mysql_error()); 
while($row = mysql_fetch_array($result))
{
$_SESSION['AccountIndex'] = $row['AccountIndex'];
$_SESSION['AccountCost'] = $row['AccountCost'];
$_SESSION['AccountName'] = $row['AccountName'];
}


header('Location: page3.php');

}

// did leave out the other/html/form stuff here

Page 3 ( show Session variables )

<?php


ini_set('display_errors',1);
error_reporting(E_ALL); 

session_start();

print_r($_SESSION);

?>

Now, on page 3 i do see the right session varables, only the "macid" is empty.   why ?    

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=353052.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=346794.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=344720.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=347166.0

This topic has been moved to PHP Freelancing.

http://www.phpfreaks.com/forums/index.php?topic=358545.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=310983.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=310894.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=321437.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=352528.0

Hello,
I am trying to echo a message before redirecting the visitor to another page.
The destination is a variable. This is what i have so far:

Code: [Select]
<?php
if (array_key_exists($_GET[id],$links))
{
$red = $links[$_GET[id]];
header("HTTP/1.1 301 Moved Permanently;");
header("Refresh:3; url=$red");
echo "You will be redirected to..";
}
else { 
 header("Location: http://www.example.com");
}
exit(); ?>


The problem is that it works in Firefox, but not IE. In IE it will work if there is no message and no delay, like the code below:
Code: [Select]
<?php
if (array_key_exists($_GET[id],$links))
{
$red = $links[$_GET[id]];
header("HTTP/1.1 301 Moved Permanently;");
header("Location: $red");

}
else { 
 header("Location: http://www.example.com");
}
exit(); ?
Does anybody have any idea, what is wrong with this code?
Thank you in advance!