Linux, Apache, MySQL, PHP

10-Dec-11 3:46

The first warning is telling you that the value returned from mysql_query(), which you stored in $result is a boolean. This means that the query failed, because mysql_query returns FALSE when a SELECT query fails.

The second warning is telling you that it cannot output any headers, because it has already sent output to the browser - in this case, the first warning message.

You should check the return values from your database function calls. mysql_connect might have failed, or mysql_query could have failed for any number of reasons - use mysql_error[^] to find out what went wrong and fix it.

You should also sanitize all user input before building a query from it. Google for "sql injection" if you don't know what I'm talking about.

Re: error in login page

Jassim Rahma10-Dec-11 3:55

Jassim Rahma

10-Dec-11 3:55

I got it... no database selected..

BUT...

now I have another problem..

everytime I enter the correct user id and password it's just going back to login.php with no error message.

I am 1000000% sure about the user id and password, infact I added another uder and having the same problem.

user ID : abc123
Password : abc123

Re: error in login page

Graham Breach10-Dec-11 4:10

Help me in configuring the PHP .How to run a PHP program

10-Dec-11 4:10

Okay... I won't try to guess which page is doing what wrong, but I will give you this handy code snippet:

echo '<pre>' . print_r(get_defined_vars(), true) . '</pre>';

If you insert that into a page where you think things are going wrong, it will dump all the variables into the page. I would try putting it before your if statement that does the redirects first, and see if $count is what you expect it to be.

You should turn on all errors and warnings when you are developing too:

ini_set('display_errors', 1);
error_reporting(E_ALL | E_STRICT);

plz help - htaccess

Jassim Rahma9-Dec-11 2:52

Jassim Rahma

9-Dec-11 2:52

Hi,

can anyone help on how to do this in htaccess please..

I want to make every:

www.mydomain.com/news.php?id=777

shows as

www.mydomain.com/777

where 777 is the primary key in my news table.

Thanks,
Jassim

Simple PHP

omanzo_barrett8-Dec-11 8:39

omanzo_barrett

8-Dec-11 8:39

I been looking around for a good tool to learn PHP and i stumble up on this http://be2f81j9hp809o6rpk2bhbxkd5.hop.clickbank.net/?tid=1 site. Please tell me what you think about it?

VickyVicki8-Dec-11 4:32

Re: Help me in configuring the PHP .How to run a PHP program

8-Dec-11 4:32

