Linux, Apache, MySQL, PHP

Member 13935271 wrote:

Message from Member 13935271 <jamess@integrity-foundation.org>:

Internal network meaning?

.htaccess sees only public IP

The application which we are developing will be hosted on a VPS server on a domain. Now it will be online, anybody can access it using the domain name. Now I want that only our office employees should be able to see or access this application using this domain.

Basically I want that i need to pre define their IP in .htaccess file in allow section. I want to allow only these IP and deny all.(meaning only our organizations employees will have access to this application)

So should I specify their public IP in .htaccess? Does this IP change from network to network?

Even if you never seen what PHP looks like, you still don't need to focus on reading books and lenthy know-hows. Once you get to grips with the fundamentals, you don't need board prep either.

At the same time, it would be headlong to dive into the coding process without any prior studying. 
Yep, any coding language is better learnt in practice, yet it's essential to know the basics.

With that being said, start your reserch with the PHP official website. It provides a great and digestible overview which should be enough to grasp the language fundamentals, even if have no programming experience whatsoever.

Once you've hit the grindstone, you're good to head out into the PHP practice.

Now it’s time to write some PHP code.

Basically, you require only 2 things for this: a development environment to run your PHP scripts and a code editor to write the code.

1. Install a local development environment
First of all, you need an interpreter to make sense of your code and run it (since PHP is a scripting language). 

Where do you write code? Development environment. A DE is usually a single program in which all development is done. It usually contains many functions for creating, modifying, compiling, deploying and debugging software. The purpose of the development environment is to abstract the configuration needed to combine the command line utilities into a single module, which will reduce the time to learn the language and increase developer productivity.

IDE
Try each development environment and see which platform you feel most comfortable with:

PHPStorm;
Netbeans;
Aptana Studio;
Eclipse.

Code editors for PHP projects
Sublime Text;
Visual Studio Code;
Atom;
Coda;
jEdit;
Programmer's Notepad;
Komodo Edit.

If you’re not sure which one to go with, try XAMP. It's an easy to install and easy to use Apache distribution containing MySQL, PHP, and Perl. 

2. Install a code editor
A code editor is aт editor for creating and editing program source code. It can be a standalone application or embedded in an integrated development environment (IDE).

3. Start coding
Run your IDE, open a browser and type localhost in the URL bar.

You will see the DE’s homepage. 
Your PHP scripts must be inserted inside a directory aka webserver root.

<pre>Now open your code editor and paste the following PHP code: 

 

<?php

echo '<h1 style="text-align: center;">Hello World!</h1>';

 

Save the file inside the htdocs directory as hello_world.php (you can use any file name you want, just be sure to use the .php extension), then go back to your web browser and open the URL:

http://localhost/hello_world.php

Voila, ready!

piano0011 wrote:

tutorial by passive income

The mysqli_stmt_num_rows() function accepts a statement object as a parameter and returns the number of rows in the result set of the given statement.

The mysqli_num_rows() function is an inbuilt function in PHP which is used to return the number of rows present in the result set. 

Quote:

i am watching tutorials on PHP and MYSQL but since the video and now SQL syntax changed

$uh=strtolower($_GET['uh']);
if($uh=='u'||$uh=='h'){

if ($result=mysqli_query($link, $sql)) {
    if (mysqli_num_rows($result)) {
        // Process rows here
    } 
    else {
        echo 'no results';
    }
} 
else {
    printf("SQL error: %s\n", mysqli_error($link));
}

$sql = "SELECT food,calories FROM food WHERE healthy_unhealthy = '". $uh . '" ORDER by id";

$_GET