Weblabor

<?php
$tabla = 'teszt';
$link = mysql_connect('localhost', 'user', 'pass')
	or die('Failed to connect');
mysql_query('USE adatbazisod')
	or die('Failed to set database');
mysql_query('SET NAMES utf8')
	or die('Failed to set UTF-8');

/**
 * Tablaszerkezet kiolvasasa
 */
$r = mysql_query('SHOW CREATE TABLE `' .
	mysql_real_escape_string($tabla, $link) . 
	'`', $link)
	or die('Failed to fetch table structure');
$a = mysql_fetch_assoc($r);
echo($a['Create Table'] . ";\r\n");

/**
 * Adatok kiolvasasa
 */
$r = mysql_query('SELECT * FROM `' .
	mysql_real_escape_string($tabla, $link) .
	'`') or die('Failed to fetch data');
while ($a = mysql_fetch_assoc($r)) {
	$data = array();
	foreach ($a as $value) {
		$data[] = "'" .
			mysql_real_escape_string($value, $link)
			. "'";
	}
	echo('INSERT INTO `' .
		mysql_real_escape_string($tabla, $link) .
		'` VALUES (' . implode(', ', $data) . ');' .
		"\r\n");
}