Hi Friends,
I am new to PHP and I want to know how to run a PHP program .Would like to know how to configure it and kindly help in suggesting what kind of software to be used to run it.I tried with WAMP Server but i was not able to run it. Frown | :(

.Thanks in Advance.

awedaonline8-Dec-11 10:01

Re: Help me in configuring the PHP .How to run a PHP program

8-Dec-11 10:01

Upon successful installation of WAMP, open a text editor and type

HTML

<html>
<head><title>My First PHP Website</title></head>
<body>
<?php phpinfo(); ?>
</body>
</html>

make sure that you save it in the www of your php installation folder: eg: C:\wamp\www

then laugth your web browser and typing http://localhost/filename.php or http://localhost:8080/filename.php as the case may be.

it should work this way.

welcome to the php world
happy programming

VickyVicki9-Dec-11 4:38

Re: Help me in configuring the PHP .How to run a PHP program

9-Dec-11 4:38

Thanks friend.I installed the wamp server and placed the following code in www folder .And started the server in the web browser typed the url http://localhost/filename.php[]

But i m getting this error message.

Not Found
The requested URL /filename.php was not found on this server.

Apache/1.3.12 Server at changeme.local.lan Port 80

Frown | :(

I really want to learn php .Kindly help me

awedaonline9-Dec-11 4:48

Re: Help me in configuring the PHP .How to run a PHP program

9-Dec-11 4:48

the file name I mean is the name you gave the file when you saved it. eg: index.php (the file name is index).

VickyVicki9-Dec-11 5:55

Re: Help me in configuring the PHP .How to run a PHP program

9-Dec-11 5:55

I saved with the same filename .Got to know the problem now but dont have the solution for the same.
The issue is that port 80 is being used by another process hence apachi is not installed i guess in wamp server Frown | :(

.I dont know how to configure it to another port no .

awedaonline11-Dec-11 11:01

Re: Help me in configuring the PHP .How to run a PHP program

11-Dec-11 11:01

You can verify if Apache was installed from windows services (scroll down and look for wampapache). If not, you can uninstall the wamp server and reinstall again, then ensure that WAMP installs Apache for you.

Hope this helps?

Gerben Jongerius11-Dec-11 19:29

Gerben Jongerius

11-Dec-11 19:29

Even if port 80 is in use that should not stop the installation of WAMP. You won't be able to startup WAMP until you close the other program using port 80. Usually this is skype, as this reserves port 80 and 8080 for outgoing and incoming traffic.

You can try and locate the process by running

netstat -ob

Re: Help me in configuring the PHP .How to run a PHP program

VickyVicki12-Dec-11 5:28

12-Dec-11 5:28

Thanks for all .Successfully executed my first php program. Smile | :)

.I formatted my system and installed it and i m able to run the program now . Smile | :)

AMPPS Perl

Paul15866-Dec-11 2:06

Paul1586

6-Dec-11 2:06

Hi,

I am a newbie, I want to install a Perl script named "Movable Type", I am unable to configure it myself, so I was searching for a software that could provide me to install this script very easily and I came across AMPPS, a Softaculous product. Had anyone use this software, if yes then how is this software and how can I install this script using AMPPS ?

Albert Holguin7-Dec-11 7:42

Albert Holguin

7-Dec-11 7:42

Do you really need an installer for a script? The whole point of scripting is supposed to be the simplicity of it. If you really need an installer, then maybe scripting isn't for you.

What are you using the script for? Is it just an extension for Perl?

jschell30-Dec-11 8:55

jschell

30-Dec-11 8:55

To be fair cpan is specifically used for installing modules in perl.

Certainly I haven't installed any perl modules or perl itself for many years without using some sort of installer.

Albert Holguin3-Jan-12 18:19

Albert Holguin

3-Jan-12 18:19

You certainly can't compare the installation of perl with running a script in perl. Perl itself is a complex arrangement of packages and an interpreter... a script can be a simple two line text file. If you need to run a script that requires an installer, you probably should be doing it as a program instead of a script.

jschell30-Dec-11 8:57

jschell

30-Dec-11 8:57

Paul1586 wrote:
I am a newbie, I want to install a Perl script named "Movable Type", I am unable to configure it myself

What does that mean exactly.

If you install something and it requests/requires information from the user during install then the user needs to figure out what that info means.

If you were installing in multiple locations on fixed platform targets (all the same) then you could simplify the install by putting in appropriate values. However YOU would need to first figure out what the correct values were.

Return list of object from a Class

Phil Hartfield10-Jan-12 8:25

Phil Hartfield

10-Jan-12 8:25

Movable Type isn't just a single perl script. It is a multi-user blogging system (I thought it reminded me of a site I'd used when I set it up and that is indeed what plinky.com is using - no plug intended)

Setting it up under windoze was relatively easy. Copy the mt directory to somewhere under the web server's document root, modify the httpd.conf, add a perl module or too as required by the config cgi (it tells you what's missing), and fix the #! lines in the cgi's for windoze. Setting up a new user via the register link requires that outgoing mail is working properly. Had to search in the online documentation for the config file settings it needs for SMTP.

Took me a grand total of 45 minutes, never having installed/configured MT before. I did take the easy route and used SQLite instead of trying Mysql or Postgresql (both are currently on my windoze box though)

Installation under linux would be easier, no editing all those cgi's by hand (not really enough for a script for a single time install but the creators could have included one...)

awedaonline5-Dec-11 22:36

5-Dec-11 22:36

Hi all,

I am new to PHP development after a reasonable experience with the .NET.

I have just created a class to return list of categories from the category table and display on my home page.

Below is my code snippets:

PHP

<?php

class Connection {
    
    private $username = "root";
    private $password = "password";
    private $dbName = "aweklin";
    private $host = "localhost";
    
    private $link;
    
