<?php
/**
 * Created by PhpStorm.
 * User: dzirt
 * Date: 12/17/2018
 * Time: 7:36 PM
 */

$db=pg_connect("host=localhost dbname=Her user=postgres password=5955");


$arrName=array(
  'Junk' => array(3,'dps'),
    'Torb' =>array(3,'dps'),
    'Sombra' =>array(4,'dps'),
    'Symmetra'=>array(4,'dps'),
    'Orisa'=>array(3,'tank'),
    'Ana'=>array(4,'healer'),
    'Mercy'=>array(3,'healer'),
    'Reinhardt'=>array(3,'tank'),
    'Genji'=>array(4,'dps'),
    'Solder'=>array(3,'dps'),
    'Hanzo'=>array(4,'dps'),
    'Hamster'=>array(5,'tank'),
    'Moira'=>array(3,'healer'),
    'Bastion'=>array(2,'dps'),
    'Mei'=>array(4,'dps'),
    'Widow'=>array(5,'dps'),
    'Ashe'=>array(4,'dps')
);

/*foreach ($arrName as $key=>$value) {

   $i=$value[0];
   $t=$value[1];

  $query = "insert into charecters( difficult, role) VALUES ($i,$t)";
  pg_query($db, $query);

}
//forArr($arrName);*/


    foreach (array_keys($arrName) as $key){
        $query = "insert into charecters( name) VALUES ($key)";
        pg_query($db, $query);



//for($i=0;$i<count($arrName);$i++)
}