[Fhox]

eu tenho os seguintes valores pra inserir no bd

E eu queria criar uma script em php q insere tudos esses valores no bd,

Oq eu sei
conectar ao bd
selecionar o db

mas como eu faço pra inserir esses cod, tipow, pra naum ficar muito grande se alguem souber, me mostre como eu faço isso, naum precisa usar esses valores todos

CREATE TABLE `detonado_gba` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `detonado_n64` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `detonado_play` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_arcade` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_gamecube` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_gba` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_n64` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_neogeo` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_ngage` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_pc` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_play` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_play2` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);
CREATE TABLE `dica_xbox` (
`nome` TEXT NOT NULL ,
`url` TEXT NOT NULL
);

INSERT INTO detonado_gba VALUES("Pokémon Ruby","pok_ruby.html");
INSERT INTO detonado_gba VALUES("Yu-Gi-Oh! Eternal Duelist Soul","ygo_eternal_duelist_soul.html");
INSERT INTO detonado_n64 VALUES ("Banjo Kazooie","banjo_kazooie.html");
INSERT INTO detonado_n64 VALUES ("Zelda : Majora's Mask","zelda_mask.html");
INSERT INTO detonado_play VALUES ("Alundra","alundra.html");
INSERT INTO detonado_play VALUES ("Alundra 2","alundra2.html");

INSERT INTO dica_arcade VALUES("Snk vs Capcom chaos","snk_vs_capcom_chaos.html");

INSERT INTO dica_gamecube VALUES("Black and Bruised","black_and_bruised.html");

INSERT INTO dica_gba VALUES("Castlevania : Aria of Sorrow","castlevania_aria_of_sorrow.html");
INSERT INTO dica_gba VALUES("Donkey Kong Country","donkey_kong_country.html");
INSERT INTO dica_gba VALUES("Yu Gi Oh ! Eternal duelist soul","yugioh_eternal_duelist_soul.html");

INSERT INTO dica_n64 VALUES("Killer Instinct Gold","killer_instinct_gold.html");

INSERT INTO dica_neogeo VALUES("Art of Fighting 2","art_of_fighting_2.html");
INSERT INTO dica_neogeo VALUES("Baseball Stars Professional","baseball_stars_professional.html");
INSERT INTO dica_neogeo VALUES("Blazing Star","blazing_star.html");
INSERT INTO dica_neogeo VALUES("Double Dragon","double_dragon.html");
INSERT INTO dica_neogeo VALUES("Fatal Fury","fatal_fury.html");
INSERT INTO dica_neogeo VALUES("Fatal Fury 3","fatal_fury_3.html");
INSERT INTO dica_neogeo VALUES("Fatal Fury Special","fatal_fury_special.html");
INSERT INTO dica_neogeo VALUES("Galaxy Fight","galaxy_fight.html");
INSERT INTO dica_neogeo VALUES("Garou : Mark of the Wolves","garou__mark_of_the_wolves.html");
INSERT INTO dica_neogeo VALUES("Kabuki Klash","kabuki_klash.html");
INSERT INTO dica_neogeo VALUES("Last Blade","last_blade.html");
INSERT INTO dica_neogeo VALUES("Last Blade 2","last_blade_2.html");
INSERT INTO dica_neogeo VALUES("Neo Geo Cup '98","neo_geo_cup_98.html");
INSERT INTO dica_neogeo VALUES("Ninja Master's","ninja_masters.html");
INSERT INTO dica_neogeo VALUES("Pulsar","pulsar.html");
INSERT INTO dica_neogeo VALUES("Rage of the Dragons","rage_of_the_dragons.html");
INSERT INTO dica_neogeo VALUES("Ragnagard","ragnagard.html");
INSERT INTO dica_neogeo VALUES("Real Bouit Fatal Fury Special","real_bouit_fatal_fury_special.html");
INSERT INTO dica_neogeo VALUES("Real Bouit Fatal Fury Special 2 : The Newcomers","real_bouit_fatal_fury_special_2__the_newcomers.html");
INSERT INTO dica_neogeo VALUES("Samurai Shodown","samurai_shodown.html");
INSERT INTO dica_neogeo VALUES("Samurai Shodown 2","samurai_shodown_2.html");
INSERT INTO dica_neogeo VALUES("Samurai Shodown 3","samurai_shodown_3.html");
INSERT INTO dica_neogeo VALUES("Samurai Shodown 4","samurai_shodown_4.html");
INSERT INTO dica_neogeo VALUES("Samurai Shodown 5","samurai_shodown_5__samurai_spirits_zero.html");
INSERT INTO dica_neogeo VALUES("The King of Fighters 94","the_king_of_fighters_94.html");
INSERT INTO dica_neogeo VALUES("The King of Fighters 95","the_king_of_fighters_95.html");
INSERT INTO dica_neogeo VALUES("The King of Fighters 96","the_king_of_fighters_96.html");
INSERT INTO dica_neogeo VALUES("The King of Fighters 97","the_king_of_fighters_97.html");
INSERT INTO dica_neogeo VALUES("The King of Fighters 98","the_king_of_fighters_98__the_slugfest.html");
INSERT INTO dica_neogeo VALUES("The King of Fighters 99","the_king_of_fighters_99__millenium_battle.html");
INSERT INTO dica_neogeo VALUES("The King of Fighters 2000","the_king_of_fighters_2000.html");
INSERT INTO dica_neogeo VALUES("The King of Fighters 2002","the_king_of_fighters_2002.html");
INSERT INTO dica_neogeo VALUES("The King of Fighters 2003","the_king_of_fighters_2003.html");
INSERT INTO dica_neogeo VALUES("Twinkle Star Sprites","twinkle_star_sprites.html");
INSERT INTO dica_neogeo VALUES("Waku Waku 7","waku_waku_7.html");
INSERT INTO dica_neogeo VALUES("World Heroes Perfect","world_heroes_perfect.html");


INSERT INTO dica_pc VALUES("Abuse","abuse.html");
INSERT INTO dica_pc VALUES("Actua Soccer","actua_soccer.html");
INSERT INTO dica_pc VALUES("Actua Soccer 3","actua_soccer_3.html");
INSERT INTO dica_pc VALUES("After Burner","after_burner.html");
INSERT INTO dica_pc VALUES("Age of Empires : The Rise Of Rome","age_of_empires_the_rise_of_rome.html");
INSERT INTO dica_pc VALUES("Age of Empires II : The Age of Kings","age_of_empires_2_the_age_of_kings.html");
INSERT INTO dica_pc VALUES("Age of Mythology","age_of_mythology.html");
INSERT INTO dica_pc VALUES("Aladdin","aladdin.html");
INSERT INTO dica_pc VALUES("Aliens vs. Predator","aliens_vs_predator.html");
INSERT INTO dica_pc VALUES("Anno 1503","anno_1503.html");
INSERT INTO dica_pc VALUES("Archimedean Dynasty","archimedean_dynasty.html");
INSERT INTO dica_pc VALUES("Arkanoid","arkanoid.html");
INSERT INTO dica_pc VALUES("Armed & Dangerous","armed_e_dangerous.html");
INSERT INTO dica_pc VALUES("Battlefield 1942","battlefield_1942.html");
INSERT INTO dica_pc VALUES("Blade Runner","blade_runner.html");
INSERT INTO dica_pc VALUES("Blood & Magic","blood_e_magic.html");
INSERT INTO dica_pc VALUES("Bonkheads","bonkheads.html");
INSERT INTO dica_pc VALUES("Bug","bug.html");
INSERT INTO dica_pc VALUES("Championship Manager 4","championship_manager_4.html");
INSERT INTO dica_pc VALUES("Civilization","civilization.html");
INSERT INTO dica_pc VALUES("Civilization 2","civilization_2.html");
INSERT INTO dica_pc VALUES("Civilization 3","civilization_3.html");
INSERT INTO dica_pc VALUES("CivNet","civnet.html");
INSERT INTO dica_pc VALUES("Claw","claw.html");
INSERT INTO dica_pc VALUES("Comanche 3","comanche_3.html");
INSERT INTO dica_pc VALUES("Comanche 4","comanche_4.html");
INSERT INTO dica_pc VALUES("Comamad & Conquer : Generals","command_e_conquer_generals.html");
INSERT INTO dica_pc VALUES("Command and Conquer : Renegade","command_and_conquer__renegade.html");
INSERT INTO dica_pc VALUES("Commandos : Behind Enemy Lines","commandos__behind_enemy_lines.html");
INSERT INTO dica_pc VALUES("Commandos 2 : Men of courage","commandos_2__men_of_courage.html");


INSERT INTO dica_play2 VALUES("Black and Bruised","black_and_bruised.html");
INSERT INTO dica_play2 VALUES("Dynasty Warriors 3","dynasty_warriors_3.html");
INSERT INTO dica_play2 VALUES("Freaky Flyers","freaky_flyers.html");
INSERT INTO dica_play2 VALUES("Freestyle Metal X","freestyle_metal_x.html");
INSERT INTO dica_play2 VALUES("Grand Theft Auto III","grand_theft_auto_3.html");
INSERT INTO dica_play2 VALUES("Grand Theft Auto : Vice City","grand_theft_auto__vice_city.html");
INSERT INTO dica_play2 VALUES("Hitman 2 : Silent Assassin","hitman_2__silent_assassin.html");
INSERT INTO dica_play2 VALUES("Medal Of Honor : Rising Sun","medal_of_honor__rising_sun.html");
INSERT INTO dica_play2 VALUES("Midnight Club 2","midnight_cub_2.html");
INSERT INTO dica_play2 VALUES("Need For Speed : Hot Pursuit 2","need_for_speed_hot_pursuit_2.html");
INSERT INTO dica_play2 VALUES("Need for Speed Underground","need_for_speed_underground.html");
INSERT INTO dica_play2 VALUES("Red Faction","red_faction.html");
INSERT INTO dica_play2 VALUES("Roadkill","roadkill.html");
INSERT INTO dica_play2 VALUES("Silent Hill 3","silent_hill_3.html");
INSERT INTO dica_play2 VALUES("Snk vs Capcom svc Chaos","snk_vs_capcom_svc_chaos.html");
INSERT INTO dica_play2 VALUES("Star Wars : Jedi Starfighter","star_wars__jedi_starfighter.html");
INSERT INTO dica_play2 VALUES("Summer Heat Beach Volleyball","summer_heat_beach_volleyball.html");
INSERT INTO dica_play2 VALUES("Tenchu : Wrath of Heaven","tenchu_wrath_of_heaven.html");
INSERT INTO dica_play2 VALUES("The King of Fighters 2000","the_king_of_fighters_2000.html");
INSERT INTO dica_play2 VALUES("The King of Fighters 2001","the_king_of_fighters_2001.html");
INSERT INTO dica_play2 VALUES("The King of Fighters 2002","the_king_of_fighters_2002.html");
INSERT INTO dica_play2 VALUES("The Lord of the Rings : The Return of the King","the_lord_of_the_rings__the_return_of_the_king.html");
INSERT INTO dica_play2 VALUES("The Simpsons Hit & Run","the_simpsons_hit_e_run.html");
INSERT INTO dica_play2 VALUES("Zone of the Enders 2","zone_of_the_enders_2.html");


INSERT INTO dica_xbox VALUES("Aliens Vs Predator : Extinction","aliens_vs_predator_extinction.html");
INSERT INTO dica_xbox VALUES("Amped","amped.html");
INSERT INTO dica_xbox VALUES("ATV Quad Power Racing 2","atv_quad_power_racing2.html");
INSERT INTO dica_xbox VALUES("Brute Force","brute_force.html");
INSERT INTO dica_xbox VALUES("Deathrow","deathrow.html");
INSERT INTO dica_xbox VALUES("Def Jam Vendetta","def_jam_vendetta.html");
INSERT INTO dica_xbox VALUES("Elder Scrolls III : Morrowind","elder_scrolls3_morrowind.html");
INSERT INTO dica_xbox VALUES("Hitman 2 : Silent Assassin","hitman_2__silent_assassin.html");
INSERT INTO dica_xbox VALUES("James Bond 007 : Nightfire","james_bond_007__nightfire.html");
INSERT INTO dica_xbox VALUES("Jurassic Park : Operation Genensis","jurassic_park__operation_genensis.html");
INSERT INTO dica_xbox VALUES("Lord of the Rings : Two Towers","lord_of_the_rings__two_towers.html");
INSERT INTO dica_xbox VALUES("Mace Griffin : Bounty Hunter","mace_griffin__bounty_hunter.html");
INSERT INTO dica_xbox VALUES("Midnight Club 2","midnight_club_2.html");
INSERT INTO dica_xbox VALUES("Midtown Madness 3","midtown_madness_3.html");
INSERT INTO dica_xbox VALUES("Mission Impossible : Operation Surma","mission_impossible__operation_surma.html");
INSERT INTO dica_xbox VALUES("MVP Baseball 2003","mvp_baseball_2003.html");
INSERT INTO dica_xbox VALUES("NBA 2K3","nba_2k3.html");
INSERT INTO dica_xbox VALUES("NBA Street Vol. 2","nba_street_vol2.html");
INSERT INTO dica_xbox VALUES("Outlaw Golf","outlaw_golf.html");
INSERT INTO dica_xbox VALUES("Outlaw Volleyball","outlaw_volleyball.html");
INSERT INTO dica_xbox VALUES("Panzer Dragon Orta","panzer_dragon_orta.html");
INSERT INTO dica_xbox VALUES("Pirates of the Caribbean","pirates_of_the_caribbean.html");
INSERT INTO dica_xbox VALUES("Quantum Redshift","quantum_redshift.html");
INSERT INTO dica_xbox VALUES("Speed Kings","speed_kings.html");
INSERT INTO dica_xbox VALUES("Star Wars : Jedi Academy","star_wars__jedi_academy.html");
INSERT INTO dica_xbox VALUES("Star Wars : Jedi Starfighter","star_wars__jedi_starfighter.html");
INSERT INTO dica_xbox VALUES("The Simpsons Hit & Run","the_simpsons_hit_e_run.html");

[Firemaster]

Você deve salvar isso como um arquivo SQL (.sql) ou outra extensão que seja interpretada por qualquer front-end, como o mySQL-Front, phpmyadmin etc. É só jogar fazer isso e mandar rodar que o programa faz o resto. Dê uma procurada por estes programas.

[]'s

[Fhox]

Bem sabia q algum ia me dizer isso, mas o problemas eh q eu arrumei uma parceria com um servidor e eles usam um tal de cpanel, eu ate jah usei isso, mas para parcerios naum tem como ativar o cpanel, por isso q eu queria o cod em php pra min criar as tabelas e inserir os cod no mysql, se alguém souber pelo menos o cod pra min criar a tabela eu aceito. Vlws

[ScraX]

Hahahahhaah ... essa foi boa ... mais vamos lah ...

Dentro do cpanel ha uma opcao MySQL ou Gerenciar MySQL ... algo assim ... Clique nela ... va até onde tem pra gerneciar ... isso é facil ... lah vc tera que criar um BD ... tem um formulariozinho pra isso ...

Dps de criar vc vai lah em baixo nessa msm pagina ... tera a opcao phpMyAdmin ...

Ae vc vai ser redireciona ao phpmyadim ... ae no menu a esquerda vc ira escolher o BD que vc criou anteriormente ...

No quadro da direita aparecera alguams opcoes, cujo as quais nao me recordo ... mas em cima ... nas famsosas "orelhas" Tera alguams opcoes ... tais como Estrutura , Visualizar e mais algumas coisas ... Clique em SQL ...

Aparecera um quadro para vc digirar o codigo ... mas tbm tera uma opcao mais abaixo onde vc ira clicar no botao PROCURAR ... e ira pegar esse arquivo .sql que vc criou ... ou se preferir no quadro acima digite esse codigo todo lah .. (copia e cola) ....

Agora é com vc ...

Boa sorte

Flwz

[Firemaster]

É como eu disse, você pode usar front-ends para isso, tanto o mysql-front quando o phpmyadmin, tendo o nome de usuário e senha, dá para fazer isso sim. Cpanel é só um detalhe. E aliás, o Cpanel, na parte de banco tem um link para o phpmyadmin. Pelo menos, sempre tive esta opção. Dê uma olhada.

[]'s