    public function __construct() {
        $this->link = mysqli_connect($this->host, $this->username, $this->password);        
        if (!$this->link) {
            // todo: display error
        }
        if (!mysqli_set_charset($this->link, 'utf8')) {
            // todo: display error
        }
        if (!mysqli_select_db($this->link, $this->dbName)) {
            // todo: display error
        }
    }

    public function getAllCategories() {
        $sql = mysqli_query($this->link, "CALL getCategories()");
        while ($row = mysqli_fetch_array($sql)){
            $row['description'] . '<br />';
        }
        return $row;
    }
    public function executeQuery ($query) {
        if (!$this->query($query)) {
            // todo: display error
        }
    }
}

?>

on my home.php page, I have:

PHP

<?php include_once $_SERVER['DOCUMENT_ROOT'] . 'aweklin/classes/LinkHelper.php'; ?>
<?php include_once $_SERVER['DOCUMENT_ROOT'] . 'aweklin/classes/DB/Connection.php'; ?>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <link rel="stylesheet" href="styles/layout.css" type="text/css" />
        <script type="text/javascript" src="script/ref/jquery-1.6.2.min.js" /></script>
    <title><?php StringHelper::getHtml($title, TRUE); ?></title>
    </head>
    <body>
        <div id="wraper">
            <?php
                LinkHelper::setPageHeader();
            ?>
            
            <div id="page">
                <article>
                    <div class="content">
                        <div class="title"><?php StringHelper::getHtml($title, TRUE); ?></div>
                        <?php 
//                            $link =mysqli_connect("localhost", "root", "password");        
//                            if (!$link) {
//                                echo 'Unable to connect to the database server';
//                            }
//                            if (!mysqli_set_charset($link, 'utf8')) {
//                                echo 'Unable to set character set';
//                            }
//                            if (!mysqli_select_db($link, 'aweklin')) {
//                                echo 'Unable to connect to the database aweklin';
//                            }
//                            $sql = mysqli_query($link, "CALL getCategories()");
//                            while ($row = mysqli_fetch_array($sql)){
//                                echo $row['description'] . '<br />';
//                            }
                        
                            $con = new Connection();
                            $cat[] = $con->getAllCategories();
                            foreach ($cat as $c) {
                                echo $c;
                            }
                        ?>
                    </div>
                </article>
            
                <?php
                    LinkHelper::setSideBar();
                ?>                
            </div>
            <?php
                LinkHelper::setPageFooter();
            ?>
        </div>
    </body>
</html>

The problem is, I got nothing displayed on the home.php page.
If you can notice, I comment out some block of code their, that worked for me. But I want to use OOP approach to do this.

Tell me, what am I getting wrong here?

Thanks.

Graham Breach5-Dec-11 23:54

5-Dec-11 23:54

Your getAllCategories function will return NULL, because it is returning the last value returned by mysqli_fetch_array($sql).

You can return an array of results this way:

$results = array();
while($row = mysqli_fetch_array($sql)){
  $results[] = $row['description'];
}
return $results;

or a string:

$results = '';
while($row = mysqli_fetch_array($sql)){
  $results .= $row['description'] . '<br />';
}
return $results;

You also have $cat[] = $con->getAllCategories(); - this will add whatever the function returns as a new entry in the $cat array, which probably is not what you want.

awedaonline6-Dec-11 0:22

6-Dec-11 0:22

Thank Graham;

Your response was correct. So on my home.php page, this is what I finaly did:

PHP

$con = new Connection();
$cat = $con->getAllCategories();
foreach ($cat as $c) {
   echo $c['description'] . '<br />';
}

But the result of the above was the first character of each record per row.

How do I fix this?

Graham Breach6-Dec-11 0:52

6-Dec-11 0:52

This is a bit confusing, but I've worked it out.

You've already pulled the "description" field out of the row in the getAllCategories function - so now echo $c['description'] ... is accessing the string $c, and not an associative array. The square brackets are referring to the characters of the string, so 'description' is being evaluated as 0 and you are getting the first character in the string.

Try using this instead:

echo $c . '<br />';

awedaonline6-Dec-11 1:01