Weblabor

<? if (!isset($_POST['fog']))
{
?>
<h1>Mozi jegy foglalás</h1>
<form action=mozi.php method=post>
Sor: <input type=text name=sor>
Oszlop: <input type=text name=oszlop>
<input type=submit value=foglal name=fog>
<?
}
else
{
$sor=$_POST['sor'];
$oszlop=$_POST['oszlop'];
$alap="o";
$foglalt="<font color=red>o</font>";
$s=10;
$o=20;

echo "<table border=1>";
for($i=1;$i<=$s;$i++)
	{echo "<tr>";
		for($j=1;$j<=$o;$j++)
			{echo "<td width=25>";
				echo $alap;
				echo "</td>";
			}
		echo"</tr>";
	}

echo "</table>";
}
?>

<?php

$width =  ("
<script LANGUAGE=\"javascript\">
width = screen.width;
var numValue = parseInt(width);
document.write(numValue)
</script>
");


echo ("WIDTH: $width");

?>

<?php
	$db = new MySQLi(offline üzlet adatbázisa);
	$db2 = new MySQLi(online üzlet adatbázisa);

	if ($db->connect_errno) {
    	exit();
	}
	
	$lekerdez = "select cikkszam,cikkszam_nev,db,kisker_ar,nyilv_ar,kategoria,db from cikkszam order by 1";
	$lekerdez2 = "select model,quantity from bio_product";

	$talalat = $db->query($lekerdez);
	$talalat2 = $db2->query($lekerdez2); 
	
	$n = $talalat->num_rows;
	$s = $talalat2->num_rows;

	for ($i=0; $i<$s; $i++) {

		$sor2 = $talalat2->fetch_assoc();
		$aktdb=0;
		for ($j=0; $j<$n; $j++) {
			$sor = $talalat->fetch_assoc();
			if (stripslashes($sor['cikkszam']) == stripslashes($sor2['model']) && stripslashes($sor['db']) != stripslashes($sor2['quantity'])) {
				$aktdb = $sor['db'];
				mysqli_query($db2,"UPDATE bio_product SET quantity=".$aktdb." WHERE model='".stripslashes($sor2['model'])."'");
				break;
			}
		}
		$talalat = $db->query($lekerdez);
	}
	$db->close();
?>