Hi
<?php
require_once 'Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('CP1251');
$data->read('Book3.xls');
$conn = mysql_connect("localhost","root","root");
mysql_select_db("database",$conn);
for ($x = 0; $x <= count($data->sheets[0]["cells"]); $x++) {
$id = $data->sheets[0]["cells"][$x][1];
$empID = $data->sheets[0]["cells"][$x][2];
$timein = $data->sheets[0]["cells"][$x][3];
$timeout = $data->sheets[0]["cells"][$x][4];
$sql = mysql_query("INSERT INTO `mytable` (id, empID, timein, timeout) VALUES ('$id', '$empID', '$timein', '$timeout')");
//echo $sql ."\n";
if($sql){
echo 'okay <br />';
} else {
echo 'Data <font color="RED">'.$empID.'</font> not stored in database. <br>';
}
}
?>
-- phpMyAdmin SQL Dump
-- version 3.3.9
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 24, 2012 at 07:46 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `database`
--
-- --------------------------------------------------------
--
-- Table structure for table `timesheet`
--
CREATE TABLE IF NOT EXISTS `timesheet` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`empID` int(10) NOT NULL,
`timein` datetime NOT NULL,
`timeout` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `timesheet`
--
thats all what ive got.
Regards,