Elton

$query = "UPDATE `$dbname` SET  name='%s', url='%s', short='%s', game='%s' WHERE name;";

https://prnt.sc/sqsm7i 

it seems like it works partially but it imports incorrectly

https://prnt.sc/sqsjr8

$query = "UPDATE `$dbname` SET  name=%s, url=%s, short=%s, game=%s";

<?php
error_reporting(E_ALL); 
ini_set('display_errors', true);
$dbname='in_dein_fall_test';
$json_datei='https://api.truckyapp.com/v2/traffic/servers';
$mysqli=mysqli_connect('localhost', 'root', '', 'db');
if (mysqli_connect_errno())  die ("Connect failed: " . mysqli_connect_error());	 
mysqli_set_charset($mysqli, "utf8");  
//	 /* von hier auskommentieren nach ersten aufruf

//   bis hier auskkommentieren oder löschen*/
$query = "UPDATE `$dbname` SET  (`name`, `url`, `short`, `game`)
VALUES ('%s','%s','%s', '%s')";

$json = json_decode(file_get_contents($json_datei),true);
$queries = array();
foreach ($json['response'] as $data){
	$name=mysqli_real_escape_string($mysqli, $data['name']);
	$url=mysqli_real_escape_string($mysqli, $data['url']);
	$short=mysqli_real_escape_string($mysqli, $data['short']);
	$game=mysqli_real_escape_string($mysqli, $data['game']);
	$queries[] = sprintf($query, $name, $url, $short, $game);
}
$menge=count($queries);
if (mysqli_multi_query($mysqli, implode(";", $queries))){
	echo  "$menge Datensätze erfolgreich importiert<br>";
}else{
	echo "errors<br>";
} 
echo "";
$mysqli->close();
?>

https://prnt.sc/sqjsnc

That's why I'm writing here

Yes the problem is I tried it with update but that does not work

https://prnt.sc/sq96pa . https://prnt.sc/sq96ug whats wrong

I ve already read through but I do not come across the problem 

Could they put me in the code I just do not know exactly how I do it 

so? $query = "INSERT INTO `$dbname` VALUES (`name`, `url`, `short`, `game`)  ON DUPLICATE KEY UPDATE 
  `name` = '%s', 
  `url` = '%s',
  `short` = '%s',
  `game` = '%s'";  

<?php
error_reporting(E_ALL); 
ini_set('display_errors', true);
$dbname='in_dein_fall_test';
$json_datei='https://api.truckyapp.com/v2/traffic/servers';
$mysqli=mysqli_connect('localhost', 'root', '', 'db');
if (mysqli_connect_errno())  die ("Connect failed: " . mysqli_connect_error());	 
mysqli_set_charset($mysqli, "utf8");  
//	 /* von hier auskommentieren nach ersten aufruf

//   bis hier auskkommentieren oder löschen*/
$query = "INSERT INTO `$dbname` (`name`, `url`, `short`, `game`)  ON DUPLICATE KEY UPDATE 
  `name` = '%s', 
  `url` = '%s',
  `short` = '%s',
  `game` = '%s'";  
$json = json_decode(file_get_contents($json_datei),true);
$queries = array();
foreach ($json['response'] as $data){
	$name=mysqli_real_escape_string($mysqli, $data['name']);
	$url=mysqli_real_escape_string($mysqli, $data['url']);
	$short=mysqli_real_escape_string($mysqli, $data['short']);
	$game=mysqli_real_escape_string($mysqli, $data['game']);
	$queries[] = sprintf($query, $name, $url, $short, $game);
}
$menge=count($queries);
if (mysqli_multi_query($mysqli, implode(";", $queries))){
	echo  "$menge Datensätze erfolgreich importiert<br>";
}else{
	echo "Irgendwelche errors<br>";
} 
echo "";
$mysqli->close();
if ($mysqli -> connect_errno) {
  echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
  exit();
}

// Perform a query, check for error
if (!$mysqli -> query("INSERT INTO `in_dein_fall_test` (name) VALUES ('Glenn')")) {
  echo("Error description: " . $mysqli -> error);
}
?>

Thats the code

https://prnt.sc/spmxte

if I do it so then come still error https://prnt.sc/splbgj

$query = "INSERT INTO `$dbname` (`name`, `url`, `short`, `game`)  ON DUPLICATE KEY UPDATE 
  `name` = '%s', 
  `url` = '%s',
  `short` = '%s',
  `game` = '%s'";  
$json = json_decode(file_get_contents($json_datei),true);
$queries = array();
foreach ($json['response'] as $data){
	$name=mysqli_real_escape_string($mysqli, $data['name']);
	$url=mysqli_real_escape_string($mysqli, $data['url']);
	$short=mysqli_real_escape_string($mysqli, $data['short']);
	$game=mysqli_real_escape_string($mysqli, $data['game']);
	$queries[] = sprintf($query, $name, $url, $short, $game);
}
$menge=count($queries);
if (mysqli_multi_query($mysqli, implode(";", $queries))){
	echo  "$menge Datensätze erfolgreich importiert<br>";
}else{
	echo "Irgendwelche errors<br>";
} 
echo "";
$mysqli->close();
?>

It doesn't really matter, does it? but there are still mistakes https://prnt.sc/spkco6

$query = "INSERT INTO `$dbname` (`name`, `url`, `short`, `game`) VALUES ('%s','%s','%s', '%s') ON DUPLICATE KEY UPDATE 
  `name` = '%s', 
  `url` = '%s',
  `short` = '%s',
  `game` = '%s'";  

I have tried it with this code but it does not work

<?php
error_reporting(E_ALL); 
ini_set('display_errors', true);
$dbname='in_dein_fall_test';
$json_datei='https://api.truckyapp.com/v2/traffic/servers';
$mysqli=mysqli_connect('localhost', 'root', '', 'test');
if (mysqli_connect_errno())  die ("Connect failed: " . mysqli_connect_error());	 
mysqli_set_charset($mysqli, "utf8");  
//	 /* von hier auskommentieren nach ersten aufruf


//   bis hier auskkommentieren oder löschen*/
$query = "INSERT INTO `$dbname` (`name`, `url`, `short`, `game`)
		  VALUES ('%s','%s','%s', '%s')";
$json = json_decode(file_get_contents($json_datei),true);
$queries = array();
foreach ($json['response'] as $data){
	$name=mysqli_real_escape_string($mysqli, $data['name']);
	$url=mysqli_real_escape_string($mysqli, $data['url']);
	$short=mysqli_real_escape_string($mysqli, $data['short']);
	$game=mysqli_real_escape_string($mysqli, $data['game']);
	$queries[] = sprintf($query, $name, $url, $short, $game);
}
$menge=count($queries);
if (mysqli_multi_query($mysqli, implode(";", $queries))){
	echo  "$menge Datensätze erfolgreich importiert<br>";
}else{
	echo "Irgendwelche errors<br>";
} 
echo "";
$mysqli->close();
?>

Who knows what is wrong here, that the roofs are always re-entered instead of updated