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

AI Hentai Generator
Generate AI Hentai for free.

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

PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati

DeepSeek is a powerful intelligent search and analysis tool that provides two access methods: web version and official website. The web version is convenient and efficient, and can be used without installation; the official website provides comprehensive product information, download resources and support services. Whether individuals or corporate users, they can easily obtain and analyze massive data through DeepSeek to improve work efficiency, assist decision-making and promote innovation.

There are many ways to install DeepSeek, including: compile from source (for experienced developers) using precompiled packages (for Windows users) using Docker containers (for most convenient, no need to worry about compatibility) No matter which method you choose, Please read the official documents carefully and prepare them fully to avoid unnecessary trouble.

Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c

This tutorial demonstrates how to efficiently process XML documents using PHP. XML (eXtensible Markup Language) is a versatile text-based markup language designed for both human readability and machine parsing. It's commonly used for data storage an

A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total

BITGet is a cryptocurrency exchange that provides a variety of trading services including spot trading, contract trading and derivatives. Founded in 2018, the exchange is headquartered in Singapore and is committed to providing users with a safe and reliable trading platform. BITGet offers a variety of trading pairs, including BTC/USDT, ETH/USDT and XRP/USDT. Additionally, the exchange has a reputation for security and liquidity and offers a variety of features such as premium order types, leveraged trading and 24/7 customer support.

Ouyi OKX, the world's leading digital asset exchange, has now launched an official installation package to provide a safe and convenient trading experience. The OKX installation package of Ouyi does not need to be accessed through a browser. It can directly install independent applications on the device, creating a stable and efficient trading platform for users. The installation process is simple and easy to understand. Users only need to download the latest version of the installation package and follow the prompts to complete the installation step by step.
