ahmeti/mysql_insert.html

## mysql_insert.html
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width">
    <title>Excel to Mysql Insert</title>
    <script>
    function run()
    {
        var query='';
        var lines = document.getElementById("excel").value.split('\n');
        var countl=lines.length;
        for(var i = 0; i < countl; i++)
        {
            var columns=lines[i].split('\t');
            var countc=columns.length;
            var subquery='';
            for(var c = 0; c < countc; c++)
            {
                subquery += "`" + columns[c] + "`";
                if (c !== countc-1){ subquery += ','; }
            }
            query += '(' + subquery + ')';
            if (i !== countl-1){ query += ','; }
            query += "<br>";
        }
        var cols = document.getElementById("columns").value.split('\t');
        countcols=cols.length;
        var prequery='INSERT INTO '+document.getElementById("table").value+' (';
        for(var d = 0; d < countcols; d++)
        {
            prequery += "`" + cols[d] + "`";
            if (d !== countcols-1){ prequery += ', '; }
        }
        prequery +=') values <br>';
        document.getElementById("result").innerHTML=prequery + query + ';';
    }
    </script>
</head>
<body>
    <table width="100%">
        <tr><td>Excel to Mysql Insert</td></tr>
        <tr><td><input style="width:99%" rows="5" id="table" value="TABLE NAME" /></td></tr>
        <tr><td><textarea style="width:99%" rows="5" id="columns">PASTE EXCEL COLUMN NAMES</textarea></td></tr>
        <tr><td><textarea style="width:99%" rows="5" id="excel">PASTE EXCEL DATA</textarea></td></tr>
        <tr><td><button onclick="run();" style="padding:10px">RUN</button></td></tr>
        <tr><td><div id="result" style="border:1px solid red;padding:5px">Test</div></td></tr>
    </table>
</body>
</html>
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width">
	<title>Excel to Mysql Insert</title>
	<script>
	function run()
	{
	var query='';
	var lines = document.getElementById("excel").value.split('\n');
	var countl=lines.length;
	for(var i = 0; i < countl; i++)
	{
	var columns=lines[i].split('\t');
	var countc=columns.length;
	var subquery='';
	for(var c = 0; c < countc; c++)
	{
	subquery += "`" + columns[c] + "`";
	if (c !== countc-1){ subquery += ','; }
	}
	query += '(' + subquery + ')';
	if (i !== countl-1){ query += ','; }
	query += "<br>";
	}
	var cols = document.getElementById("columns").value.split('\t');
	countcols=cols.length;
	var prequery='INSERT INTO '+document.getElementById("table").value+' (';
	for(var d = 0; d < countcols; d++)
	{
	prequery += "`" + cols[d] + "`";
	if (d !== countcols-1){ prequery += ', '; }
	}
	prequery +=') values <br>';
	document.getElementById("result").innerHTML=prequery + query + ';';
	}
	</script>
	</head>
	<body>
	<table width="100%">
	<tr><td>Excel to Mysql Insert</td></tr>
	<tr><td><input style="width:99%" rows="5" id="table" value="TABLE NAME" /></td></tr>
	<tr><td><textarea style="width:99%" rows="5" id="columns">PASTE EXCEL COLUMN NAMES</textarea></td></tr>
	<tr><td><textarea style="width:99%" rows="5" id="excel">PASTE EXCEL DATA</textarea></td></tr>
	<tr><td><button onclick="run();" style="padding:10px">RUN</button></td></tr>
	<tr><td><div id="result" style="border:1px solid red;padding:5px">Test</div></td></tr>
	</table>
	</body>
	</html>