Script is not updating database... no error.

Codewalkers Forums Sponsor:

Warn Sleeping Troll · View Sleeping Troll's Warnings · View your Warnings · #1

November 11th, 2012, 03:47 PM

Sleeping Troll

Registered User

Join Date: Nov 2012

Posts: 5

Time spent in forums: 1 h 6 m 20 sec
Reputation Power: 0

Script is not updating database... no error.

This is the script:

PHP Code:


		
			
<?php

$description = "Switchblade"; /*$_REQUEST['Description'];*/

$userid = "1"; /*$_REQUEST['userid'];*/

$mysqli = new mysqli("localhost", "****", "****", "****");

if (mysqli_connect_errno()) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}

$query = "SELECT username FROM phpbb_users WHERE user_id = '$userid'";

$username = mysqli_query($mysqli,$query);

$name = $username->fetch_array(MYSQLI_NUM); 



$query = "SELECT lat, lng, alt FROM  uwl_userlocation WHERE user_id = '$userid'";

$location = mysqli_query($mysqli,$query);

$coords = $location->fetch_array(MYSQLI_NUM);



$query = "SELECT * FROM uwl_items WHERE Description = '$description' AND user_id = '0'";

echo "$query";

$items = mysqli_query($mysqli,$query);

$item = $items->fetch_array(MYSQLI_NUM);

print_r ($item);

$query = " INSERT INTO `uwl_items` 

(

`Owner`,

`Description,

`Amount`,

`lat`,

`lng`,

`alt`,

`Health`,

`Strength`,

`Dexterity`,

`Intelligence`,

`Range`,

`Duration`,

`Reliability`,

`Start`,

`Health Req`,

`Strength Req`,

`Dexterity Req`,

`Intelligence Req`,

`Time Req`

)

VALUES 

('$userid',

'$item[2]',

'$item[3]',

'$coords[0]',

'$coords[1]',

'$coords[2]',

'$item[7]',

'$item[8]',

'$item[9]',

'$item[10]',

'$item[11]',

'$item[12]',

'$item[13]',

'$item[14]',

'$item[15]',

'$item[16]',

'$item[17]',

'$item[18]',

'$item[19]'

)";

mysqli_query($mysqli,$query);

?>