sunnythangaraj
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Adding csv file in database
in PHP Coding Help
Posted
Hey anybody can please guide me where I m wrong in this php code
please reply
here is the code
Only variables should be passed by reference on line 3
in that function area function get_file_extension($file_name)
main error I guess is the explode one
Aand yeah I checked adding
$file_name = $_FILES['fld']; before the function is started
<?php
require("include/dbconn.php");
//$username = mysql_real_escape_string($_POST['username1']);
function get_file_extension($file_name) {
return end(explode('.',$file_name));
}
function errors($error){
if (!empty($error))
{
$i = 0;
while ($i < count($error)){
$showError.= '<div class="msg-error">'.$error[$i].'</div>';
$i ++;}
return $showError;
}// close if empty errors
} // close function
if (isset($_POST['submit'])){
$username = "Sunny";
$date1 = date("d m y");
mysql_select_db("deals") or die(mysql_error());
if($username == "")
{
//header("location:newnewuser1.php");
echo "Username empty";
//header("location:newnewuser1.php");
}
else
{
function createRandomPassword() {
$chars = "abcdefghijkmnopqrstuvwxyz023456789";
srand((double)microtime()*1000000);
$i = 0;
$pass = '' ;
while ($i <= 7) {
$num = rand() % 33;
$tmp = substr($chars, $num, 1);
$pass = $pass . $tmp;
$i++;
}
return $pass;
}
// Usage
$password = createRandomPassword();
//$password = mysql_real_escape_string($_POST['Password']);
$date = strtotime("+2hours");
$date1 = date("d-m-y",$date);
if(get_file_extension($_FILES["fld"]["name"])!= 'csv')
{
$error[] = 'Only CSV files accepted!';
echo "Wrong Input";
}//get_file_extension
if (!$error)
{
$tot = 0;
$handle = fopen($_FILES["fld"]["tmp_name"], "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
for ($c=0; $c < 1; $c++) {
try {
mysql_query("INSERT INTO newusers (email,password,location,company,name,contact,sourcename,date)VALUES('".mysql_real_escape_string($data[0])."','$password','".mysql_real_escape_string($data[1])."',
'".mysql_real_escape_string($data[2])."','".mysql_real_escape_string($data[3])."','".mysql_real_escape_string($data[4])."','$username1','$date1')");
$tot++;
}
catch(Exception $e)
{
PRINT 'ERROR:' +$e;
}
}//for
}//while
fclose($handle);
}// end no error
}//close if isset upfile
}
?>
and this is the form code
<form name="f1" action="" method="POST" enctype="multipart/form-data">
<table><tr><td><input type="file" value="Browse" name="fld" onselect="CheckExtension(fld)"><br/></td><td> </td></tr><tr><td>Username :<input type="text" name="username1" value="" id="user" onfocus="validateForm1()"></td>
<td><input type="submit" name="submit" value="submit" id="submit"></td></tr></table>
</form>
Please help me I m stuck in this quite badly
Please
[attachment deleted by admin]