Hallo,
Ik krijg geen data in mijn database. Ik krijg telkens als result: godverdomme
Wat is er verkeerd met mijn script:
Ik krijg geen data in mijn database. Ik krijg telkens als result: godverdomme
Wat is er verkeerd met mijn script:
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]function[/COLOR] db_connect[COLOR= #007700](){[/COLOR]
[COLOR= #0000BB]$connect[/COLOR] [COLOR= #007700]= new[/COLOR] MySQLi[COLOR= #007700]([/COLOR][COLOR= #DD0000]"localhost"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"justinmijn_root"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"*****"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"justinmijn_nba"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #FF8000]// mysql_connect_errno() retourneert 0 als er geen fouten zijn[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700](![/COLOR][COLOR= #0000BB]$connect[/COLOR] [COLOR= #007700]||[/COLOR] mysqli_connect_errno[COLOR= #007700]() !=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
throw [COLOR= #007700]new[/COLOR] Exception[COLOR= #007700]([/COLOR][COLOR= #DD0000]Er kan geen connectie tot stand gebracht worden. De volgende fout heeft zich voorgedaan:[/COLOR] [COLOR= #007700].[/COLOR] mysqli_connect_errno[COLOR= #007700]().[/COLOR]
[COLOR= #DD0000] [/COLOR] [COLOR= #007700].[/COLOR] mysqli_connect_error[COLOR= #007700]() .[/COLOR] [COLOR= #DD0000]<br /><br /> Als zich dit blijft voordien, gelieve de site administrator te contacteren[/COLOR][COLOR= #007700]);
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$connect[/COLOR][COLOR= #007700];
}
}[/COLOR]
[COLOR= #0000BB]$aantalsp2w[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$aantalsp2l[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$aantalsp2p[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$sidesresult[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #DD0000]""[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$aantalsp2w[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"-"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$aantalsp2l[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"-"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$aantalsp2p[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$team[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"L.a. Lakers"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$expertname[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"Francesco"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$season[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"2006-2007"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$totalsresult[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"geneen"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #FF8000]//Connetie maken[/COLOR]
[COLOR= #0000BB]$connection[/COLOR] [COLOR= #007700]=[/COLOR] db_connect[COLOR= #007700]();[/COLOR]
[COLOR= #FF8000]//De gegevens wegschrijven in de database[/COLOR]
[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$connection[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO nba (team, expert, season, sides, totals) VALUES ($team, $expertname, $season, $sidesresult, $totalsresult)"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]){[/COLOR]
[URL="http://www.php.net/print"]print[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"gelukt"[/COLOR][COLOR= #007700]);
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/print"]print[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"godverdomme"[/COLOR][COLOR= #007700]);
}[/COLOR]
?>