Witam muszę napisać skrypt który z pliku wczyta dane do bazy, ale nie dziala mi cos ten skrypt. Czy ktos mogłby mi pomóc i dać jakieś rady?
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<?php
$link = mysqli_connect("localhost", "businesssolutionscentre17", "1q2w3e4r5t", "businesssolutionscentre17");
mysql_select_db (jos_hg_cities);
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$p = file('wydzialy.txt');
$pc = count($p);
for ($i = 0; $i < $pc; $i++) {
$l = explode(':', trim($p[$i]));
$parent_id = mysql_escape_string($l[0]);
$name = mysql_escape_string($l[1]);
$alias = mysql_escape_string($l[2]);
$country = mysql_escape_string($l[3]);
$states = mysql_escape_string($l[4]);
$tgdestination = mysql_escape_string($l[5]);
$destination = mysql_escape_string($l[6]);
$lat = mysql_escape_string($l[7]);
$lon = mysql_escape_string($l[8]);
$zoom = mysql_escape_string($l[9]);
$maptype = mysql_escape_string($l[10]);
$mapheight = mysql_escape_string($l[11]);
$image = mysql_escape_string($l[12]);
$imagewidth = mysql_escape_string($l[13]);
$imageheight = mysql_escape_string($l[14]);
$titleimage = mysql_escape_string($l[15]);
$titleimagewidth = mysql_escape_string($l[16]);
$titleimageheight = mysql_escape_string($l[17]);
$description = mysql_escape_string($l[18]);
$meta_title = mysql_escape_string($l[19]);
$meta_keywords = mysql_escape_string($l[20]);
$meta_description = mysql_escape_string($l[21]);
$published = mysql_escape_string($l[22]);
$checked_out = mysql_escape_string($l[23]);
$checked_out_time = mysql_escape_string($l[24]);
$access = mysql_escape_string($l[25]);
$ordering = mysql_escape_string($l[26]);
$q = "
INSERT INTO
jos_hg_cities (parent_id,name,alias,country,states,tgdestination,destination,lat,lon,zoom,mapt
ype,mapheight,image,imagewidth,titleimageheight,description,meta_title,meta_keywo
rds,meta_description,published,checked_out,checked_out_time,access,ordering')
VALUES
('$parent_id','$name','$alias','$country','$states','$tgdestination','$destination','$lat','$lon','$zoom','$maptype','$mapheight','$image','$imagewidth','$titleimageheight','$description','$meta_title','$meta_keywords','$meta_description','$published','$checked_out','$checked_out_time','$access','$ordering')
";
$res = $bd->sendQuery($q);
}
?>
<body>
</body>
</html>