Webwereld

[PHP] Probleempje met forms

Gestart doorTuffs3 reacties21 weergaven
Log in om mee te praten

4 berichten · pagina 1 van 1

Tuffs

Lid · Topicstarter

Berichten
251
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hey,

Ik ben een setup.php aan het maken voor een van mijn scripts.

Dit is mijn code om de MySQL te checken.
Maar als ik het uittest komt er steeds Settings Invalid, weet iemand hoe het komt?
(sorry het script is in het engels)

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/switch"]switch[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]step[/COLOR][COLOR= #007700]])
        case[/COLOR] [COLOR= #DD0000]2[/COLOR][COLOR= #007700]:
        {[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]step[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #DD0000]"2"[/COLOR][COLOR= #007700])
            {[/COLOR]
                [URL="http://www.php.net/header"]header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: setup.php?step=0&msg=um"[/COLOR][COLOR= #007700]);
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR]
                [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]step[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]"3"[/COLOR][COLOR= #007700];[/COLOR]
                ?>
                <h2>MySQL Settings</h2>
                <form method="post" action="setup.php?step=3">
                <fieldset>
                <legend>MySQL Settings</legend>
                <ul>
                <li>MySQL-Database Host: <input type="text" name="mysql_dbhost" /></li>
                <li>MySQL-Username: <input type="text" name="mysql_dbuser" /></li>
                <li>MySQL-Password: <input type="text" name="mysql_dbpass" /></li>
                <li>MySQL-Database Name: <input type="text" name="mysql_dbname" /></li>
                </ul>
                <input type="submit" name="step1_submit" value="Next" />
                </fieldset>
                <b>Validation of your MySQL settings may take up to 30 seconds if they are incorrect, if they are correct setup will continue instant.
                </form>
                [COLOR= #0000BB]<?php[/COLOR]    
            [COLOR= #007700]}[/COLOR]
            [URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
        }
        
        case[/COLOR] [COLOR= #DD0000]3[/COLOR][COLOR= #007700]:
        {[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]step[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #DD0000]"3"[/COLOR][COLOR= #007700])
            {[/COLOR]
                [URL="http://www.php.net/header"]header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: setup.php?step=0&msg=um"[/COLOR][COLOR= #007700]);
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbhost[/COLOR][COLOR= #007700]]) && ![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbhost[/COLOR][COLOR= #007700]]))
                {[/COLOR]
                    [COLOR= #0000BB]$dbhost[/COLOR] [COLOR= #007700]=[/COLOR] htmlentities[COLOR= #007700]([/COLOR][URL="http://www.php.net/trim"]trim[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbhost[/COLOR][COLOR= #007700]]));[/COLOR]
                    [COLOR= #0000BB]$valid[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700];
                }[/COLOR]
                [URL="http://www.php.net/else"]else[/URL]
                [COLOR= #007700]{[/COLOR]
                    [COLOR= #0000BB]$dbhost[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
                    [COLOR= #0000BB]$valid[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"0"[/COLOR][COLOR= #007700];
                }[/COLOR]
                
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbuser[/COLOR][COLOR= #007700]]) && ![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbuser[/COLOR][COLOR= #007700]]))
                {[/COLOR]
                    [COLOR= #0000BB]$dbuser[/COLOR] [COLOR= #007700]=[/COLOR] htmlentities[COLOR= #007700]([/COLOR][URL="http://www.php.net/trim"]trim[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbuser[/COLOR][COLOR= #007700]]));[/COLOR]
                    [COLOR= #0000BB]$valid[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700];
                }[/COLOR]
                [URL="http://www.php.net/else"]else[/URL]
                [COLOR= #007700]{[/COLOR]
                    [COLOR= #0000BB]$dbuser[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
                    [COLOR= #0000BB]$valid[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"0"[/COLOR][COLOR= #007700];
                }[/COLOR]
                
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbname[/COLOR][COLOR= #007700]]) && ![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbname[/COLOR][COLOR= #007700]]))
                {[/COLOR]
                    [COLOR= #0000BB]$dbname[/COLOR] [COLOR= #007700]=[/COLOR] htmlentities[COLOR= #007700]([/COLOR][URL="http://www.php.net/trim"]trim[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbname[/COLOR][COLOR= #007700]]));[/COLOR]
                    [COLOR= #0000BB]$valid[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700];
                }[/COLOR]
                [URL="http://www.php.net/else"]else[/URL]
                [COLOR= #007700]{[/COLOR]
                    [COLOR= #0000BB]$dbname[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
                    [COLOR= #0000BB]$valid[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"0"[/COLOR][COLOR= #007700];
                }[/COLOR]
                
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$valid[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]1[/COLOR][COLOR= #007700])
                {[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<p>"[/COLOR][COLOR= #007700];[/COLOR]
                    [COLOR= #0000BB]$dbpass[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mysql_dbpass[/COLOR][COLOR= #007700]];[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dbhost[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dbuser[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dbpass[/COLOR][COLOR= #007700]))
                    {[/COLOR]
                        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dbname[/COLOR][COLOR= #007700]))
                        {[/COLOR]
                            [COLOR= #0000BB]$connResult[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"3"[/COLOR][COLOR= #007700];
                        }[/COLOR]
                        [URL="http://www.php.net/else"]else[/URL]
                        [COLOR= #007700]{[/COLOR]
                            [COLOR= #0000BB]$connResult[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"2"[/COLOR][COLOR= #007700];
                        }
                    }[/COLOR]
                    [URL="http://www.php.net/else"]else[/URL]
                    [COLOR= #007700]{[/COLOR]
                        [COLOR= #0000BB]$connResult[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700];
                    }[/COLOR]
                    
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$connResult[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]"3"[/COLOR][COLOR= #007700])
                    {[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<font color=green>Connection established.</font>"[/COLOR][COLOR= #007700];[/COLOR]
                        [COLOR= #0000BB]$conn[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700];
                    }[/COLOR]
                    [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$connResult[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]"2"[/COLOR][COLOR= #007700])
                    {[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<font color=red>Connection established but your database is not found.</font>"[/COLOR][COLOR= #007700];[/COLOR]
                        [COLOR= #0000BB]$conn[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"0"[/COLOR][COLOR= #007700];
                    }[/COLOR]
                    [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$connResult[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700])
                    {[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<font color=red>Connection denied, please correct your settings.</font>"[/COLOR][COLOR= #007700];[/COLOR]
                        [COLOR= #0000BB]$conn[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"0"[/COLOR][COLOR= #007700];
                    }[/COLOR]
                    
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$conn[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700])
                    {[/COLOR]
                        [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]step[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]"4"[/COLOR][COLOR= #007700];[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<p>"[/COLOR][COLOR= #007700];[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Your settings are saved."[/COLOR][COLOR= #007700];[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<br />You will be redirected to the next step in 3 seconds."[/COLOR][COLOR= #007700];
                    }[/COLOR]
                    [URL="http://www.php.net/else"]else[/URL]
                    [COLOR= #007700]{[/COLOR]
                        [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]step[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]"3"[/COLOR][COLOR= #007700];[/COLOR]
                        [URL="http://www.php.net/header"]header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: setup.php?step=3"[/COLOR][COLOR= #007700]);
                    }
                }[/COLOR]
                [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$valid[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]0[/COLOR][COLOR= #007700])
                {[/COLOR]
                    [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]step[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]"3"[/COLOR][COLOR= #007700];[/COLOR]
                    ?>
                    Your MySQL settings are invalid.<br />
                    <a href="setup.php">Please try again</a>
                    [COLOR= #0000BB]<?php[/COLOR]
                [COLOR= #007700]}
            }
                }[/COLOR]

?>
0
Keizz

Lid

Berichten
283
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Heb je alles al ingesteld in PMA?
0
Tuffs

Lid · Topicstarter

Berichten
251
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Reportje voor spam want dat is echt een dom antwoord.

Als ik een setup script wil maken hoef ik phpmyadmin niet in te stellen, dat weet je als je de code bekijkt
0
Alemaalte

Lid

Berichten
5.957
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Geef even heel je script zodat ik het even op mijn eigen host kan uittesten of je niets fout hebt ingesteld.

*edit*

switch($_SESSION[step])
case 2:
{
if($_SESSION[step] != "2")
{
Dat is zeker al niet nodig ...

*edit2*

Als db_host en _user niet valid zijn, maar db_name wel, dan is $valid toch 1 wat eigenlijk 0 moet zijn, klopt dus niet.
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren