[database] Forum Topics

i have below stuff an i write each result in excel sheet . i have an issue to write in excel sheet of each sql result drop table #table_Northwind create table #table_Northwind ( RowID int not null identity(1,1) primary key, column_name varchar(50) ) insert into #table_Northwind (column_name) (SELECT TABLE_NAME FROM …

I'm trying to authenticate to Sharepoint site i've made (it has a list with 2 items in it), i need to print its title to the console - really simple approach. with OfficeDevPnp.Core Nuget installed i tried the AppOnly following code: public static void AppOnlyAuthCall() { using (var clientContext = …

is having created a webpage using Html and css the page is laidout (has header, side panel, main content area and a footer) as well as (a table of appx 2 by columns and rows); I will create a very small SQL table with data; BUT how do I transfer/export …

I think RPA is independent as it's about automation. Which is fine if you're a factory drone. But it doesn't work for today's generation of workers, who are used to being treated with a little more respect to feel empowered about doing a job they believe in. The real future …

I am working on search API. Currently I am havinng 3 filter i.e. author, publish date, topic. Now I have created a Search API along with paginantion. based on request data it provides result (default page size is 10 for pagination). Now I want to acheive following. Whenver I change …

Hi i am david from philippines, im here asking for help my teacher ask us to do a system which allows monitoring and billing using vb. But the system i want to do is a token base arcade system with timer pause button add token stop time and many more …

I'm making a movie website and want to make the limit of movies for example 10 per page but every pagination tutorial or guide I find shows only how to do this with lists, I want to do this with cards so it looks like it does on other movie …

<?php if (isset($_POST['submit'])) { session_start(); include('connection.php'); $email = mysqli_real_escape_string($conn, $_POST['email']); $password = mysqli_real_escape_string($conn, $_POST['password']); $hash_password = md5($password); $sql = "SELECT * FROM users WHERE email = '$email' AND password = '$hash_password' "; $result = mysqli_query($conn, $sql); $row = mysqli_fetch_array($result); if ($row['email'] == $email && $row['password'] == $hash_password) { echo '<script …

Any programming language or software that can help in database design and manipulation

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 …

## Introduction ## One of the best debugging tools in Android Studio is the *live database inspector*. It allows developers to peek at the current state of the database and even run queries against it. In this tutorial, we will learn how to use it to debug a local SQLite …

Hi, below is the code in my login button, yet I'm confused what code to put in logout button. I only know few knowledge about vb.net and I am trying to understand it as much as I can. Thank you for understanding! :) Public Class Form2 Private OPConStr As String …

Hi guys im trying to do a Login system in Wpf with Visual Studio I got the code and DB working fine with Windows Forms in Visual Studio I have changed the code 3 times and they all work on Windows forms but not with Wpf Forms. Below is the …

how to convert this into relative path code, since if im gonna install my system to other computer this line of code will get an error since the path of the data source doesnt match the current path if im gonna install it to other computer 

hello i am new to the coding world and i am trying to get this login code to only accept the names and passwords in the access database, current any can login. please assist Imports System.Data Imports System.Data.OleDb Imports System.Data.DataTable Public Class Form1 Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal …

I wish to read from a closed excel file, a few years ago I found a website using ADO and it worked but now I cannot find this website I have tried over 100 with no success please help Ernest

i need code for insert multiple rows into database please help me

hello i'm trying to schedule event from mysql in node js i know how to execute query (connection.query("select * from test") but how to do that in nodejs --------> CREATE EVENT IF NOT EXISTS reurring_event ON SCHEDULE EVERY 1 MINUTE STARTS CURRENT_TIMESTAMP ENDS CURRENT_TIMESTAMP + INTERVAL 1 minute DO INSERT …

i made a little crm app that has the Entities : Contact, Campus, Sub Campus, the contact has lookup fields for campus and sub campus. (each sub campus is related to only one campus) im supposed to make a plugin in C# that on contact creation it fills the campus …

I have a problem to do price data and i don't know to insert it into the coding this is question  this is the coding that i have made <?php $page_title = 'Yoho Express!'; include ('includes/header.html'); ?> <form action="q2.php" method="post"> <p><h1><fieldset><legend>Enter your information in the form below:</legend></p></h1> <p><b>Departure day:</b> …

Good morning, i have a section in a php page as per code: <div class="container section" id="afterHeader"> <div class="row"> <div class="tabs movies"> <a class="style1">1^ WEEK</a> <ul> <li><a href="#thu">GIO</a></li> <li><a href="#fri">VEN</a></li> <li><a href="#sat">SAB</a></li> <li><a href="#sun">DOM</a></li> <li><a href="#mon">LUN</a></li> <li><a href="#tue">MAR</a></li> <li><a href="#wed">MER</a></li> </ul I would need to replace the part <ul> </ul> …

I have learning this from youtube,php quiz using ajax. I am facing problem when click on next button after last question it is not redirecting on final page. Please help me to fix this. I think responseText not working. Question.php page to where i display question <script type="text/javascript"> var questionno="1"; …

Iam a travel agent planing to start a OTA, so i need some information about travel technology partners and their benefits.

I am a travel agent, I need information about how to get access to NDC content.

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 …

Hi. I got some problem. I want to search data from 2 tables in database and display the result based on the search value. For example, I search employee id number, it will search the employee id number in table 1 and table 2. If the data exist in either …

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 …

> Hi, This little program checks to see if the contract is valid. I have a database field "expiry" (int 3) from which 1 is subtracted when run. As long as the expiry is above 0 I want to redirect to "sysnav.html", otherwise I want to redirect to "expiredpage.html". I …

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 …

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 …