Hi guys, This is my first post and so glad to start sharing the knowledge. I am using Mysql database with VB.NET and I have this code : Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim str As String = "Server=localhost;Port=3306;Database=testdb;Uid=root;Pwd=password" Using con As New MySqlConnection(str) Dim query As String = "select * from testdata where rfid_tag='" & TextBox3.Text & "' and Date_serve<= '" & Date.Now.ToString("yyyy-MM-dd ") & "' and Start_Time<= '" & Date.Now.ToString("HH:mm:ss ") & "' and End_Time>= '" & Date.Now.ToString("HH:mm:ss ") & "' or amount_serve='' " Dim cm As New MySqlCommand(query, con) con.Open() Dim rd …

Member Avatar
+0 forum 0

Sir can you please send me an example to upload an image to the server (with user defined file name and display message if name exist) at specific folder "images" and save its path to the mysql database. And again display the images uploaded on the server folder by using the path which is stored in database. Sir i am able to upload image on server specific folder or the image directly in database in bolb datatype but i become failed to store its path in database and fetch the uploaded image using the path in database. So please guide …

Member Avatar
Member Avatar
+0 forum 6

Hi all, I am very new to PHP and MYSQL and have a class assignment I need help with. I am trying to make a page with an HTML form that will update my MYSQL database. You can view my pages online here: [URL="http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php"]http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php[/URL] I need help with the "Edit" section, if you look online. Here is the code for my Edit page: [CODE=PHP] <?php $hostname = "localhost";//host name $dbname = "baileyjumper_imd203";//database name $username = "baileyjumper_imd";//username you use to login to php my admin $password = "chris4ever";//password you use to login //CONNECTION OBJECT //This Keeps the Connection to the Databade …

Member Avatar
Member Avatar
+0 forum 20

Hi All, As part of a university project I need to create a website that sells cosmetic products. The customer will need to go through the motions of selecting the items, placing them into a basket and going through the checkout process. However I wouldnt need to use a card merchant to process the transaction. customers would also need to sign up and create an online account. I have created simple websites before, with HTML and CSS, but thats it. What development langauges would I need to know other than the two above? I assume PHP and Javascript will be …

Member Avatar
Member Avatar
+1 forum 3

hi all , i have the Following CSV generated by a third party software, i need to be able to read the first row and see what month and year it is. what i would like to do is generate a MySQL Table using the "<monthyear>" so november2018 and place the data into that table. any help would be great .. ' csv File November-04-2018,41,46,18,51 November-04-2018,41,46,28,61 November-04-2018,41,22,48,71 November-04-2018,41,46,58,81

Member Avatar
Member Avatar
+0 forum 1

how to use django web framework

Member Avatar
Member Avatar
+0 forum 1

I see the software to charge credit card swipe, samsung pay, ... I want to find out how the swipe card works and write code to get payment information in the software sales. how ? You can share the code for me with.

Member Avatar
Member Avatar
+0 forum 1

Hi all I have a script to update the value from datagridview to database I do use a button insert ToolStripButton but not working hope people to help thank ! Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load conn = New SqlConnection("") conn.Open() Dim query As [String] = "SELECT * FROM dtaEmployees" da = New SqlDataAdapter(query, conn) Dim cb As New SqlCommandBuilder(da) dt = New DataTable() da.Fill(dt) C1FlexGrid1.DataSource = dt conn.Close() End Sub Private Sub ToolStrip1_ItemClicked(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolStripItemClickedEventArgs) Handles ToolStrip1.ItemClicked Select Case e.ClickedItem.Name Case "ToolStripButton1" '---> button insert da.Update(dt) End Select …

Member Avatar
Member Avatar
+0 forum 7

hello everyone im taking database course this year and it's my first time to take it so i need help how to draw a ERD for following busniess case AND IF there many to many relation how i can establish a new relation ! Entity (Artist ) Attribute : death , DOB, the nationality. ---------------- Entity (museum ) Attribute: location , specialty . --------------- Entity: (paintings) Attribute: size of canvas, year of painted, tittle , style ----------------- Relation between Artist and paintings : Paint Relation between paintings and museum : Display An art researcher has asked you to design a …

Member Avatar
Member Avatar
+0 forum 1

