Error: Warning: Undefined array key 2 in …

Hi,

I can’t get my head over these errors …

**ATTEMPT 1:**

[code]

$conn = mysqli_connect(“localhost”,”root”,””,”gulf”); //mysqli_connect(“server”,”user”,”password”,”db”);

$input_1 = ‘where’; //keyword.

$sql = “SELECT id,domain from links WHERE keyword = ?”;

$stmt = mysqli_stmt_init($conn);

mysqli_stmt_prepare($stmt,$sql);

mysqli_stmt_bind_param($stmt,”s”,$input_1);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

$row=mysqli_fetch_array($result,MYSQLI_NUM);
$id = $row[‘0’]; //id
$domain = $row[‘2’]; //domain

echo “$id<br>”;
echo “$domain<br>”;

mysqli_stmt_close($stmt);
mysqli_close($conn);
[/code]

**Warning: Undefined array key 2 in C:xampphtdocsWorkgulfTest.php on line 20**

**ATTEMPT 2:**

[code]

$conn = mysqli_connect(“localhost”,”root”,””,”gulf”); //mysqli_connect(“server”,”user”,”password”,”db”);

$input_1 = ‘where’; //keyword.

$sql = “SELECT id,domain from links WHERE keyword = ?”;

$stmt = mysqli_stmt_init($conn);

mysqli_stmt_prepare($stmt,$sql);

mysqli_stmt_bind_param($stmt,”s”,$input_1);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

while($row=mysqli_fetch_array($result,MYSQLI_NUM))
{
$id = $row[‘0’]; //id
$domain = $row[‘2’]; //domain
}

echo “$id<br>”;
echo “$domain<br>”;

mysqli_stmt_close($stmt);
mysqli_close($conn);

[/code]

Warning: Undefined array key 2 in C:xampphtdocsWorkgulfTest.php on line 20

Also in #PHP _↴