[sql] Forum Topics

I need help..Even after doing extensive research and youtube videos.. I can't seem to get this. This is just for a hypothetical situational based project i'm doing to demonstrate the functionality of storing fake credit card info in a mySQL database from a PHP file. The goal is: Once a …

Hello. I am trying to check if a table definition (the default value on a constraint) is equal to UTC Time by using the following query: IF NOT EXISTS((SELECT object_definition(default_object_id) AS definition FROM sys.columns WHERE name = 'ModifiedDate' AND object_id = object_id('dbo.WorkflowAudit')) == GETUTCDATE()) However, you can not compare a …

Hi all. i have a trouble of my testing project. could anyone can guide me to solve the problem. million thanks~~ newbie of programming. error : System.Data.SqlClient.SqlException: 'Incorrect syntax near 'card'.' string connectionstring = ConfigurationManager.ConnectionStrings["library2ConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionstring); con.Open(); string sql = "Select librarycardid, password" + "from library …

Need suggestion! wix or wordpress give me both details

$sql = "SELECT cl_id, cl_name, cl_service_description, cl_contact, cl_dept,status, expiry_date from contract_list"; $result = $conn-> query($sql); if($result->num_rows > 0) { while($row = $result-> fetch_assoc()) { echo "<td>$row[cl_id]</td>"; echo "<td>$row[cl_name]</td> "; echo "<td> $row[cl_service_description]</td>"; echo "<td>$row[cl_dept]<td>"; echo"$row[status]"; echo "<td>$row[cl_contact]</td>"; echo "<td>$row[expiry_date]</td>"; echo "<td></td>"; echo "<td><div class=table-data-feature>"; echo "<button class='item' data-toggle='tooltip' data-placement='top' title='send'>"; …

I want to be able to write an SQL statement that pulls the sum of revenue and expenditure for each day and gets net income for each day with the distinct dates available in the Income and Expenditure tables. I have tried the following statement, but I'm not getting the …

Hello I have VB.NET System ; I wanna to make setup (.exe) for the program. The Program depend on SQL Server Database. How I can make it exe file with the database, and to install all the configuration on any PC. What I shall do according to the connection string …

Illustrate a database for the video club using a recent video club entities

How much can it cost to create a social network in the web?

<?php $name = $email = $password = $repeatpass = ''; $name = $_POST['name']; $email = $_POST['email']; $password = $_POST['password']; $repeatpass = $_POST['repeatpass']; $con = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $sql = "INSERT INTO user-regis (name, email, password, repeatpass) VALUES ('$name', '$email', '$password', '$repeatpass')"; $result = $con->query($sql); if (!$result) { header("Location: …

<?php require_once './includes/config.php'; $con = new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME); $sql = "SELECT * FROM contact-info"; if($result = $con->query($sql)){ while($row = $result->fetch_object()){ //display record 1 by 1 printf(' <tr> <td>%s</td> <td>%s</td> <td>%s</td> <td>%s</td> <td>%s</td> </tr> ',$row->id, $row->name, $row->email, $row->phone, $row->comment); } } printf(' <tr> <td colspan="5"> %d record(s) returned. [ <a href="insert-student.php">Insert Student</a> …

I have an access Database with Chinese and German words. How can I had their audio prononciation wich I get from Forvo or Google translate?

hi i just came here if theres someone who coudl help me with my problem whenever i add a new user this keeps on appearing\ "INSERT INTO teacher_info (firstname,middlename,lastname,gender,address,date_joined,username,password) VALUES ('John','Doe','Doenut','Male','New york USA','2021-06-11','john','admin') Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of …

i need to show the image displayed in database but it shows default image <?php $link = new PDO("mysql:host=localhost;dbname=campusdrive", "root", ""); $link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $Sql = "SELECT Image FROM student_form WHERE Sessionid = :Sessionid"; $stmt = $link->prepare($Sql); $stmt->bindParam(":Sessionid", $sessionid, PDO::PARAM_STR); $sessionid = session_id(); $stmt->execute(); $count = $stmt->fetchAll(); if($users = $stmt->fetchColumn()){ echo …

Hello , i am using free 3 of 9 barcode to create a bar code of each student in my DB , the problem that in my card it is not shown as it is supposed to be but as *98777*  so any one knows how i can solve …

Hi guys. I have just created an intranet in my online store and I'm new at programming so need some help. I'm developing a system that makes this possible: when a user registers, the database detects that they are already a customer who has bought previously and it makes their …

Hello , mu website objective is to some kind of reposrts the problem when i retrive for example the people in my dtabase under specific age the grid view does not show me all of them i have googled this problem and i found that it can not retrive more …

Hello , i am creating new website using asp net and c# .. what i am basically doing is that i have somedata in my database and will let the user show them in report based on what he is gonna choose to display for example i have in my …

Create a table with following rules and regulations ma 1)Id should b identity 2)Name should allow only starting Letter with a to p 3)city should not allow Chennai,cbe, Salem 4) department should allo only cse,it,ece, 5) college default should b anna university 6) per should above only 70% 7) year …

Hello, so as the title says, I'm looking to include a Session Variable into a MySQL Update statement. I'm not exactly sure what I'm doing wrong, but I certainly know I am. I'm also fairly new to this, so that may explain it lol! Thanks in advance for your help. …

Hi. I have a question. So, I'm registering a user, but a table is created for me (empty), and I can't figure out how to save my data when registering in the database? I tried to write various functions, but I failed. Below I send the code: Users.cs: using Microsoft.AspNetCore.Mvc; …

Hi its Huzaifa From Pakistan! i am a designer (web and graphic). want to learn **programming**

How can I save the registration data after connecting to the database (an empty table is created for me)? I do this in Blazor (C #). User.cs: [Table("Users")] public class User { [Display(AutoGenerateField = false)] public int UserId { get; set; } [Display(Name = "UserName")] [Required(ErrorMessage = "UserName is required.")] …

Find product who hasn't had any sales in first three months of the year?

Hello Everyone! I'm curious on how much should I charge my client to maintain his website? updates, few changes. I am new to this job, so I am not sure how it works, i'm a freelancer. Website Information : 1. Wordpress 2. They have template already, and information on their …

I am new to web development but I want to enhance my skills, so please be nice to me. I build a blog already, using wordpress, but is there anyone here build a website for an artist/actor before? Like, for real? Because i knew, we have a copyright for images, …

In my workplace, we have an intranet website developed internally that we use for CRM. The data of our clients are shown there (MS SQL server is used as a backend to store data). The site has a limited search functionality at the moment (it'll try to match the text …

I have three tables: First table is 'user': user_id | Name | ---------------------- 1234354 | Abu Bakar | 2543353 | Ali | 3342342 | Aliza | 4234243 | Ali | 5234324 | Mike | Second table is 'meeting': meeting_id | meeting_name | meeting_startDate | meeting_endDate | room_name | ---------------------------------------------------------------------------------- 1 …

I need help for my code after the user done register for their new account in my system. Here is the verification link that the user will receive via email for him/her to verified the email: `http://localhost/staff/email_verification.php?activation_code=49024f2e7b8c05dc1g66005g780g6060 ` But, when the user click on above link, I notice based on …

Hello, I want to use the checkbox to update the status of a row in mysql using php. If it is checked and submitted, the status will change from 'collect' to 'received'. I tried many ways but I am not sure where the problem is :( please help! <?php include(config.php); …