<?php
    session_start(); 
	error_reporting(E_ALL);
    ini_set('display_errors', 1);
	
	require_once('PHPExcel.php');

	$host="localhost";
    $dbname="exeletodb";
    $user="root";
    $pass="";
    $dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
	
	$index = 9;
	
	// Open the worksheet
	$objReader = new PHPExcel_Reader_Excel5();
	$objPHPExcel = $objReader->load("1951base.xls");
	$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
	$objPHPExcel->getSheet(0)->setRightToLeft(true);
	$objWorksheet = $objPHPExcel->getSheet(0);
	
	$stmt = $dbh->prepare("INSERT INTO data_madad (year, month, madad) VALUES (:year, :month, :madad)");
    $stmt->bindParam(':year', $year);
	$stmt->bindParam(':month', $month);
	$stmt->bindParam(':madad', $madad);
    $year = $objPHPExcel->getActiveSheet()->getCell('A8')->getValue();
	$month = 9;
	$madad = $objPHPExcel->getActiveSheet()->getCell('E8')->getValue();
    $stmt->execute();
	
	$stmt = $dbh->prepare("INSERT INTO data_madad (year, month, madad) VALUES (:year, :month, :madad)");
    $stmt->bindParam(':year', $year);
	$stmt->bindParam(':month', $month);
	$stmt->bindParam(':madad', $madad);
	$year = $objPHPExcel->getActiveSheet()->getCell('A8')->getValue();
	$month = 10;
	$madad = $objPHPExcel->getActiveSheet()->getCell('D8')->getValue();
    $stmt->execute();
	
	$stmt = $dbh->prepare("INSERT INTO data_madad (year, month, madad) VALUES (:year, :month, :madad)");
    $stmt->bindParam(':year', $year);
	$stmt->bindParam(':month', $month);
	$stmt->bindParam(':madad', $madad);
	$year = $objPHPExcel->getActiveSheet()->getCell('A8')->getValue();
	$month = 11;
	$madad = $objPHPExcel->getActiveSheet()->getCell('C8')->getValue();
    $stmt->execute();
	$year = $objPHPExcel->getActiveSheet()->getCell('A8')->getValue();
	$month = 10;
	$madad = $objPHPExcel->getActiveSheet()->getCell('B8')->getValue();
    $stmt->execute();
	
	for($i = 9; $i < 71; $i++)
	{
	    for($j = 0; $j < 12; $j++)
		{
	        $current_month = 77 - $j; 
		 
	        $stmt = $dbh->prepare("INSERT INTO data_madad (year, month, madad) VALUES (:year, :month, :madad)");
            $stmt->bindParam(':year', $year);
	        $stmt->bindParam(':month', $month);
	        $stmt->bindParam(':madad', $madad);
	        $year = $objPHPExcel->getActiveSheet()->getCell('A'.$i.'')->getValue();
     	    $month = $j + 1;
	        $madad = $objPHPExcel->getActiveSheet()->getCell(''.chr($current_month ).'8')->getValue();
            $stmt->execute();
		}
	}