coding problem.

Mark_Nordstrom

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form method="post" action="result1.php" enctype="multipart/form-data"> 
<input type="file" name="form_data" size="40">
  <br>
  <select name="team" id="team">
    <option>atlanta</option>
  </select>
  <p><input type="submit" name="submit" value="submit"> 
</form> 
</body>
</html>

You see the select name="team well i want whatever they select from that drop down to be entered into the database along with this code

<?php include(config.php); ?>
<?
$fp = fopen("$form_data", "r");
$flatfile = fread($fp, filesize("$form_data"));
fclose($fp);

for ($i = 1; $i <= 10; $i++) {
  $flatfile = ereg_replace(" {3}", "  ", $flatfile);
}

$csv = ereg_replace(" {2}", ", ", $flatfile);
fwrite($fp, $csv);
fclose($fp);


$result = mysql_db_query('all-nba_net' ,"LOAD DATA LOCAL INFILE '$form_data' INTO TABLE stats1 
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' 
IGNORE 5 lines 
(`pos`, `no`, `name`, `pts`, `mins`, `fgm`, `fga`, `fg%`, `threepm`, `threepa`, `threep%`, 
`ftm`, `fta`, `ft%`, `orebounds`, `drebounds`, `rebounds`, `blocks`, `steals`, `assist`, `to`, 
`fouls`)") or die(mysql_error());
?>

this code works fine but i wanna add the team part . I want it to take the team they selected then add it to the database under the field team, table stats1

Mark_Nordstrom

also it has to add the team name to each row of the txt file that is being submitted.

Mark_Nordstrom

anyone got any ideas ?

feldon23

Erm, I've never worked with MySQL or $form_data.

$_POST['team'] should be coming thru with the right country information as I have my script set the same way...

<select name="Country">
	<option selected>United States
	<option>Africa
	<option>Argentina
</select>

I haven't tested to see what comes thru $_POST['Country'] because I am passing my info on to a modified FormMail.pl.

By the way, lose the stray <p>.

Mark_Nordstrom

is there anyway to make the script when it uses fwrite to have it write the team selected from the form put in each row after name ? or even before each row.

Mark_Nordstrom

Theres also another way. In each text file that is submitted the team name is there. Is it possible to take that name and put it in each row ?

feldon23

If you want to add something to the beginning of each row, then you are going to want to search for chr(13).chr(10) and insert your $_POST['team'] after each instance of chr(13).chr(10) and before the next character.

I don't have time to write the code right now.

Mark_Nordstrom

ill try man, but dont know this much php to do it. Again ill try but if you got time later i would appreciate the help. Thanks. If not thats fine you have helped me enough as it is.

Mark_Nordstrom

so anyone got any ideas ? Been messing with the Fwrite but cant get it to work.

Mark_Nordstrom

Looked at some tutorials on Fwrite but no luck. Dam this is hard.

feldon23

You don't need to change the fwrite. The only thing you need to change is adding more stuff to the string $flatfile right before this line:

fwrite($fp, $csv);

Mark_Nordstrom

add what thou ?? cant find anything in any tutorials to help.

feldon23

Ok, you are wanting to add the team name at the beginning of each line.

The END of each line is chr(13).chr(10) (return, linefeed).

So what you want to do is find every chr(10) match in the file (which is loaded into memory as $flatfile) and insert $_POST['team'] in between chr(10) and the first character of each new line.

So how about

$csv = ereg_replace(" {2}", ", ", $flatfile);
$temp = str_replace(chr(10), chr(10).$_POST['team'], $csv);
fwrite($fp, $temp);

By the way, if you don't put a comma after the team name, then this comma separate value file won't load properly into Excel, etc.

So $_POST['team'].", "

Mark_Nordstrom

thanks man. Still got a problem where its posting the pre team name text file into database then posting the after one to. No idea why but ill look at it. Heres the hole php code thou if you figure it out let me know.

<?php include(config.php); ?>
<?php
$fp = fopen("$form_data", "r");
$flatfile = fread($fp, filesize("$form_data"));
fclose($fp);

for ($i = 1; $i <= 10; $i++) {
  $flatfile = ereg_replace(" {3}", "  ", $flatfile);
}

$csv = ereg_replace(" {2}", ", ", $flatfile);
$temp = str_replace(chr(10), chr(10).$_POST['team'],  $csv);

$fp = fopen("$form_data", "w+");
fwrite($fp, $csv);
fwrite($fp, $temp);
fclose($fp);
?>
<?
$result = mysql_db_query('all-nba_net' ,"LOAD DATA LOCAL INFILE '$form_data' INTO TABLE stat FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 5 lines ") or die(mysql_error());
?>

Mark_Nordstrom

I do see the 2 fwrite commands but it wont work without 2. It wont upload anything to the database without it like that.

Mark_Nordstrom

I got it thanks for the help man you have really helped ALOT.

Mark_Nordstrom

Final code was

<?php include(config.php); ?>
<?php
$fp = fopen("$form_data", "r");
$flatfile = fread($fp, filesize("$form_data"));
fclose($fp);

for ($i = 1; $i <= 10; $i++) {
  $flatfile = ereg_replace(" {3}", "  ", $flatfile);
}

$csv = ereg_replace(" {2}", ", ", $flatfile);
$temp = str_replace(chr(10), chr(10).$_POST['team'], $csv);

$fp = fopen("$form_data", "w+");
fwrite($fp, $temp);
fclose($fp);

$result = mysql_db_query('all-nba_net' ,"LOAD DATA LOCAL INFILE '$form_data' INTO TABLE stat FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 5 lines ") or die(mysql_error());
?>