<?php
include("opendb.php");
//echo isset($_POST['submit']);
if(isset($_POST['submit']))
{
$filename=$_FILES['files']['name'];
$filename=date('U').$filename;
$add1 = "import/$filename";
move_uploaded_file($_FILES[files][tmp_name], $add1);
chmod($add1,0777);
basename($_FILES['files']['name'] );
$filename1="import/$filename";
$fcontents = file ($filename1);
echo sizeof($fcontents);
for($i=0; $i<sizeof($fcontents); $i++) {
$line = addslashes(trim($fcontents[$i]));
$arr = explode("\t", $line);
echo "<pre>";
print_r($arr);
//exit();
//echo $arr;
$Repl_arr=array("[","]");
//echo $Repl_arr;
foreach($arr as $key=>$val)
{
$arr[$key]=str_replace($Repl_arr,"",$arr[$key]);
$arr_new=$arr[$key];
$arr_new1 = explode(",", $arr_new);
}
//echo "<PRE>";
//var_dump($arr_new1);
/*
$date=explode("/", $arr_new1[0]);
$dd=$date[0];
$mm=$date[1];
$yy=$date[2];
if(strlen($dd)==1){
$dd="0".$dd;
}
if(strlen($mm)==1){
$mm="0".$mm;
}
$date1=$yy."-".$mm."-".$dd;
*/
$name=$arr_new1[0];
$addr = $arr_new1[1];
//$email=$arr_new1[2];
//$amount=$arr_new1[3];
$sql = "insert into mytestupload set
tfield='$name',tfield1='$addr'";
//echo $sql;
//exit();
$qr=mysql_query($sql);
echo "-----------1 Row Inserted----------";
$sql ."<br><br>\n";
if($qr!=0)
$msg= "Data has been imported";
if(mysql_error()) {
echo mysql_error() ."<br>\n";
}
}
unlink($filename1);
unset($_POST);
$_POST['submit']='';
$_POST='';
//echo "<script>window.location=('addcsv.php');</script>";
} ?>
<html>
<head>
<title>Import CSV</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../css/decorate.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top"><table width="100%" border="0">
<tr>
<td height="25" align="center" class="label">Import CSV Tax File </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td valign="top"><form action="addbatchtext.php" method="post" enctype="multipart/form-data">
<table width="100%" border="1">
<tr>
<td width="30%" class="line2">File Name:</td>
<td width="70%" align="left" class="line2"><input name="files" type="file" class="inp"></td>
</tr>
<tr>
<td class="line2"> </td>
<td align="left" valign="middle" class="line2"> </td>
</tr>
<tr><td class="line2"> </td>
<td align="left" valign="middle" class="line2">
<input name="submit" type="submit" class="buttons" value="Submit" ></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts
Tuesday, January 17, 2012
Uploading and Save CSV file in MySQL database with PHP
Uploading and Save CSV file in MySQL database with PHP
Monday, December 26, 2011
Where does MySQL database stored its data in my harddisk?
Where does MySQL database stored its data in my harddisk?
It depends on where you want it to be stored. Normally you can find the location of your mysql data files in this following config file.
C:\Program Files\MySQL\MySQL Server 5.1\my.ini
If you are using XAMPP, you can find it in here :
D:\xampp\mysql\bin\my.ini
But you may not need to look into that file since you can find your data files in this follow directory.
D:\xampp\mysql\data
Enjoy!! Thanks...
"Correct my if i am wrong by leaving comments down there" :D
It depends on where you want it to be stored. Normally you can find the location of your mysql data files in this following config file.
C:\Program Files\MySQL\MySQL Server 5.1\my.ini
If you are using XAMPP, you can find it in here :
D:\xampp\mysql\bin\my.ini
But you may not need to look into that file since you can find your data files in this follow directory.
D:\xampp\mysql\data
Enjoy!! Thanks...
"Correct my if i am wrong by leaving comments down there" :D
Friday, December 23, 2011
MySQL : "The user specified as a definer ('root'@'%') does not exist"
If you've found following error while using mysql database:
The user specified as a definer ('root'@'%') does not exist
Then you can solve it by using following :
grant all on *.* to 'root'@'%' identified by 'password' with grant option;
The user specified as a definer ('root'@'%') does not exist
Then you can solve it by using following :
grant all on *.* to 'root'@'%' identified by 'password' with grant option;
Subscribe to:
Posts (Atom)