2,070 Topics
| |
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 … | |
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 … | |
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 … | |
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 … | |
<?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) … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 | |
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 … | |
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 … | |
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. | |
hello hope you all are going well, so my vacation is comming and i was wondering whta if i did a big project or small project, how hard is it to make my own multivendor website like amazon, i would like to do everything like the code in php, the … | |
Hi, I've written this code which i send below. now i have a listview, and when i click each item in my listview, i want it's related word to be fetched from db and shown in my textview. now it fetches all the data :(. look at the picture, for … | |
I started working on a windows forms authentication project, which uses nhibernate, and has some management pages for managing user settings, such as resetting user password. This forms based authentication uses session state in order to save the user's authentication information. I will be using a special authentication attribute in … | |
Hello everyone , well am using a script with javascript that gives me some values , that i decided storing in a var JSON : {"user_IP":"192.168.*.**","page_name":"Nous suivre","path_name":"/test/suiv.html","nbre_visites":"3"} //var s=JSON.stringify(cookieso); //document.getElementById("affichage").innerHTML = s; the thing , is that i wish i could store directly on my database : P.S i m … | |
This is surprisingly difficult. Consider it a snippet. Deletes all tables from a sql server schema. Useful for those times on your dev machine where you need to tear down all the cruft that has built up on your server due to refactoring of object relationally mapped tables. --Author: Cameron … | |
Hello .Im a final year student in bachelor of science computer in web technology. I need your suggestion for my final year project title.Do you have any related ideas? | |
Ok I have a workbook that have 5 worksheets for a 5 year span. On each of the worksheets are there is a list of countries that make up the combobox (which works perfectly). On my userform I have a frame on the userform that represent each worksheet. **My problem … | |
I'm in last year in CSE & my is relating to fingerprint, so i need to help. | |
# my code in asp.net with sql server # my final task is to perform string matching and i know i use algorithm but i can use logic first i split the code in listbox .success 2nd step i match all the listbox items to sqlserver which contain 1 column … | |
How can I show the database in a single mode (windows or SQL authentications mode) please help me..... How can I Show the database in a single mode (windows or SQL authentications mode) please help me. I create a project VB.NET 2010 and SQL server 2008r2 , When I login … | |
Hi, i'm trying to enable users to upload to my db. at the moment i've just got a folder called 'uploads' in my root directory... (i'll worry about getting them into the db once i can uplaod to there!) here's my php... <?php $target_dir = "http://www.XXXXXX.com/uploads/"; $target_file = $target_dir . … | |
I am using two database one is default which I would like to set db name as per session value, second database I am using to login and registration and set session once user logged in. Can anyone have solution to manage this database name after login of user based … | |
Hello, l have a table in sql server containing some information such first name,last name, address etc. I want to display the items for a particular row when l search in a textbox. I am running into error messages. Any help here will be appreciated. Here is my code, its … | |
Hey guys, Myriad Festival is coming to Brisbane next week and heaps of tech experts both local and international will be speaking there! It's my first time going to an event like this and I'm super excited to hear the industry mentors speak so I thought I'd let you all … | |
Hi I am struggling how to list all the permissions and with checkboxes. if anyone can help me with it this is the code echo "<table cellpadding='0' cellspacing='0' width='100%' class='table table-bordered'>"; echo "<tr>"; echo "<th>PERMISSION</th>"; foreach($user_groups->rows as $row) { echo "<th class='checkbox'>".$row['title']."</th>"; } echo "</tr>"; $users_permission_query = $this->db->query("SELECT * FROM … |
The End.