Why is this code not working?

pcf43 Peon

Messages:: 21

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#21

The Webby said: ↑

LOL, check the file permission of the page you are trying to access, make sure you have execution permission for it..

Using Linux or windows?
Click to expand...

Windows, and running Easy PHP as local web server package.

pcf43, Jun 21, 2011 IP

The Webby Peon

Messages:: 1,852

Likes Received:: 30

Best Answers:: 1

Trophy Points:: 0

#22

Running Apache as service? Which version of Windows, seems like you messed up Apache somehow..
You dont get file permission error on windows normally, unless you messed up either PHP or Apache module.

The Webby, Jun 21, 2011 IP

pcf43 Peon

Messages:: 21

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#23

The Webby said: ↑

Running Apache as service? Which version of Windows, seems like you messed up Apache somehow..
You dont get file permission error on windows normally, unless you messed up either PHP or Apache module.
Click to expand...

I am running Windows 7 and the version of Apache is 2.2.17 MySQL is 5.5.10 and PHP version is 5.3.6 also the phpmyadmin app uses version 3.3.9.2

pcf43, Jun 21, 2011 IP

The Webby Peon

Messages:: 1,852

Likes Received:: 30

Best Answers:: 1

Trophy Points:: 0

#24

pcf43 said: ↑

I am running Windows 7 and the version of Apache is 2.2.17 MySQL is 5.5.10 and PHP version is 5.3.6 also the phpmyadmin app uses version 3.3.9.2
Click to expand...

What have you been doing lately? As I said, it shouldn't be file permission error, but check that to be sure.
Most likely it is messed up Apache module or PHP config.

The Webby, Jun 21, 2011 IP

pcf43 Peon

Messages:: 21

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#25

@The Webby:Actually I'm in the process of scanning the Registry Editor right now and it seems like I have over 100 files which have errors on them. Could the Registry Editor influence the performance of the webserver?

pcf43, Jun 21, 2011 IP

The Webby Peon

Messages:: 1,852

Likes Received:: 30

Best Answers:: 1

Trophy Points:: 0

#26

pcf43 said: ↑

@The Webby:Actually I'm in the process of scanning the Registry Editor right now and it seems like I have over 100 files which have errors on them. Could the Registry Editor influence the performance of the webserver?
Click to expand...

Umm, may be.. You mess up any Apache module and you will start to get weird errors...

The Webby, Jun 21, 2011 IP

pr-biztech Peon

Messages:: 76

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#27

The Webby said: ↑

Nah, code is not too long. Its not the problem..
Problem is with how you are displaying the form and how you are handling the data..

Make something simple like this:


<?php
                require_once 'include_admin.php';
                require_once 'mysql_con.php';
?>
<html>
    <head>
        <title></title>
    </head>
        <body>
			</br>
				
				<form method="post" name="cat_type" action="<?=$_SERVER['PHP_SELF']?>">
				To create a new category please do the following:</br>1. Enter category's name in the field below:</br>
					<input type="text" name="cat_name" value=""></br>
					<br />
					2. Choose if this is a root category or a subcategory:</br>
					<select name="type">
                         <option>Root category</option>
                         <option name="subcat">Subcategory</option>                  
                     </select>
					 3. Press the insert button, and you're done!<br />
					 <input type='submit' name='addCat' method='post' value='New Category'>
                </form>
                 
                
                
    <?php
        $cat_name=isset($_POST['cat_name']);
        $cat_type=isset($_POST['type']);
        if(isset($_POST['addCat'])){
            $query=mysql_query("
            INSERT INTO 
            categories 
            ('name','type')
            VALUES
            ('$cat_name','$cat_type')
            ")or die(mysql_error());
        
        echo "succesfully added.";
		}else{
            
            echo "cannot query database";
        
        }
        if(isset($query)){
                                            //get query result
                                            $scanAllCat=mysql_query("               
                                            SELECT 
                                            name,type 
                                            FROM 
                                            categories 
                                            ");
                                            //show query on screen
                                            $showAllCat=mysql_result($scanAllCat,0,"name");
											
                                            
                                            echo    "Here are all the categories currently available: </br> <style=\"background-color:#5dddec;\">".$showAllCat."</style>";
                                        
                                    }else{
                                    
                                        echo    "</br>cannot show data from the sql table";
                                        
                                    }
        
        
        
        ?>
        
        </body>
</html>

PHP:

Also note that your query to get categories from database will not show all the categories available, it will only show the first row. To show all the categories you need this instead:


//get query result
                                            $scanAllCat=mysql_query("               
                                            SELECT 
                                            name,type 
                                            FROM 
                                            categories 
                                            ");
echo    "Here are all the categories currently available: ";
while($result = mysql_fetch_assoc($scanAllCat)){
echo    "<p style=\"background-color:#5dddec;\">".$showAllCat."</p>";
}

PHP:

Also, you don't use Style tag the way you did in your code..

Click to expand...

I am agree with you. Code is no to long but your method for sharing it is not good. No one can understand it properly.

pr-biztech, Jun 22, 2011 IP

Log in or Sign up

Why is this code not working?

pcf43 Peon

The Webby Peon

pcf43 Peon

The Webby Peon

pcf43 Peon

The Webby Peon

pr-biztech Peon

Useful Searches