2017 Linux summary tutorial_PHP tutorial
linux&php
1. PHP&MySQL
-----PHP built-in MySQL function learning (3)-----
Preparation
$con=mysqli_connect('localhost','root','','info');
if($con){
echo "Connection successful";
}else{
echo "shit";
}
//mysql_close($con);
if(mysqli_select_db($con, 'info ')){
echo "Database selection successful";
}else{
echo "shit2";
}
/*
----mysql_num_rows()
Get the number of rows in the result set
$query=mysqli_query($con, 'select * from test');//Generate the result set
echo mysqli_num_rows($query ; >
mysqli doesn’t seem to be available, please add some --- PDO, mysql, mysqli in phpPHP-MySQL is the most original Extension for PHP to operate the MySQL database, PHP-MySQLi The i stands for Improvement, which provides relatively advanced functions. As far as Extension is concerned, it also increases security. PDO (PHP Data Object) provides an Abstraction Layer to operate the databaseI can’t tell you the specific difference, just search it and have a look--- -mysqli_affected_rows($con)The number of affected rows is generally used for judgment. For example, when the inserted ones are the same, it is displayed as 0; it feels like mysql feedbackStart the following small practice tomorrow2. LinuxIt is still troublesome to install things in the virtual machine. xshell is finally done. Sure enough, the centos server interface is not so easy to fix. Fortunately, there are noble people After entering centos6, enter the user name and password and start to solve network connection problemsForgot the original URL, write it yourself---vim /etc/sysconfig/network-scripts/ifcfg-eth0Enter i to enter writing Mode change htcp or something to none, change the onboot item to yes and then enter IPADDR=192.168.0.10NETMASK=255.255.255.0
GATEWAY=192.168.0.2The addresses here are all the addresses of my own network. The query method is win r in the windows interface, enter cmd, enter ipconfig/all Find the corresponding address. If it is a wireless network, look for the wireless network card. If it is wired, look for the wired one. In short, it must correspond; if the network is changed, the corresponding configuration must also change If found The address is 192.168.0.1, then input it in Linux and it will become 192.168.0.a a is not 1, just fine and the gateway behind it is 192.168.0.b b No Equal to 1, not equal to a Then return to linux in the virtual machine, press esc, enter: wq, save and exit file writingEnter service network restart, restart the network service
Then go to the cmd window under Windows just now and enter ping 192.168.0.10 (I set this myself, can you enter your own value?) If it succeeds, the network connection is OKAs for the settings of xshell, it is very simpleCreate a new connection, enter 192.168.0.10 for the location of the host, and then remember to store the user name and password, and just test the connection I have solved the problem of xshell, so happy! I don’t want to write anything else, let’s play with Linux~~~
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1664
14
1421
52
1315
25
1266
29
1239
24
PHP and Python: Different Paradigms Explained
Apr 18, 2025 am 12:26 AM
PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.
Choosing Between PHP and Python: A Guide
Apr 18, 2025 am 12:24 AM
PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.
Linux Architecture: Unveiling the 5 Basic Components
Apr 20, 2025 am 12:04 AM
The five basic components of the Linux system are: 1. Kernel, 2. System library, 3. System utilities, 4. Graphical user interface, 5. Applications. The kernel manages hardware resources, the system library provides precompiled functions, system utilities are used for system management, the GUI provides visual interaction, and applications use these components to implement functions.
PHP and Python: A Deep Dive into Their History
Apr 18, 2025 am 12:25 AM
PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.
PHP's Impact: Web Development and Beyond
Apr 18, 2025 am 12:10 AM
PHPhassignificantlyimpactedwebdevelopmentandextendsbeyondit.1)ItpowersmajorplatformslikeWordPressandexcelsindatabaseinteractions.2)PHP'sadaptabilityallowsittoscaleforlargeapplicationsusingframeworkslikeLaravel.3)Beyondweb,PHPisusedincommand-linescrip
The Continued Use of PHP: Reasons for Its Endurance
Apr 19, 2025 am 12:23 AM
What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.
laravel installation code
Apr 18, 2025 pm 12:30 PM
To install Laravel, follow these steps in sequence: Install Composer (for macOS/Linux and Windows) Install Laravel Installer Create a new project Start Service Access Application (URL: http://127.0.0.1:8000) Set up the database connection (if required)
Docker on Linux: Containerization for Linux Systems
Apr 22, 2025 am 12:03 AM
Docker is important on Linux because Linux is its native platform that provides rich tools and community support. 1. Install Docker: Use sudoapt-getupdate and sudoapt-getinstalldocker-cedocker-ce-clicotainerd.io. 2. Create and manage containers: Use dockerrun commands, such as dockerrun-d--namemynginx-p80:80nginx. 3. Write Dockerfile: Optimize the image size and use multi-stage construction. 4. Optimization and debugging: Use dockerlogs and dockerex
