Asksearch_php.cn

Community Learn Tools Library Leisure

English

Popular searches：
PHP
MySQL
jquery
HTML
CSS

Create a php file of specified size

How to create a file of given size (regardless of content) in PHP? I have to create a file larger than 1GB. Maximum approximately 4-10GB

P粉221046425 2023-10-26 14:03:01

How to export partial rows of a MySQL table from WHERE clause?

How to export certain rows of MySQL table using where clause from PHP script? I have a MySQLsay test and I want to use a PHP script to create an importable .sql file for rows with ids between 10 and 100. I want to create a sql file test.sql which can be imported into a MySQL database. My code: $con=...

P粉054616867 2023-10-21 11:41:17

Opencart 2: Call php files using Ajax

I want to ajax call a system/helper php file I created that calls a method on a model that adds a coupon in the database. php file contains the following content. <?phpfunctioncoupon_for_acumba(){$this->load->model('total/coupon');echo$this->model_total_coupon->coupon_test();} I creat...

P粉153503989 2024-03-31 23:09:02

Backup of PostgreSQL database design - no data

I'm trying to find a way to backup my database design without including the data stored in the database. Actually, one might say I want a file containing all "CREATEScripts" in the database. Ideally, this file can be used to recreate the database (without the data of course). How to avoid ...

P粉098417223 2023-08-24 14:29:36

Set the $_POST variable to empty while using php://input to get everything correct

I have created a React application from which I call a server built on PHP. Here's how I call the PHP file: constrequestOptions={method:'POST',headers:{'Content-Type':'application/x-www-form-urlencoded'},body:JSON.stringify({name,username ,password}),};console.l

P粉032649413 2024-03-27 19:30:45

Dynamically populating HTML forms at scale: via SQL values in PHP

This question has more to do with the process/logic I'm hoping to implement in terms of "SCALE" than how to write the code. In WordPress, I have several forms that load as HTML and when the user creates a custom post (actually a new database entry for those not familiar with CMS) to log a ...

P粉765570115 2023-09-10 17:28:20

How to include PHP files located in different locations in different folders

Most of my website is in the root directory. In this directory there are "css", "functions" and "images" folders. When I include the php file in index.php or other root files everything works fine. It contains and executes correctly. But the problem arises when I create...

P粉447002127 2023-08-22 00:21:10

Ask the experts for advice: How to set PHPStudy parameters to practice using PHP website template documents and view the results in the browser?

I downloaded a simple php website template from the Internet and want to practice based on this template. After configuring with PHPStudy, I want to see the website effect through the browser. The configuration seems to be unsuccessful. Do you have any experience in this area? What parameters need t...

Ocean Blue 007 2020-03-22 12:09:49

Vue 3 - Svgator player is always undefined.

Currently, I create an SVG animation using SVGator. I imported it as a resource into my app and tried to get it running. I followed the instructions in the documentation and got it working. However, since I may need to create a large number of animations, I tried to make it more general. I imported ...

P粉478835592 2023-07-28 08:44:31

In SQL templates, Airflow's XCom returns values as double quoted strings while Snowflake uses single quoted strings in SQL queries

I'm new to ETL and working on airflow and snowflakes. I use a python operator to get the maximum created value from a mysql table and based on the xcom of that operator I create a csv file of snowflake data to dump only the latest created data from mysql to snowflake. The problem is when I extract t...

P粉043470158 2024-02-25 15:36:12

Is it possible to dynamically update a "gallery" of images when a user submits an image?

I'm creating a website that will feature all of my grandfather's photos. Since I don't have all the photos, and there will be others coming and going, I thought it would be nice to have a website where they could submit photos and then view a "database" of them. Currently, I have an Infini...

P粉715228019 2024-02-04 11:28:23

Fix PHP image upload issue: replace previous image to upload new image in multiple posts

I'm running into an issue with the image upload functionality of my PHP application. Here's the situation: I have a form where the user can create a post and upload an image related to the post. When I upload my first post with an image attached, everything works fine and the image is saved correctl...

P粉788765679 2023-09-14 11:27:48

Solve problems with gh-pages and the main branch

I'm having some issues with my personal portfolio. Initially, I created my portfolio using githubpages and got a custom domain name, and everything went smoothly with deployment. Recently, I decided to make some drastic changes, which I made on my deployment server in another folder. When I was read...

P粉063039990 2023-08-10 15:15:19

Ways to fix issue 2003 (HY000): Unable to connect to MySQL server 'db_mysql:3306' (111)

I recently tried to containerize my FastAPIPython server (also for replication/doubling purposes). Before, I had just a MySQL server in a Docker container and everything was fine, but when I also made my web server a service, it couldn't connect to the MySQL server, so now the application doesn't wo...

P粉178132828 2023-09-05 11:18:47

Experiment with sorting after query limit

So this is my first question here, please forgive me if something is wrong. I'm trying to make a sort query based on constraints. So there is a Customers table with 90 records. I want to first perform a query limited to 3 records, and then sort the results of this query by a column called ContactNam...

P粉237125700 2023-09-05 14:46:42

CSS Grid: Create new row when child content overflows column width

I have a two column layout based on CSS grid. When the content of the second column exceeds 1fr I want to create a new row. As it currently stands, the content simply overflows the column. One requirement of this layout is that the items in the right menu column are in one row. I achieve this with: ...

P粉212114661 2023-09-05 15:18:28

PHP full text search functionality using AND, OR and NOT operators

Newbie question: I'm trying to implement a full text search on a search string using php and eloquent. $searchstring="+(victimsuspect)+crime-covid";$searchresult=RssItem::whereRaw("MATCH(description)AGAINST('$searchstring'INBOOLEANMODE)")->ge

P粉076987386 2023-09-05 15:06:32

Shortest way to convert all PHP types to string

I'm writing a general system that I hope can one day be applied to fields like medicine (i.e. it's "scientific"). I think the best way is to represent all the data in php with strings (true will be "true", false will be "false" and so on). The reason for this is that in...

P粉369196603 2023-09-05 15:34:44

How to get average of DATETIME column in MySQL while grouping by other columns

I'm creating and populating a MySQL table using the following query: SETtime_zone='+00:00';CREATETABLEtimestamp_n_datetime(idINT,timeDATETIME,avg_timeDATETIME);INSERTINTOtimestamp_n_datetime(id,time,avg_time)VALUES("1","2023-01-0310:

P粉460377540 2023-09-05 11:46:21

Multi-device (mobile phone) synchronization - React Native

I'm trying to create a Lightshow that will launch on all users' mobile devices at the same time (can have up to 2000-3000 users). All users will use the Internet (Wi-Fi or mobile data). In our FE we use Apollo for subscriptions and it works like a charm. But the problem is, user A can get subscribed...

P粉151466081 2023-09-05 11:58:38