Hello! I have a problem with a MySQL database that I haven’t been able to solve no matter how much I tried, either with internet guides or with free tools. I really don’t want to pay hundreds of dollars to a company so please, if anyone knows of a solution, help me because I’m desperate. I was running XAMPP 7.1.22 where I had said database and I decided to install XAMPP 7.2.10 without backing up the database. After that, the site wasn’t working so I figured the problem was the database. And indeed PHPMyAdmin wouldn’t recognize it. I reinstalled the …

Member Avatar
+0 forum 0

Hi, In my application two fields are the user id and user name,i want to show the user name and user id along with other details in a html table. user id is a numeric dropdown menu and user name is text only.How can i show the specfic record in that table for that user which i have selected in both of the fields ,how i can fetch data from backend User table?am using html,css and javascript, Any suggestion would be grateful!Thanks..

Member Avatar
Member Avatar
+0 forum 1

<html> <head></head> <link rel="stylesheet" type="text/css" href="style.css" <body> <?php $db = mysqli_connect('localhost', 'root', '', 'formdb'); $formId = ''; $LastName = ''; $FirstName = ''; $Email = ''; $Birthday = ''; $Birthplace = ''; $Comment = ''; if (isset($_GET['upd'])){ $formId = $_GET['upd']; $results = mysqli_query($db, "SELECT * FROM tbl_form WHERE formId=$formId"); } if(isset($_POST['submit'])) { $formId = $_POST['formId']; $LastName = $_POST['LastName']; $FirstName = $_POST['FirstName']; $Email = $_POST['Email']; $Birthday = $_POST['Birthday']; $Birthplace = $_POST['Birthplace']; $Comment = $_POST['Comment']; $query = "UPDATE tbl_form SET LastName='$LastName', FirstName='$FirstName', Email='$Email', Birthday='$Birthday', Birtplace='$Birthplace', Comment='$Comment' WHERE formId='$formId'"; mysqli_query($db, $query); $_SESSION['msg'] = "Successfully Updated!"; header('location: form.php'); //redirect after inserting } ?> <?php …

Member Avatar
Member Avatar
+0 forum 1

Hello, I can't display images from database. I have folder called "images" next to index.php where I keep images. I suppose I have wrongly defined folder path with images or sth else. <?php $connection = new mysqli("localhost", "root", "", "crud"); $sql = "SELECT * FROM test"; $res = $connection->query($sql); if(@$res->num_rows > 0) { while($row = $res->fetch_assoc()) { ?> <img src="<?php "C:/xampp/htdocs/img_mysql/images/".$row['image'] ?>" style="width:170px;height:120px" /> <?php } } ?> I put picture with how look my website when I try display images. ![011.jpg](/attachments/large/4/cb5cff474c596085beba1a63f9b6c6b6.jpg "align-center")

Member Avatar
Member Avatar
+0 forum 3

i am creating an app with android studio and i'm using mySQL.and i want to implement friends feature in my app to enable users send and recieve friend requests, i have created tables and writen the server side php code for that, i have also created an add as friend button that should do that in my app but i'm still unable to write the appropriate code for that in android.your help with this will be highly appreciated.

Member Avatar
Member Avatar
-2 forum 3

Hi, i have a plugin called wp deposits and a template called automotive, i need the client to be able to pay a non refundable fee of 5% which is working fine through wp deposits, the thing is wp deposit is picking price from woocommerce, i want it to pick from another table, or i want woocommerce to get products from another table e.g. the prices should come like, select price from another_table where guid=$_GET['guid']; EDIT: I am new to woocommerce, i have tried researching but havent gotten any resource to help,i went through almost all pages in woocommerce but …

Member Avatar
Member Avatar
+0 forum 4

Hello i have a project that uses firebase but i want to make connect to my MySql database on xampp. Any idea what to do?

Member Avatar
Member Avatar
+0 forum 1

hi! I want to create a procedure which execute given below query using dynamic sql. i am getting some error i.e. "Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'GROUP'." my query which i want to run by procedure is: ;with cte as (select *,t.opening+Recieve+returnback-Issue as balance from(SELECT p.trandate,p.voucherno,p.itemno,p.itemname,isnull(O.opening,0) opening,SUM(isnull(p.recieve,0))over(partition by p.itemno order by trandate ) Recieve,SUM(isnull(p.issue,0))over(partition by p.itemno order by trandate ) Issue,isnull(p.returnback,0) Returnback,ROW_NUMBER() OVER (Partition BY p.itemno Order by p.itemno,p.trandate) Row_Num ,O.opening as openingoriginal FROM (SELECT p.trandate,p.voucherno,p.itemno,p.itemname, SUM(isnull(p.recieve,0)) Recieve,SUM(isnull(p.issue,0)) Issue,SUM(isnull(p.returnback,0)) Returnback FROM ledgertable p GROUP BY p.itemno,p.ITEMNAME,p.trandate,p.voucherno) p LEFT JOIN openingstock20172018 O ON …

Member Avatar
Member Avatar
+0 forum 7

Hi Every Body i have a server and a numbers of clients and i when i want to open a page on the clients machine it is open in the server insted of the specified client machine. i am using host to open the required page and i am trying to use web.show_document but it is not working. i am using oracle developer 10g Any help please?????? thankyou very much

Member Avatar
Member Avatar
+0 forum 1

<?php $db = new Db(); $mysqli = Db::$_mysqli; if (isset($_POST['name'])) { $name = escape($_POST['name']); $email = escape($_POST['email']); $phone = escape($_POST['phone']); $password = escape($_POST['password']); $result = array(); /*check email is unique*/ $email_num = $db->GetNum("user","email='$email'"); if ($email_num == 0) { /*insert into database*/ $md5password = md5($password); $insert = $db->Insert("user","'','$name','$email','$phone','$md5password'"); /*success*/ if ($insert) { $result['type'] = "success"; $result['message'] = "Your are Register"; /*login the user in*/ session_start(); $_SESSION['id'] = mysqli_insert_id($mysqli); }else{ /*error*/ $result['type'] = "error"; $result['message'] = "Error Please Try again."; } }else{ $result['type'] = "error"; $result['message'] = "Email Already Register <span class='text-bs-primary'>Please Login</span>"; } if(!$error) { $sql="select * from user where (name='$name');"; …

Member Avatar
Member Avatar
+0 forum 2

This the code in products <?php require_once("inc/header.php"); require_once("inc/navbar.php"); /* if user is logged in then only allow the user to view the page */ if (!isset($_SESSION['id'])){ echo "<h1 class='text-center text-upper text-bs-primary'>please login to view your cart <a class='text-black' href='login.php'>Login</a></h1>"; exit(); } else{ $user_id = $_SESSION['id']; } $carts = $db->FetchAll("*","cart","user_id='$user_id' AND active='y'","`id` DESC"); if (empty($carts)) { echo "<h1 class='text-center text-bs-primary text-25 text-upper'>your cart is empty <a class='text-black' href='products.php'>Go Shop</a></h1>"; exit(); } ?> <div class="container padding-10"> <div id="cart-container-main"> <div class="text-center text-20 text-bold" id="cart-message"></div> <table class="table"> <th>Product image</th> <th>Product detail</th> <th>Price</th> <th>Tax</th> <th>Subtotal</th> <th>Remove</th> <tr> <?php $cod= 0; $main_subtotal = 0; $main_shipping_charge = …

Member Avatar
+0 forum 0

Hello friends, I want to develop a online typing tutor using codeigniter......for hindi language (typing in computer with the help of **hindi indic 3** or** hindi indic 2 typing tool**) .......i know the php and codeigniter with css.....please give me guidance to develop it......what language i need to learn.....and how can be typing using these tool............. how many days will it take to learn............

Member Avatar
Member Avatar
+0 forum 4

I have a data file called Access 2003 Table The question "TABCAUHOI" has the following fields: ID int; NOIDUNG memo; The "NOIDUNG" field has data type as memo, I pour data from excel text file into this table in this access file to check the contents are full as excel file, in C # I query read data into DataTable dt = query 1 message of a content, when debugging Debug.Print (dt.Rows [0] ["NOIDUNG"]. ToString ()); Only get 255 characters in the first string, characters after 255 characters later lost, want to get everything into the DataTable how to do …

Member Avatar
Member Avatar
+0 forum 2

Below is my code for adding parameters in my vb .net code for prepared statements of npgsql. Dim xConn As NpgsqlConnection = ConnectDB() Dim xCmd As NpgsqlCommand = xConn.CreateCommand() xCmd.CommandText = "UPDATE " & xTable & " SET previous_tot_adj = @prev_adj ,tot_adj = @tot_adj WHERE version = " & _version & " AND monthly_mq_id = @Index" For Each Index In _Results.Keys If Not IsNothing(_Results.Item(Index)) Then xCmd.Parameters.AddWithValue("prev_adj", NpgsqlTypes.NpgsqlDbType.Double, _Results.Item(Index)) xCmd.Parameters.AddWithValue("tot_adj", NpgsqlTypes.NpgsqlDbType.Double, _Results.Item(Index)) xCmd.Parameters.AddWithValue("Index", NpgsqlTypes.NpgsqlDbType.Bigint, Index) End If Next xCmd.Prepare() xCmd.ExecuteNonQuery() After executing this code i get this kind of error . > A first chance exception of type 'Npgsql.NpgsqlException' occurred in …

Member Avatar
Member Avatar
+0 forum 2

hey guys, I already have a database that can add a person with the RFID card number, I just want a little help of you guys if how can I code the rfid and when I tap the card, the RFID# of that person will be there together with the name, time and department of that person.? Example if tag name is 00123456 (Thats my rfid card# saved to my database) if I tap the card to the RFID reader, the FORM should show that this TAG belongs to me showing my details) Please help me, I'm doing this for …

Member Avatar
Member Avatar
+0 forum 1

I want to print the username on jsp page"**success.jsp**" from "**home.jsp**" i have used **hibernate** to save data in table . "home.jsp" <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Insert title here</title> </head> <body> <center> <h1 ><font color="red">User-Interface</font></h1> <form action=loginServlet method="post"> <table border="1" bordercolor="red" style="border-style: dotted;" cellpadding="5px" cellspacing="10px"> <tr> <td>UserName:</td><td><input type="text" name="username"></td> </tr> <tr> <td>Password:</td><td><input type="password" name="password"></td> </tr> </table> <input type="submit" value="Log-In" > </form> New User?<a href="register.jsp"> Register Here</a> </center> </body> </html> success.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> …

Member Avatar
+0 forum 0

SELECT SUM([BTL].dbo.OrderTable.Quantity) AS 'Totalquentity',Count(BTL.dbo.OrderTable.OrderID) as TotalOrder FROM [BTL].dbo.OrderTable JOIN [BTL].dbo.Products ON [BTL].dbo.OrderTable.ProductID=[BTL].dbo.Products.ProductID Left JOIN [BTL].dbo.Brand ON [BTL].dbo.Products.BrandID=[BTL].dbo.Brand.BrandID WHERE [BTL].dbo.OrderTable.EmployeeID='1' Group by [BTL].dbo.Brand.BrandName,[BTL].dbo.Brand.BrandID" I Want to get avg

Member Avatar
Member Avatar
+0 forum 2

Hey everyone i am just asking for a little bit off help if thats fine how can i make 11 fetch scripts into 1 script please [database ](https://i.imgur.com/BTGQF1P.png) i like to make this menu to display the coins i know you can do it but i dont know how since am not pro <ul class="nav nav-pills mb-3" id="pills-tab" role="tablist"> <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" data-toggle="dropdown" href="#" role="button" aria-haspopup="true" aria-expanded="false">Pick a coin</a> <div class="dropdown-menu"> <a class="dropdown-item" id="pills-btc-tab" href="#pills-btc" role="tab" data-toggle="pill" aria-controls="pills-btc"><img src="https://i.imgur.com/h2bZxBg.png" width="23" height="23"> Bitcoin</a> </div> </ul> fetch from mysqli i have btc here but i like to get every …

Member Avatar
+0 forum 0

Hi, I am a legacay (cobol) developer and wants to learn how to build websites. For this I decided to do a little project for myself. The site would be a places/travel tracker kind. It would show a certain map (ex, London, Taiwan, Greenland). Then you can click on a city on the map which will show pictures/videos/comments of you in that city. Map changes color for the city you have visited or maybe a pin. I have search the web and mostly there are world tracker. I would want a country based one. So my questions are: 1.) What …

Member Avatar
Member Avatar
+1 forum 4

How do I process the xamarin forms that connect to SQL Server and export data to the listView ? I'm looking for this simple example. What do I find on google ?

Member Avatar
+0 forum 0

I have db table called **subscription** and a column called **duration**. I want the column** duration** to be incremented by +1 in every 24 hours until it gets to 30 then stop. I would love the query to start execution if the column duration is = 1.

Member Avatar
Member Avatar
+0 forum 5

The End.