7,368 Topics
 | |
| | How can I use a variable in a MySQL select statement? Code: $serverid = $_SESSION['server_id']; $sql = "SELECT * FROM servers WHERE server_id = '$serverid'";  |
 | How to create offers section in a e-commerce PHP website. Should I create separate table for offers in the database.? Given below is the offers example offers ex : 20% discount, Buy 1 get 1 etc.. How to start and end this? Please help me to do this.  |
| | i have an access database with table relationships, queries and i want to convert into mysql is there any free software that can help me to do it, i searched for MySQL workbench but its not opening in windows 7 64-bit |
| | I want to integrate PayPal IPN and payment getaway on my website. I want my website users to be able to sell ad space through my website using PayPal. I want the payment to be from my user (Advertiser) to my user (Publisher). Here is what I have done so … |
| | i want to count the checkboxes i putted in my project when they get selected and they cant available again when they get stored in mysql plz rply me on shreyasmnt@gmail.com |
| | <?php if (isset($_POST['import'])) { $fname = $_FILES['patientcsv']['name']; echo 'upload file name: ' . $fname . ' '; $chk_ext = explode(".", $fname); if (strtolower(end($chk_ext)) == "csv") { $filename = $_FILES['patientcsv']['tmp_name']; $handle = fopen($filename, "r"); $i = 0; mysql_query("START TRANSACTION"); while (($data = fgetcsv($handle, filesize($fname), ",")) !== FALSE) { if ($i > …  |
| | Hi all, I am running a mySQL database on a webserver hosting multiple Wordpress installations. It seems that database is getting swamped with memory and going into a continual loop of shutting down and restarting. A reboot fixes the issue temporarily, but I have no idea what I can do … |
| | Hi, While printing , the color what I gave in the box , is not coming while printing. How to fix the color  |
| | I am trying To display the content of the table selected(Imported from MySql) in a JTable whose Structure is unknown to me . I Have Successfully added columns in Jtable but not Able to add rows which the ResultSet Object Returns. Please Help me Insert The Row DATA . I … |
| | A theoretical question about connecting to hidden services through PHP. Say I am writing an application on the clearnet that relies on data stored within a mySQL database that is hosted on a hidden Tor service. How would I initiate this connection? Some brief research has pointed me towards the … |
 | I'm currently working on a website; crafterguide.azurewebsites.net; and I was woundering how to get the best possible login/register/logout page, how get it where when someone creates/log's in to a(n) account that it redirects them to a profile page, and just some feed back and critisizum. |
| | I have the code . It is not properly showing output <?php session_start(); $servername = "localhost"; $username = "root"; $password = ""; $dbname = "forextrading"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname ); $link = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (mysqli_connect_errno()) { //echo "Failed … |
| | Hey Guys i need to copy value from table as integer to onther table in same data base like.. My program is to Add Silk Or Money into database by the user write the username into textbox1 and the amount of silk or money into textbox2 and the record need …  |
| | Greetings Daniweb! Just recently, I was able to integrate a Fingerprint device to my application. Can now scan fingerprints and save them to database using the INSERT TO syntax. But I can't get my application to match scanned fingerprint to one already stored in the database, so that I could … |
 | How I can group concat of ids with limit 2 and order by id desc? Means, need all the ids except first two ids in desc order. select group_concat(id) as ids from private_tuition_teacher_pdf where client_id = 14 and teacher_id = 15 limit 2 order by id desc |
| | Hi, CREATE PROCEDURE `FindDuplicateExpenses`(IN `strExpenseDate` DATE, IN `strProfile` VARCHAR(50)) NO SQL SQL SECURITY INVOKER SELECT PD.Code, PD.ExpenseAuthorizedRefAmount, PD.FullName, PD.ExpenseDate, PD.ExpenseNatureID, PD.Ignore_Expense, PD.Profile FROM tblExpenses AS PD, (SELECT Profile, ExpenseAuthorizedRefAmount, FullName, ExpenseDate, ExpenseNatureID FROM tblExpenses GROUP BY Profile, ExpenseAuthorizedRefAmount, FullName, ExpenseDate, ExpenseNatureID HAVING COUNT(*) > 1) AS SUB1 WHERE PD.ExpenseAuthorizedRefAmount = …  |
| | Hi, I am programming an app and facing a problem now. I want to Update my Database over the GUI from my App via PHP. My Problem is that the app always sends the value of the checkbox even if it is unchecked. I will post my Script below. update.php … |
| | Im making a website that works around a very basic MVC structure. I have three folders, the Model, View and Controller. I want to display the content of the database in the dropdown once the page has loaded. My view has: <div id="appCalc"> <form id="applianceCalc" method="POST" > <?php if(isset($error)) { … |
| | Hi guys! i have a dropdown list that is filled with data that is pulled from my database. Im stuck with populating the textbox based on the value thats selected from the dropdown box. My model currently looks like this: <?php require_once('../Config/config.php'); class AppCalc { public $dbconn; public function __construct() … |
| | Hi guys,, I developed a Sales Management System its is a stand alone system, i installed in the Pc at first when it had few data it was working finely. Then when data increased it started to be slow in its excution taking some seconds to complete the excution, eventually … |
| | Hi guys, I am programming an Android App and I am trying to do a multiple SQL insert but it doesn't work. Can someone help me? And I also want to have the ID from the new created student. How do I get that ? <?PHP if($_SERVER['REQUEST_METHOD']=='POST'){ $Name = $_POST['Name']; … |
| | Sending SMS through gateway was one of the features in our project. In our first tries, the complete message was succeefully sent.. We used this Code <?php header("location:http://api.clickatell.com/http/sendmsg?user=thisistheusername&password=thisisthepassword&api_id=thisistheapiid&to=". $_POST['mnumber'] ."&text='". $_POST['message'] ."'"); ?> But our panelists required us to put an alert that the message was sent.. and when we … |
| | I'm developing a new website using a MySQL database and VS2015. I'm trying to get default values displayed when the user hits "new" on a detailsview. I'm am trying code that fires on Databinding but when the user hits "new" I get a Nullreferenceexception. Users on other forums claimed that … |
| | i am using php with xampp server and i am getting the following error while i am running the program. Unknown column 'firstname' in 'field list' (heres the program) CREATE DATABASE IF NOT EXISTS `customerdb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `customerdb`; -- -------------------------------------------------------- -- -- Table structure for … |
| | I'm having some real trouble running some basic queries that I should be able to run easily. I have a table called settings. When I query `SELECT * FROM settings` I get the output: +----+-----------------+--------------------------------+ | ID | key | value | +----+-----------------+--------------------------------+ | 1 | view | default | … |
| | So I am working on a messanger, and I am having problems automatically fetching new messages from the database. If anyone can fix me up with a peice of code which can fetch new information from the database after every 2 seconds or so. I am very new to working … |
| | Dear Team - Hello to Everyone!!! pleae note that i m trying jump to test.php page from index.php/html using ajax and mysql, simple if text-input **not found** in table so it should go to test.php else stay on index.php/html page with ajax alerts, but from index page everytime receiving NOT … |
| | I am trying to upload file from postantivirus1.jsp after selecting the file from postantivirus.jsp Here is the code Postantivirus.jsp Anti Virus Software : </td><td><input type=file name="fname"><br/> <input type=submit value="submit"></td><td><input type=submit value="clear"> Postantivirus1.jsp String s=request.getParameter("fname"); System.out.println(s+" s"); FileInputStream fis=new FileInputStream(s); System.out.println(fis+" fis"); String s1=application.getRealPath("/"); String destFolder = s1 + "images/"; s1= … |
| | I'm making money lending system. On that I use mysql database. I want to find customer's who skipped their daily instalment. I try this code. But It has error. ***Prveious code:*** SELECT l.loan_id, l.custormer_id,custormer_name FROM loan l JOIN income i ON l.loan_id = l.loan_id WHERE l.loan_id NOT IN (SELECT loan_id … |
| | Suppose this is a Table Create Table Person( PersonID varchar(8), PersonLN varchar(16), PersonFN varchar(16), PersonADD varchar(64), PersonPH varchar(16)); so there are many enrty in that table.. So how to select the lastest row entry from that table? what will be the Mysql statement? take PersonID as a Primary key.......... |
The End.