By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,319 Members | 1,963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,319 IT Pros & Developers. It's quick & easy.

how to insert values into mysql, after parsing a submiting textbox?

P: 10
Hello!!
how do i insert values into mysql , after parsing a submiting textbox??
I made the arrays, so this should be a basic insertion of them in the db, but something is missing, or in the wrong place...can anyone help me??

i didnt made anything in the VALUES (unless the POST [textbox]), because i bet the error is there (yes, the arrays are missing):

$sql = "INSERT INTO dgplanets ( ID, coords , player name , alliance , name , ground , orbit , metal% , mineral% , food% , energy% , pop ) VALUES ('".$_POST['textbox']."')"; */

here´s the code :
[PHP]<?php

/*
* makes the connection
* and select the database
*/
$conexao = mysql_connect("localhost", "root", "12345")
or die ("Error connecting to db");
$db = mysql_select_db("dg")
or die ("error selecting db");

//here is where i should input the arrays??
$sql = "INSERT INTO dgplanets ( ID, coords , player name , alliance , planet name , ground , orbit , metal% , mineral% , food% , energy% , pop ) VALUES ('".$_POST['textbox']."')"; */




$_POST['data'] = (empty($_POST['data'])) ? '' : $_POST['data'];

$data = array(
'parsed' => FALSE,
'player' => array('name' => ''),
'planet' => array()
);

if (!empty($_POST['data']))
{
$subject = trim($_POST['data']);
$subject = str_replace(array("\t", "\r", "\r\n"), array(' ', "\n", "\n"), $subject);
$subject = preg_replace(array('/[ ]+/', '/([ ]*\n+[ ]*)+/') , array(' ', "\n"), $subject);

//echo '<pre>';
//echo $subject;
//echo '</pre>';

//
// First we find the player name
//
$pattern = '/';
$pattern .= '(.+) [Logout]\n'; // player name
$pattern .= '(?:';
$pattern .= ')*?';
$pattern .= '/iU'; // tirase ?

$matches = array();

if (preg_match($pattern, $subject, $matches))
{
$data['player']['name'] = $matches[1];
}

//
// Now we parse the planet data
//
$pattern = '/';
$pattern .= '(.+) - \((\d+)\) (.+) (.+)\n';
$pattern .= '([\d,]+) \(\+([\d,]+)\) (\d+)% ([\d,]+) \(\+([\d,]+)\) (\d+)% ([\d,]+) \(\+([\d,]+)\) (\d+)% ([\d,]+) \(\+([\d,]+)\) (\d+)%
';
$pattern .= '/i';

$matches = array();
if ($size = preg_match_all($pattern, $subject, $matches))
{
$data['player']['planets'] = $size;

foreach ($matches[0] as $key => $val)
{
$matches[0][$key] = str_replace("\n", ' ', $val);
}


//echo '<pre>';
//print_r($matches);
//echo '</pre>';

for ($i = 0; $i < $size; $i++)
{
$planet = array(
'planet.name' => $matches[1][$i],
'id' => $matches[2][$i],
'ground' => $matches[3][$i],
'orbit' => $matches[4][$i],
'metal.ouput' => str_replace(',', '', $matches[6][$i]),
'metal.stored' => str_replace(',', '', $matches[5][$i]),
'mineral.abudance' => $matches[10][$i],
'mineral.ouput' => str_replace(',', '', $matches[9][$i]),
'mineral.stored' => str_replace(',', '', $matches[8][$i]),
'food.abudance' => $matches[13][$i],
'food.ouput' => str_replace(',', '', $matches[12][$i]),
'food.stored' => str_replace(',', '', $matches[11][$i]),
'energy.abudance' => $matches[16][$i],
'energy.ouput' => str_replace(',', '', $matches[15][$i]),
'energy.stored' => str_replace(',', '', $matches[14][$i]),
'metal.abudance' => $matches[7][$i],
'pop' => str_replace(',', '', $matches[17][$i]),
);
$data['planet'][] = $planet;
}
$data['parsed'] = TRUE;
}
}







/*
* executes the query
*/
$sql = mysql_query($sql)
or die ("there was a mistake");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<h1>INSERT PLANET LIST</h1>

<form action="test.php" method="post">

<label for="texto"></label>
<textarea name="textbox" id="text" rows="10" cols="30" />
</textarea><br />

<input type="submit" value="insert">

</form>
</body>
</html>[/PHP]
Jul 19 '07 #1
Share this Question
Share on Google+
2 Replies


P: 10
any clue?!?! you can give just a small example :)
Jul 20 '07 #2

P: 22
Hey, Yeah it is on $_POST. Post is defined by the script referring to it so therefore you must redefine the variable so it can be edited.

For Example:
$post = $_POST['whatever'];

Then do

$post = explode('Seperator' , $post);

Then send it to you query with post instead of $_POST['post'];

I like your coding style ;).

~Tyler
Jul 20 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.