php - Multidimensional Key/Value Array into MySQL Table -

php - Multidimensional Key/Value Array into MySQL Table -

alright, i've never done before. not professional, know how mysql works. know way around php improve still beginner stages. have method in mind go it.

however, before waste 2+ hours learning did wrong, thought i'd inquire here first how guys it. im starting (relatively) little array , working big stuff when understood well.

array: http://pastebin.com/g8ryxtp5

so.. mysql? right initial thought create table , looking right now:

<?php include "login.php"; include "createdb.php"; $con = mysqli_connect($mysql_host, $mysql_user, $mysql_pass, $mysql_table) or die("some error occurred during connection " . mysqli_error($con)); /*$sql = "create table career ( id int not null auto_increment primary key, username varchar(32), password varchar(32), battletag varchar(32), part varchar(2) ) ";*/ $sql = "create table career ( id int not null auto_increment primary key, battletag varchar(32), lastheroplayed varchar(32), lastupdated varchar(32), monsters varchar(32), elites varchar(32), hardcoremonsters varchar(32), barbarian varchar(32), crusader varchar(32), demon-hunter varchar(32), monk varchar(32), witch-doctor varchar(32), wizard varchar(32), paragonlevel varchar(32), paragonlevelhardcore varchar(32), h1name varchar(32), h1id varchar(32), h1level varchar(32), h1hardcore varchar(32), h1gender varchar(32), h1dead varchar(32), h1class varchar(32), h1last-updated varchar(32), h2name varchar(32), h2id varchar(32), h2level varchar(32), h2hardcore varchar(32), h2gender varchar(32), h2dead varchar(32), h2class varchar(32), h2last-updated varchar(32), h3name varchar(32), h3id varchar(32), h3level varchar(32), h3hardcore varchar(32), h3gender varchar(32), h3dead varchar(32), h3class varchar(32), h3last-updated varchar(32), h4name varchar(32), h4id varchar(32), h4level varchar(32), h4hardcore varchar(32), h4gender varchar(32), h4dead varchar(32), h4class varchar(32), h4last-updated varchar(32), h5name varchar(32), h5id varchar(32), h5level varchar(32), h5hardcore varchar(32), h5gender varchar(32), h5dead varchar(32), h5class varchar(32), h5last-updated varchar(32), h6name varchar(32), h6id varchar(32), h6level varchar(32), h6hardcore varchar(32), h6gender varchar(32), h6dead varchar(32), h6class varchar(32), h6last-updated varchar(32), h7name varchar(32), h7id varchar(32), h7level varchar(32), h7hardcore varchar(32), h7gender varchar(32), h7dead varchar(32), h7class varchar(32), h7last-updated varchar(32), h8name varchar(32), h8id varchar(32), h8level varchar(32), h8hardcore varchar(32), h8gender varchar(32), h8dead varchar(32), h8class varchar(32), h8last-updated varchar(32), h9name varchar(32), h9id varchar(32), h9level varchar(32), h9hardcore varchar(32), h9gender varchar(32), h9dead varchar(32), h9class varchar(32), h9last-updated varchar(32), h10name varchar(32), h10id varchar(32), h10level varchar(32), h10hardcore varchar(32), h10gender varchar(32), h10dead varchar(32), h10class varchar(32), h10last-updated varchar(32), h11name varchar(32), h11id varchar(32), h11level varchar(32), h11hardcore varchar(32), h11gender varchar(32), h11dead varchar(32), h11class varchar(32), h11last-updated varchar(32), h12name varchar(32), h12id varchar(32), h12level varchar(32), h12hardcore varchar(32), h12gender varchar(32), h12dead varchar(32), h12class varchar(32), h12last-updated varchar(32), "; if (mysqli_query($con,$sql)) { echo "table 'career' created successfully!<br>"; } else { echo "error creating table: " . mysqli_error($con)."<br>"; } mysqli_query($con, $sql);

after table created going php/mysql magic (basically learning go) array->parse->push mysql ?

thanks insight. should not doing/how should going this?

edit: okay think maybe can create 1 table still, , include defining career var "battletag" each hero separately (along vital info need each hero). think work improve had.

$sql = "create table heros ( id int not null auto_increment primary key, battletag varchar(64) , name varchar(32), id int, level int, hardcore bool, gender bool, dead bool, class varchar(32), last-updated timestamp "; $sql2 = "create table career ( id int not null auto_increment primary key, battletag varchar(64), lastheroplayed varchar(32), lastupdated timestamp, monsters int, elites int, hardcoremonsters int, barbarian double(4,3), crusader double(4,3), demon-hunter double(4,3), monk double(4,3), witch-doctor double(4,3), wizard double(4,3), paragonlevel int, paragonlevelhardcore int ";

from 1 12...

h12name varchar(32), h12id varchar(32), h12level varchar(32), h12hardcore varchar(32), h12gender varchar(32), h12dead varchar(32), h12class varchar(32), h12last-updated varchar(32),

below can 1 column "game_name" still can add....

$sql = "create table career ( id int not null auto_increment primary key, battletag varchar(32), lastheroplayed varchar(32), lastupdated varchar(32), monsters varchar(32), elites varchar(32), hardcoremonsters varchar(32), barbarian varchar(32), crusader varchar(32), demon-hunter varchar(32), monk varchar(32), witch-doctor varchar(32), wizard varchar(32), paragonlevel varchar(32), paragonlevelhardcore varchar(32),

i suggest create table this...or can create 2 bring together table 1 game , 1 hnn...

name_game varchar(150) hname varchar(32), hid varchar(32), hlevel varchar(32), hhardcore varchar(32), hgender varchar(32), hdead varchar(32), hclass varchar(32), hlast-updated varchar(32),

redundant set in 1 table..............

php mysql arrays multidimensional-array