Linux Commands – Top 20 Most Used

1.Files and Directories Management

• ls – Lists files and directories content, I usually use “ls -la” to have a long listing with all the details and hidden files
• cd – move from the current directory to a different folder
• pwd – lists your current location
• mv – this command can either change the name of a file, or move it to a different location.
• locate – find any file on the Linux server, to get an updated index of files (if for example you just installed a whole bunch of RPM’s) run the command updatedb
• ln – create a shortcut to a file or folder
• tar – create or extract files out of a storage file. with the correct arguments it will also compress the files

2. Editing and Viewing

• tail – lists the last 10 lines of a file, but you tell tell it to show any number of last lines
• vi – the best command line editing software   a little hard to learn how to work this one at first, buts its worth the effort
• cat – list the content of the file. better know how long is the file you are running this command on, or you will get a very long scrolling of lines that will fill up your screen

3. General

• history – lists the last used commands on your Linux server
• make – when compiling a software from source, this command will create the binaries
• id – who am I right now? besides the philosophical angle, this command will show you as which user you will be running commands, I use this to check what is my status, and then sudo to the user I need
• sudo – execute a command as another user – although  usually use it to change to root
• ps – list the running processes on the server, it give more info like the process id, the parent process id, running time and much more
• man – displays a manual page, whenever you are not sure about a specific command or config file, you should run “man command” to get info about it. to search the man database use “whatis command” to find which man file has the info you need
• df – report file system disk space usage, use “df -h” to get a human formatted listing

reference

Başucu SQL Komutları :)

Her seferinde syntax ını unutup tekrar bakıp hatırladığım ve bu döngüden sıkıldığım için bu yazımda yazıp kurtulcam :)

1. INSERT

INSERT INTO Persons (P_Id, LastName, FirstName)
VALUES (5, 'Tjessem', 'Jakob')

2. DELETE

DELETE FROM Persons
WHERE LastName='Tjessem' AND FirstName='Jakob'

3. UPDATE

UPDATE Persons
SET Address='Nissestien 67', City='Sandnes'
WHERE LastName='Tjessem' AND FirstName='Jakob'

4. SELECT

SELECT LastName,FirstName FROM Persons

Step by Step Php development

1. install jdk
2. install xampp
3. install netbeans
4. install Php Plugins
5. make a php project

Setting up a PHP Project in the NetBeans IDE

1. Start the IDE, switch to the Projects window, and choose File > New Project. The Choose Project panel opens.

2. In the Categories list, choose PHP.

3. In the Projects area, choose PHP Application and click Next. The New PHP Project > Name and Location panel opens.

4. In the Project Name text field, enter NewPHPProject.

5. In the Sources Folder field, browse for your PHP document root and create a subfolder there called NewPHPProject. The document root is the folder where the web server looks for files to open in the browser. The document root is specified in the web server configuration file. For example, on Xampp, the document root is XAMPP_HOME/htdocs.

6. Leave all other fields with their default values. Click Next. The Run Configuration window opens.

7. In the Run As drop-down list, select Local Web Site. The project will run on your local Apache server. Your other options are to run the project remotely via FTP and to run it from the command line.


8. Leave the Project URL at default.

9. Click Finish. The IDE creates the project.

10. The NewPHPProject tree appears in the Projects window and the project's index.php file opens in the editor and in the Navigator window.

11. Enter the following code inside the block:

echo "Hello, world! This is my first PHP project!";

12. To run the project, position the cursor on the NewPHPProject node and choose Run from the context menu. The figure below shows what you should see in the browser window:

Install Php plugins in netbeans

1. In start page, click Install Plugins

2. Select PHP or related ones from Available Plugins tab, and click install. restart netbeans.

NetBeans IDE Installation

1. Once you have downloaded the installer file, double-click the installer's icon to launch the installer.download

2. In the install wizard, respond to the License Agreement, then click Next.

3. Specify an empty directory within which to install NetBeans IDE.
Note: This NetBeans IDE will not disrupt the settings of your other NetBeans installations because the IDE automatically creates a new user directory when launched (${HOME}/.netbeans/5.5.1).

4. Choose the JDK you want the IDE to use from the list of suitable choices in the list, then click Next.

5. Verify that the installation location is correct and that you have adequate space on your system for the installation.

6. Click Next to begin the installation.

Installing XAMPP on Windows

1. Download the software from: here

2. Double-click the .exe file you downloaded.

3. Choose a language from the menu, and then click OK.Click the Next button.Click the Next button once again.

4. Click Install.

5. Launch a Web browser, and, in the Location bar, type http://localhost/.