PHP entry-level interview questions are for programmers with little experience who are just looking for a job. This will be helpful to us The interview provided a lot of help. The interviewer officer would often test us, and the interview questions played a big role at this time.
5. Use PHP to print out the time of the previous day, in a format such as 2006-5-10 22:21:21
7. Linux creates the file exer1 and sets the access permission to rw-r--r--. Now To increase the execution permissions of all users and the write permissions of users in the same group, write the command
<script language="javascript">
var stmp1 = " to upper case ";
alert(stmp1.toLocaleUpperCase());//转换成大写
alert(stmp1.toUpperCase())//转换成大写
</script>
Copy after login
##9. Use Root login mysql database, if mydb does not exist, Create database mydb in mysql, Assign all permissions to the root user from 192.168 .1.1 ip to access the mysdb database. (The root user password is empty)
CREATE DATABASE IF NOT EXISTS mydb;
grant all on mydb.* to root@’ 192.168.1.1’ identified by '' ;
Copy after login
10. Now you need to get a list in the following format by querying the database, and sort it by the number of replies. The one with the highest reply is ranked Please write the sql for the first "Article ID Article Title Clicks and Replies":
## The message field of Table 1 is as follows:
Id
自increment id
Content
Content
##category_id
Category id
Hits
Clicks
Title
Title
The fields in Table 2 are as follows comment
comment_id
reply id
Id
The id in the associated message table
comment_content
Reply content
SELECT
M.`id`, M.`title`, M.`hits`, COUNT(C.`comment_id`) AS CNT
FROM
`message` AS M LEFT JOIN `comment` AS C ON M.`id` = C.`id`
GROUP BY M.`id`
ORDER BY CNT DESC;
Copy after login
Don’t worry after reading the above interview questions, there are other interview questions, basic things It's best to consolidate them all to help us interview and find jobs. Related recommendations:
The above is the detailed content of PHP entry-level interview questions: Programming questions (2). For more information, please follow other related articles on the PHP Chinese website!
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
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
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
Python is an ideal programming introduction language for beginners through its ease of learning and powerful features. Its basics include: Variables: used to store data (numbers, strings, lists, etc.). Data type: Defines the type of data in the variable (integer, floating point, etc.). Operators: used for mathematical operations and comparisons. Control flow: Control the flow of code execution (conditional statements, loops).
Java Made Simple: A Beginner's Guide to Programming Power Introduction Java is a powerful programming language used in everything from mobile applications to enterprise-level systems. For beginners, Java's syntax is simple and easy to understand, making it an ideal choice for learning programming. Basic Syntax Java uses a class-based object-oriented programming paradigm. Classes are templates that organize related data and behavior together. Here is a simple Java class example: publicclassPerson{privateStringname;privateintage;
Java is a popular programming language that can be learned by both beginners and experienced developers. This tutorial starts with basic concepts and progresses through advanced topics. After installing the Java Development Kit, you can practice programming by creating a simple "Hello, World!" program. After you understand the code, use the command prompt to compile and run the program, and "Hello, World!" will be output on the console. Learning Java starts your programming journey, and as your mastery deepens, you can create more complex applications.
Backend Development
