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
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.
Why Use PHP? Advantages and Benefits Explained
Apr 16, 2025 am 12:16 AM
The core benefits of PHP include ease of learning, strong web development support, rich libraries and frameworks, high performance and scalability, cross-platform compatibility, and cost-effectiveness. 1) Easy to learn and use, suitable for beginners; 2) Good integration with web servers and supports multiple databases; 3) Have powerful frameworks such as Laravel; 4) High performance can be achieved through optimization; 5) Support multiple operating systems; 6) Open source to reduce development costs.
PHP vs. Python: Use Cases and Applications
Apr 17, 2025 am 12:23 AM
PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.
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.
PHP: An Introduction to the Server-Side Scripting Language
Apr 16, 2025 am 12:18 AM
PHP is a server-side scripting language used for dynamic web development and server-side applications. 1.PHP is an interpreted language that does not require compilation and is suitable for rapid development. 2. PHP code is embedded in HTML, making it easy to develop web pages. 3. PHP processes server-side logic, generates HTML output, and supports user interaction and data processing. 4. PHP can interact with the database, process form submission, and execute server-side tasks.
PHP and the Web: Exploring its Long-Term Impact
Apr 16, 2025 am 12:17 AM
PHP has shaped the network over the past few decades and will continue to play an important role in web development. 1) PHP originated in 1994 and has become the first choice for developers due to its ease of use and seamless integration with MySQL. 2) Its core functions include generating dynamic content and integrating with the database, allowing the website to be updated in real time and displayed in personalized manner. 3) The wide application and ecosystem of PHP have driven its long-term impact, but it also faces version updates and security challenges. 4) Performance improvements in recent years, such as the release of PHP7, enable it to compete with modern languages. 5) In the future, PHP needs to deal with new challenges such as containerization and microservices, but its flexibility and active community make it adaptable.
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
