Rigips predajcovia Table to SQL

by wewo

HTML

<table id="where-buy-table">
			<tbody>
				<tr>
					<td>
						<p><strong>Alpox</strong><br>
						Dopravná 2735<br>
						Topolčany<br>
						Tel.: 038/5227950<br>
						<a href="http://www.alpox.sk/" target="_blank">www.alpox.sk</a></p>
					</td>
					<td>
						<strong>Kartel</strong><br>
						Štúrova 155<br>
						Nitra<br>
						Tel.: 037/7417071<br>
						<a href="http://www.kartel.sk/" target="_blank">www.kartel.sk</a>
					</td>
					<td>
						<p><strong>Oraving</strong><br>
						M. R. Štefánika 1833<br>
						Dolný Kubín<br>
						Tel.: 043/5820991<br>
						<a href="http://www.oraving.sk" target="_blank">www.oraving.sk</a></p>
					</td>
					<td>
						<strong>Stavivo IBV</strong><br>
						Zvolenská cesta 1<br>
						Banská Bystrica<br>
						Tel.: 048/4103432<br>
						<a href="http://www.ibv.sk/" target="_blank">www.ibv.sk</a>
					</td>
					<td>
						<p><strong>BEK Baustoffe BA</strong><br>
						Odborárska 52<br>
						Bratislava<br>
						Tel.: 02/44458291<br>
						<a href="http://www.bek.sk" target="_blank">www.bek.sk</a></p>
					</td>
				</tr>
				<tr>
					<td>
						<p><strong>BEK Baustoffe PO</strong><br>
						Strojnícka 10<br>
						Prešov<br>
						Tel.: 051/7731368<br>
						<a href="http://www.bek.sk" target="_blank">www.bek.sk</a></p>
					</td>
					<td>
						<p><strong>BEK Baustoffe BB</strong><br>
						Sládkovičova 92<br>
						Banská Bystrica<br>
						Tel.: 048/4161236<br>
						<a href="http://www.bek.sk" target="_blank">www.bek.sk</a></p>
					</td>
					<td>
						<p><strong>BEK Baustoffe ZA</strong><br>
						P.O Hviezdoslava 68<br>
						Žilina<br>
						Tel.: 041/7645920<br>
						<a href="http://www.bek.sk" target="_blank">www.bek.sk</a></p>
					</td>
					<td>
						<p><strong>Lemarck</strong><br>
						Viničná 1<br>
						Nové Zámky<br>
						Tel.: 035/6406655<br>
						<a href="http://www.lemarck.sk" target="_blank">www.lemarck.sk</a></p>
					</td>
					<td>
						<p><strong>Dom -...

CSS

#where-buy-table {
    display:none;
}

JavaScript

var tableDataP = $('table td p');

$.each(tableDataP, function(i, p) {
    var companyName = $(p).find('strong').html().replace("<br>", " ");
    
    $(p).find('strong').html( companyName );
    
    var lines = $(p).html().split("<br>");
    
    $.each( lines, function(j,line) {
        lines[j] = line.trim();
    });
    
    companyName = $(lines[0]).text();
    var companyAddr = lines[1];
    var companyCity = lines[2];
    var companyPhone = lines[3].substr(6);
    /*
    console.log( companyName );
    console.log( companyAddr );
    console.log( companyCity );
    console.log( companyPhone );
    console.log('-------------');
    */
    
    var sql_tempalte = "INSERT INTO `ws_rigips_sk`.`users` (`id`, `domain`, `name`, `surname`, `company`, `email`, `passwd`, `addr`, `zip`, `city`, `region`, `phone`, `idcard`, `level`, `rank`, `newsletter`, `access_level`, `created`, `modified`, `last_logged`, `active`) VALUES (NULL, 'www.rigips.sk', '', '', '"+companyName+"', '', '', '"+companyAddr+"', '', '"+companyCity+"', '', '"+companyPhone+"', '', '', '', '1', '18', '', '', '', '1');";
    
    // console.log( sql_tempalte );
    
    $("#sql-result").append( sql_tempalte );
    $("#sql-result").append( "<br><br>" );
});