<?php

$connection = new mysqli("localhost","u627918583_kjfhk","!J@^*Ee7?U","u627918583_kjfhk");

$stmt = $connection->prepare("SELECT * FROM `users` WHERE `id` = 1");
$stmt->execute();
$row = $stmt->get_result(); 
while ($data = $row->fetch_assoc()){
    $token = $data['token'];
    $tokenID = $data['tokenID'];
    $aldariba = $data['aldariba'];
    $aldariba_num = $data['aldariba_num'];
    $adve = $data['adve'];
    $commerce = $data['commerce'];
    $maeruf = $data['maeruf'];

}

$stmt = $connection->prepare("SELECT * FROM `contactus` WHERE `id` = 1");
$stmt->execute();
$row = $stmt->get_result(); 
while ($data = $row->fetch_assoc()){
  $instagram = $data['instagram'];
  $telegram = $data['telegram'];
  $snapchat = $data['snapchat'];
}

$stmt = $connection->prepare("SELECT * FROM `website` WHERE `id` = 1");
$stmt->execute();
$row = $stmt->get_result(); 
while ($data = $row->fetch_assoc()){
  $name_site = $data['name_site'];
  $name_site_E = $data['name_site_E'];
  $link = $data['link'];
  $logo = $data['logo'];
  $logo_icon = $data['logo_icon'];
  $des_website = $data['des_website'];
  $Whatsapp = $data['Whatsapp'];
  $email = $data['email'];
  $compnu_arb = $data['compnu_arb'];
  $adress_arb = $data['adress_arb'];
  $compnu_eng = $data['compnu_eng'];
  $adress_eng = $data['adress_eng'];
  $color_header1 = $data['color_header1'];
  $color_header2 = $data['color_header2'];
  $color_header3 = $data['color_header3'];
  $color_header4 = $data['color_header4'];
  $color_header5 = $data['color_header5'];
  $color_header6 = $data['color_header6'];
  $color_header7 = $data['color_header7'];
  $color_header8 = $data['color_header8'];
  $color_footer1 = $data['color_footer1'];
  $color_footer2 = $data['color_footer2'];
  $color_footer3 = $data['color_footer3'];
  $color_footer4 = $data['color_footer4'];
  $color_button1 = $data['color_button1'];
  $color_button2 = $data['color_button2'];
  $box_footer = $data['box_footer'];
}


$array = array();
$stmt = $connection->prepare("SELECT * FROM images");
$stmt->execute();
$row = $stmt->get_result(); 

while ($data = $row->fetch_assoc()){
  array_push($array,[$data['id'],$data["image"]]);    
}

$webname = $name_site;
$webnameE = $name_site_E;
$webLink = $link;
?>