# Print API on database

**URL:** <https://discuss.dev.twitch.com/t/print-api-on-database/26380>\
**Category:** API\
**Created:** [June 15, 2020, 2:51am UTC](https://discuss.dev.twitch.com/t/print-api-on-database/26380 "2020-06-15T02:51:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Emanuele\_Capizzi](https://d3ovvz0v2ajtpu.cloudfront.net/user_avatar/discuss.dev.twitch.com/emanuele_capizzi/32/6915_2.png) [@Emanuele\_Capizzi](https://discuss.dev.twitch.com/u/Emanuele_Capizzi)\
**Post date:** [June 15, 2020, 2:51am UTC](https://discuss.dev.twitch.com/t/print-api-on-database/26380/1 "2020-06-15T02:51:16Z")

</div>

I have a prolem:

```
	foreach(apichan() as $mydata){
		$name = $mydata['user_name'];
		$views = $mydata['viewer_count'];
		$game = $mydata['game_id'];

	foreach(games() as $mygame){
		$game_id = $mygame['id'];
		$games = $mygame['name'];
		$thumbn = $mygame['box_art_url'];
	
	if(apichan() == FALSE){
	$noinlive = "UPDATE user_data SET inlive = 0 WHERE inlive = 1";
	$resultnolive = mysqli_query($connString, $noinlive)or die(mysqli_error());
	}else{}

	$controllo = "SELECT users_name FROM user_data WHERE users_name = '$name'";
	$resultnocon = mysqli_query($connString, $controllo)or die(mysqli_error());

	$controllogame = "SELECT game_id FROM game_name WHERE game_id = '$game_id'";
	$resultnogame = mysqli_query($connString, $controllogame)or die(mysqli_error());
	
	$update = "UPDATE user_data SET users_name = '$name', viewer_count = '$views', game_id = '$game', inlive = 1";
	$resultupdate = mysqli_query($connString, $update)or die(mysqli_error());

	$insert = "INSERT INTO user_data ( users_name, viewer_count, game_id, inlive ) SELECT * FROM (SELECT '$name', '$views', '$game', '1' ) AS tmp WHERE NOT EXISTS (SELECT users_name FROM user_data WHERE users_name = '$name')";
	$resultinsert = mysqli_query($connString, $insert)or die(mysqli_error());

	$insert2 = "INSERT INTO game_name ( game_id, nome, thumbn ) SELECT * FROM (SELECT '$game_id', '$games', '$thumbn' ) AS tmp WHERE NOT EXISTS (SELECT game_id FROM game_name WHERE game_id = '$game_id')";
	$resultinsert2 = mysqli_query($connString, $insert2)or die(mysqli_error());
	
		$delete = "DELETE FROM user_data WHERE inlive = 0";
		$resultdelete = mysqli_query($connString, $delete)or die(mysqli_error()); 
}}}

```

In this case my cron set inlive 0 correctly if array give no results, update correctly users on database and delete it if post-update inlive is 0, but insert soes’nt work, it insert only one.  
What should i do?

---

<div class="post-metadata">

**Author:** ![BarryCarlyon](https://d3ovvz0v2ajtpu.cloudfront.net/user_avatar/discuss.dev.twitch.com/barrycarlyon/32/253_2.png) [@BarryCarlyon](https://discuss.dev.twitch.com/u/BarryCarlyon)\
**Post date:** [June 15, 2020, 9:00am UTC](https://discuss.dev.twitch.com/t/print-api-on-database/26380/2 "2020-06-15T09:00:06Z")

</div>

You have a nested call to apiChan()

Shouldn’t `if(apichan() == FALSE){` be using `$mydata`

This just looks like a convoluted way to do this from a PHP programming side.

> $noinlive = “UPDATE user\_data SET inlive = 0 WHERE inlive = 1”;

this sets everyone to not live if live rather than just the user from `$myData`

---

<div class="post-metadata">

**Author:** ![system](https://d2opxh93rbxzdn.cloudfront.net/original/2X/0/05909729875cce3b53e59d5561c4d23bb14948fc.png) [@system](https://discuss.dev.twitch.com/u/system)\
**Post date:** [July 15, 2020, 9:00am UTC](https://discuss.dev.twitch.com/t/print-api-on-database/26380/3 "2020-07-15T09:00:11Z")

</div>

Closed on July 15, 2020, 9:00am UTC

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
