I am creating a registration form. Next to it is a table in which all existing and saved data records are displayed in the database. Registration in the database works.
To create the table, I have a file & # 39; listar_usuario.php & # 39; created in which I use my & # 39; server.php & # 39; connect (connects to the database). This file retrieves the data from the database and creates a table. because when I type it in, I can see the table, but when I call it for my registration form it doesn't come, the space it should take is just empty.
I have no idea what it could be, could someone help me?
REGISTRATION IF NO REGISTRATION
REGISTRATION AFTER ADDING A REGISTRATION
(The warning disappears and does not create the table.)
However, the table is created
MY REGISTRATION CALLING THE TABLE
Code that retrieves DB values and creates the table (listar_usuario.php)
Nenhum usuário encontrado!
Create database db;
create table login(
int(11) not null auto_increment,
usuario varchar(30) NOT NULL,
senha char(32) NOT NULL,
create table clientes(
codcli int(4) not null auto_increment,
nomecli varchar(35) NOT NULL,
emailcli varchar(50) NOT NULL,
telefonecli char(11) NOT NULL,
cpfcli char(14) NOT NULL,
I have a text with several phrases one below the other and have to process each phrase differently. I wanted to open a tag (eg 🙂 and want the text editor (vscode) to automatically close this tag "at the end of sentence. Question 1: Is there or can I add a link to close the tag at the end of the line after the sentence? Question 2: Is it possible to set conditions using words or letters so that the tags are created at the beginning and end of each sentence?
Example text with phrases:
The most important thing is not to win every day, but always to fight.
The shame of not having fought is greater than the sadness of not having won!
It's better to conquer yourself than to win a thousand battles.
Those who dared to conquer and fight go on!
As long as there is a will to fight, there is hope to win.
Note: If I had a way to create a rule that uses the word ex: "battles", create a day in the line at the beginning and end of the sentence.
Hello, I'm learning Symfony and trying to use AbstractController. I am getting the following error message
"An attempt was made to call an undefined method with the name" getName "of the class" App Controller TestController ".
If I don't use the "Extended AbstractController" and for example use "Extend Bundle" and change the return for which it is commented, the code works. I generate it on error when I change the extension.
I am guided by the Symfony documentation
I leave the code:
src / Controller / TestController.php
Hello, I'm showing a report to show customers over 60 years old.
Like me No I have a field idade in bd i had to "discover" it by the date of birth and did it like this:
SELECT TIMESTAMPDIFF(YEAR, data_de_nascimento, CURDATE()) as idade FROM clientes
Now I have to show off selectwhat I just want to show who is older than 60.
I tried to sit down WHERE idade >= 60 however, it didn't work.
I'm trying to compare Date of birth with the year of 1960 (2020 – 1960 = 60), but I want to get that Day and the current month, so that I don’t have to keep changing and doing an "error-free" search, but I can’t …
I try it like this:
WHERE data_de_nascimento <= '1960-Month(data)-Day(now))'
I would like to create a PHP site for each of my deliverers showing orders for them. I use such a query to display orders:
p.ID as order_id,
max( CASE WHEN pm.meta_key = '_billing_email' and p.ID = pm.post_id THEN pm.meta_value END ) as Mail,
max( CASE WHEN pm.meta_key = '_billing_first_name' and p.ID = pm.post_id THEN pm.meta_value END ) as Imie,
max( CASE WHEN pm.meta_key = '_billing_last_name' and p.ID = pm.post_id THEN pm.meta_value END ) as Nazwisko,
max( CASE WHEN pm.meta_key = '_billing_postcode' and p.ID = pm.post_id THEN pm.meta_value END ) as KodPocztowy,
max( CASE WHEN pm.meta_key = '_shipping_first_name' and p.ID = pm.post_id THEN pm.meta_value END ) as Imie,
max( CASE WHEN pm.meta_key = '_shipping_last_name' and p.ID = pm.post_id THEN pm.meta_value END ) as Nazwisko,
max( CASE WHEN pm.meta_key = '_order_total' and p.ID = pm.post_id THEN pm.meta_value END ) as Suma,
max( CASE WHEN pm.meta_key = '_paid_date' and p.ID = pm.post_id THEN pm.meta_value END ) as Zaplacono,
( select group_concat( order_item_name separator '|' ) from wp_woocommerce_order_items where order_id = p.ID ) as Zamowiono
wp_posts as p,
wp_postmeta as pm
post_type = 'shop_order' and
p.ID = pm.post_id and
post_date BETWEEN '2020-01-01' AND '2021-07-08'
And I use this query to display my categories
LEFT JOIN wp_term_taxonomy
ON wp_terms.term_id = wp_term_taxonomy.term_id
WHERE wp_term_taxonomy.taxonomy = 'product_cat'
How can I join these two queries to only display orders from certain categories such as clothing, etc.?
I am implementing a customer catalog in my program, but am unable to get the information necessary to view it. The database I'm using is on a server. So I use PHP to do my queries. From PHP I send a JSON to my program and this transfers the JSON to a gridControl (dvexpress). I ran all of the previous catalogs using the same method, but in this case something happens and I can't display all the information I need because when I go to the "Status" column of the database all JSON are automatically stopped, there is no exception, nothing , it just empties, but when I remove the "Status" column from the query, everything works as if nothing, I need help
The "State" column name is copied and pasted from the database so the name is not the error. The SQL is not the fault either. If I copy and paste it into phpmyadmin, it works perfectly and cannot be found. What can the error be and my program is not the error either, because if I have the error, I only get an empty argument like the following: ""