Good day
Writing this code there one of the database field is vote - within the javascript i have this parameter called increment votes. When any number is passed through the parameter the votes for that id within the table must be increased by the the parameter amount (or decrease). Got...
Hello everyone, with a friend we make a dynamic website and for collaborate, we make it on replit.com, because we don't find how to create a database in this website.
Did you know how to make it?
(sorry for the spelling, i'm french)
Thank you and good evening.
I'm trying to make a dynamic gallery page for a website.
This code works fine:
<?php
$servername = "server";
$username = "username";
$password = "password";
$dbname = "dbname";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection...
Hello All,
Hoping someone with a little more experience than myself maybe able to help.
I've been stuck on this issue with my code for months now, and it's started hurting my head thinking about it.
Can anybody offer any guidance / advise / anything at all to help me on my way?
-----
I'm...
I've got the html and CSS code for a sign up and login system on a website but I don't know how to then store the information inputted into an SQL database and then retrieve that data when a user wants to login again.
This is the HTML:
<!DOCTYPE html>
<html>
<head>
<title>Sign Up | By...
Hi,
I want to write a program whose input is the names of the companies and when adding the name of each company, it will take various information from that company of different types,
1- TextBox (daily production rate),
2- CheckBox (select product features),
3- OptionButton (the gender of the...
Hi all! I'm conducting an analysis on spending. I'm trying to find how much individual customers have spent every month in the last year. I'm working with transaction data so we only have rows for transactions that actually happened. Therefore, for customer A who only transacted in January...
I've been trying to make a multi user login system but when I try to log on it stays at the login page (index.php) page. What can I do?
index.php
<form method="post" class="form-horizontal">
<div class="form-group">
<label class="col-sm-3 control-label">Email</label>
<div...
I work on sql server 2017 I run script depend on python language v 3.10 .
I need to export data to excel fileStudentExport.xlsx already exist, and keep header without change after export.
header of excel file StudentExport.xlsx before export data to it as below
StudentId,StudentName
after...
I created a view for weekly sales. Everything is working fine on localhost using MySQL.
But when I upload the database on GoDaddy Lag doesn't seem to work.
When I am typing LAG on phpmyadmin, no suggestion is showing. Can anyone help me with this one? Thanks
the structure of vw_sales is...
Can u help with this:
-find an item in the database by entering part of its name
CREATE TABLE Confectionery (
IDConfect INT IDENTITY NOT NULL PRIMARY KEY,
NameProduct NVARCHAR(50) NOT NULL,
Category INT NOT NULL,
Quantity SMALLINT NOT NULL,
Price DECIMAL(20)
);
CREATE TABLE...
I tried uploading my website on 000webhost but I am getting error "Prepared statements needs to be re-prepared."
I search through the internet and found these two solutions: It happens every time I query through views table.
1. Increase table_definition_cache
- The problem is, 000webhost does...
I am just curious as to why others generate unique strings or ID for transactions or orders when they can just use the primary key in SQL.
Is it recommended to generate id like this 111834039007163223, or is it okay to just use the primary key in SQL generated using auto_incement?
I always see...
I have blog page in my website. Whenever I write a blog, I only save the content of the blog, and let the SQL handle the current timestamp.
So my code goes like this:
CREATE TABLE blogs(
blogID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(255) NOT NULL,
content TEXT...
I have a product categories listed in my website. But, I don't want to show categories that has 0 products under it, as you can see in the image below.
Here is my code:
SELECT
c.category AS category,
(SELECT
COUNT(*)
FROM products AS p
WHERE p.categoryID =...
I am new to SQLite and am trying to make a program that creates a database (if it doesn't already exist) then allow the user to input data. When I go to press 'input data' it gives the error "Microsoft.Data.Sqlite.SqliteException: 'SQLite Error 1: 'no such column: CustomerID'.'".
I can use DB...
A repo I just took from my local and made it on github Crucial Resources. Im new to coding and would love some extra input as I know I am missing a lot. I use these daily so feel free to fork or clone and enjoy them.
-Cheers
Crucial Resources
Much like popular online software, we can create scripts that automatically generate database tables.
This comes in handy because it allows the user to simply give us the database name / user / password / host information instead of forcing them to upload an SQL file or manually create the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.