use these codes to fix the invoice: USE pharmacy; -- Ensure the invoices table exists CREATE TABLE IF NOT EXISTS invoices ( INVOICE_ID INT AUTO_INCREMENT PRIMARY KEY, CUSTOMER_ID INT NOT NULL, INVOICE_DATE DATE NOT NULL, TOTAL_AMOUNT DECIMAL(10, 2) NOT NULL, TOTAL_DISCOUNT DECIMAL(10, 2), NET_TOTAL DECIMAL(10, 2), FOREIGN KEY (CUSTOMER_ID) REFERENCES customers(ID) ON DELETE CASCADE ); -- Ensure the customers table exists CREATE TABLE IF NOT EXISTS customers ( ID INT AUTO_INCREMENT PRIMARY KEY, NAME VARCHAR(255) NOT NULL, ADDRESS TEXT, CONTACT_NUMBER VARCHAR(15), DOCTOR_NAME VARCHAR(255), DOCTOR_ADDRESS TEXT ); -- Ensure the sales table exists and correctly references invoices CREATE TABLE IF NOT EXISTS sales ( ID INT AUTO_INCREMENT PRIMARY KEY, INVOICE_ID INT NOT NULL, MEDICINE_NAME VARCHAR(255) NOT NULL, EXPIRY_DATE DATE NOT NULL, QUANTITY INT NOT NULL, MRP DECIMAL(10, 2) NOT NULL, DISCOUNT DECIMAL(5, 2), TOTAL DECIMAL(10, 2) GENERATED ALWAYS AS (QUANTITY * MRP) STORED, FOREIGN KEY (INVOICE_ID) REFERENCES invoices(INVOICE_ID) ON DELETE CASCADE );
@JoshuaOluchukwu-pg5xw4 күн бұрын
Note in your database(sql)
@admasinfotech37456 күн бұрын
its big idea for me but not functional add homes why
@poojapoojadhapte14307 күн бұрын
Yes login
@valarmathi536614 күн бұрын
Sir send the coding
@madhurim477514 күн бұрын
we are getting this type of error how to solve this pls help us bro 🙏 Fatal error: Uncaught Error: Call to undefined function mysql connect() in C:\xampp\htdocs gan admin index.php:9 Stack trace: #0 (main) thrown in C:\xampp\htdocs gan admin index.php on line 9
@divyanshtripathi428016 күн бұрын
Very nice!!
@simrankaur122816 күн бұрын
Thankyou So much for your guidance
@Ritika8004417 күн бұрын
Hlw pls help mw
@nayanaha-ty3gy18 күн бұрын
Any one to send this project report
@daakyeheneqwadjoamankwahmi73518 күн бұрын
Can i get the sourcecode?
@akashachchu57519 күн бұрын
thanks bro .......im happy
@1nonly_chandu56020 күн бұрын
can you say where do u got data set for the project
@oneinall666727 күн бұрын
er diagram of this
@Unicornbytes891927 күн бұрын
Password sir for logging in ??
@CDCWebAdminandMaintenanceTeam28 күн бұрын
Can you please help me, what is the password for admin ? I just can't log in
@sushilkanchagar354229 күн бұрын
YOU IMPLEMENTED THIS I WHICH PLATFORM
@Sandhya_96Ай бұрын
if i submit..its not opening into new tab..its showing error
@papope4203Ай бұрын
Thank you very much sir/miss, you help me a lot
@vikashop5219 күн бұрын
mera forbidden error aa raha kese solve karu
@sonalinandgauli9323Ай бұрын
thank you
@akbeautycreative8511Ай бұрын
Full fuck where to take attendence?? Waste of time don't download it
@AbhishekraddiMaraddiАй бұрын
Asign mark is not working
@EllenGweraАй бұрын
I need code
@user-nl1qf7wf8mАй бұрын
when you add a student or something it does not show up
@pavithrac9507Ай бұрын
Please can you provide complete tutorial of this project
@jeevikathadur7433Ай бұрын
I am not able to register in the webpage,,, anyone give me the solution for this
@mr_tharindu_dasanthaАй бұрын
Thank you so much
@preethisc6376Ай бұрын
Hello Can I know on what basis we have to enter tax slab???
@jishajisha348Ай бұрын
Url not found error. Please reply
@deltalearning5817Ай бұрын
this is a baler video, please do not watch it.
@suporteinformaticaАй бұрын
I've already done the test, vote, choose 2 all together, direct shipping, but I want to vote once, limit, choose a president where is the PHP code?
@creations_2944Ай бұрын
Bro I got a error
@mw1076Ай бұрын
Can I use this editor in my website made by WordPress?
@mdanishour8914Ай бұрын
username and password not active
@manishvr77652 ай бұрын
Unable to update in admin panel and also you didn't provide notepad with username and passwords
@Oreo890-ih1jn2 ай бұрын
the source code and the cmd isn't the same bruh
@amulyashivakumar28542 ай бұрын
I am getting an error like URL was not found on this server
@JendX122 ай бұрын
Helo sir,ineed help
@user-oh9ld3hg3v2 ай бұрын
Sir this project available in react + MySQL...
@patricksamba96202 ай бұрын
a good project but no way to sign in, the password and username doesn't work. Please provide a good password and username. Your username admin and password admin doesn't match
@muhammadyasser17992 ай бұрын
Love it ♥️
@crazyfacts62712 ай бұрын
Is bootstrap used?
@srikanth123451002 ай бұрын
I want javascripts bro for tatkal booking i will pay
@proflead2 ай бұрын
Python is so powerful!
@sayedmuskan24252 ай бұрын
Sir i found this kind of error while running the code can you please help me as soon as possible Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\Crime-Reporting-System egistration.php:5 Stack trace: #0 C:\xampp\htdocs\Crime-Reporting-System egistration.php(5): mysqli_connect('localhost', 'root', Object(SensitiveParameterValue), 'crime_portal') #1 {main} thrown in C:\xampp\htdocs\Crime-Reporting-System egistration.php on line 5
@AhmedouElkhaim2 ай бұрын
Erreur on Line 6 Mysql_query()
@rebornmonteiro102 ай бұрын
Hiee
@haskanovic59302 ай бұрын
How to change a title system
@filmarteballena2 ай бұрын
What is the module name you use?
@mwaqas62922 ай бұрын
how to customize script this project accroding to today