Hi All Brothers I am working on ERP system and i need one help I wrote code for Datagrid auto complete. this code is working perfect but it only showing one Column record from database what i need is i want first column is to autocomplete as i did and it should fill related columns automatically linked with first column. please guide me with Codes many Thanks My Code Dim strConn As String Dim da As SqlDataAdapter Dim conn As SqlConnection Dim ds As New DataSet strConn = ("Server= DESKTOP-QN6F623; Database = stock_in;Integrated Security = false;User ID=dis;Password=0m3rP@ss") conn = New …

Member Avatar
Member Avatar
+0 forum 3

I am using web server as LIGHTTPD....database as sqlite3....And php.. I made my flash memmory of nanopi as readonly(in fstab). while content listing from database to web page it is showing only limed amount of data( for example...in a webpage i am given to list 55 records.but beacuse of this readonly file system it is listing 19 records and no pagination.) How to make readonly filesystem without affecting above

Member Avatar
+0 forum 0

Got Client with need of **"online print shop"** Client is providing paper printing (like business cards, flyers), printing on cloths, office stationary, logo embroidery on any type of clothing. Client provided some examples. **Links** * [rockdesign](https://www.rockdesign.com/) * [moo](https://www.moo.com/ca/) * [readyprint](https://www.readyprint.ca/) * [vistaprint](https://www.vistaprint.ca/) * [printshop](https://printshop.ca/) * [printvenue](https://www.printvenue.com/) **Where do I start?** Which platform should I choose? 1. CorePHP 2. Wordpress 3. WooCommerce 4. Magento 5. Prestashop 6. WordPress Is there any plugin or script that should I go for???

Member Avatar
Member Avatar
+0 forum 8

Hi fellas, I hope my first message here comes across more helpful than bothering. I’ve recently launched a WordPress backup plugin - WPvivid Backup/Restore. It contains pretty all basic features that you’ll need to backup/restore you site and is fairly easy to use. And most important, it’s completely free(free update and support). I made it because I realized that there’s still a growing need for the easier and more affordable backup solutions in WordPress community, we hope our plugin can give people a hand. Please check it out at WordPress’ plugin repository: https://wordpress.org/plugins/wpvivid-backuprestore/ Any feedback will be greatly appreciated. Joe

Member Avatar
+0 forum 0

I'm somewhat new to coding websites. I'm trying to have a code where it pulls multiple images from a single database and displays it in a grid, not a table. At the top of my page I have a normal connection to the database. (very sorry about not having a code snippet, I'm new to daniweb and keep having errors when trying to use code snippets.) <div id="grid" class="grid-container"> <?php while ($row = mysqli_fetch_array($query)) echo '<div class="grid-item"> <p>'.$row['images'].'</p> <p>'.$row['project'].'</p> <p>'.$row['summary'].'</p> </div>'; ?> </div>

Member Avatar
Member Avatar
+0 forum 1

I would like help with creating a form that when submitted, creates a webpage which is able to be edited by whomever submits the form; I would also like this url/link to be added to a database.

Member Avatar
Member Avatar
+0 forum 1

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 4

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
Member Avatar
+1 forum 2

Previously used winXP operating system running normally (very good) when switching to win7 operating system, this error, read errors from the SQL Server data, what is the error ? http://www.mediafire.com/view/4q5ux6e66ds4avb/ErrorOpenSQL.jpg/file

Member Avatar
Member Avatar
+0 forum 1

java language (ArrayList) The Registrar Office at the university has asked you to help them write a Student Information System (SIS). The system can be used to store information about students, courses, and students' transcripts (courses already taken by a student). · Define a class called StudentType that holds information about a student (student ID, first name, last name, major). · Implement each member function (set, get, print, constructor, etc) in the class. · Define a class called CourseType that holds information about a course (course code, course title, number of credits). · Implement each member function (set, get, print, …

Member Avatar
Member Avatar
+0 forum 3

Hello people, I've been working on a registration form project that needs to contain a captcha code that will be validated. Even if the captcha string inserted in the text box is correct, it displays the error "Captcha string is incorrect". Also, even if the captcha part did not exist, the form doesn't seem to save the data to my sql database. Can anyone please try to help me out or check if you can notice any obivous errors with my code? The following code is the PHP and HTML code used for the registration form <?php session_start(); $_SESSION['captcha'] = …

Member Avatar
Member Avatar
+0 forum 1

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 , 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

The End.