10,946 Topics
 | |
 | 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 |
| | Hi all, I currently have two tables that look like this: COMMENTS +----+-------------------------+--------------+---------+---------------------+----------+ | ID | comment | profile_post | creator | created | approved | +----+-------------------------+--------------+---------+---------------------+----------+ | 1 | This is a test comment | 3 | 1 | 2016-02-26 12:26:36 | 1 | | 2 | 0 | …  |
 | 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 |
| | please check this code and tell me what is the problem with this ..... i get error*"operation is not allowed when the object is open"* dim conn as new adodb.connection private sub commandbutton1_click() conn.connectionstring="dsn=localhost;uid=root;pwd=root;" conn.open dim cmd as new adodb.command cmd.commandtext="select sname from stu" cmd.commandtype=adcmdtext cmd.activeconnection= conn end sub  |
| | <?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 ! gd evening :) I'm just facing error while coding on vb.net. I have new customer form. Normaly it has many text boxes , one date time picker and five picture boxes. this is code snip : Dim mstream As New System.IO.MemoryStream() customerpic.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg) Dim arrImage() As Byte = …  |
| | 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 |
| | I'm wondering how to save image to MYSQL-DB via vb.net application. At the last I find some way to save image. But 'some type of images' doesn't save in that way. By 'some type of images' I mean diffrent widths,heights and resolutions. For example I use this code to save …  |
| | 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']; … |
 | Hello, I am trying to reset mysql myphpmyadmin password: Cannot log in to the MySQL server Username: root Password: 12345 And have not been successful yet reseting it. This is my config.inc.php <?php /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] … |
| | 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.......... |
| | Hi Guys, I am a novice at coding, firstly I knowthe functions in my code are deprecated in future versions of PHP, I'm running 5.5. I have a few days to get my current code working with this desired functionality which is a throw away prototype, so for now I'm … |
| | Hi all, I'm having an issue with a local copy of a live WordPress site. The local site itself "http://localhost/mywordpress/" works, but when I try to access the wp-login.php page, it redirects me to the production site. I do the following under a local XAMPP setup: copy the production WP … |
 | Hi all I have a system that im working on the the code works fine it, but theres a part thats giving me issues below is the code that loops through the number of records in the table and generates the same number of update queries with the random numbers … |
| | I'm using phpexcel , I created a script that so far it takes me an Excel spreadsheet and I put the field values in an array of associative arrays , I found a way then print these values in a table html , to see if the recreated excel files …  |
| | I want to get all the related pics corresponding to the pic selected.... here is my view page <?php foreach($detail as $row){?> <img class="primary-image" ima="<?php echo base_url();?>images/<?php echo $row->image;?>" src="<?php echo base_url();?>images/<?php echo $row->image;?>" alt="" /> <?php }?> my control page looks like this.... public function product_details($p_id) { $data['active_mn']='product_details'; $data['product']=$this->roxmodel->get_product_details($p_id); … |
| | I have a form on "add-category.php" that enables the admin to create a category and doing so includes uploading an image to a folder and inserts its file name and relevant text into the database. The script worked well with mysql_, but now it stopped working after I upgraded my … |
| | I'm working on shopping mobile application. The application is similar to ebay it have customer and seller. When user create account they can either create account as seller or customer. The payment will be by paypal each user need to provide their paypal account (Seller Paypal & customer PayPal) so … |
| | i want to display all related images according to the image selected here is my code... my control looks like this.. public function product_details($p_id) { $data['active_mn']='product_details'; $data['detail']=$this->roxmodel->get_related_image($p_id,4,0); var_dump($data['detail']); $this->load->view('product_details',$data); } my model looks like this public function get_related_image($p_id,$limit,$offset) { $this->db->order_by("gallery.id","desc"); $this->db->where('category_id',$p_id); $query=$this->db->get('gallery',$limit,$offset); return $query->result(); } my view page looks like … |
| | please i need to query 2 tables at once and display the content in table. here is the code: <?php include 'database.php'; $pdo = Database::connect(); $sql = 'SELECT producs.*,validation_superviseur.* FROM products ORDER BY product_id DESC ,validation_superviseur ORDER BY id DESC'; foreach ($pdo->query($sql) as $row) { echo '<tr>'; echo '<td>'. $row['cat_id'] … |
| | final public function setMySQL($key, $value) { $this->mysql[$key] = $value; } /*-------------------------------Manage Connection-------------------------------------*/ final public function connect($type) { global $core, $_CONFIG; if(!$this->connected) {k $this->connection = $this->mysql[$type]($_CONFIG['mysql']['127.0.0.1'], $_CONFIG['mysql']['test1'], $_CONFIG['mysql']['12345']); if($this->connection) { $mydatabase = $this->mysql['nexus']($_CONFIG['mysql']['nexus'], $this->connection); if($mydatabase) { $this->connected = true; } else { $core->systemError('MySQL Engine', 'MySQL could not connect to database'); } … |
 | Hi Everton one, I have the following search statement that works great, But what I would like to do is expand this to include multiple LIKE '%$search%' $STM = $dbh->prepare('SELECT * FROM tblname WHERE col=:lsecure'); $STM->bindParam(':lsecure', $search); $STM->execute(); $count = $STM->rowCount(); $results = $STM->fetchAll(PDO::FETCH_ASSOC); What I would like to do … |
| | Hello,I need help in updating user image in form. I have form of around 10 fields in there is options for updating images(images which have been uploaded at time of reg)** Max 5 images is allowed **now i am successful in saving data to database and at time of updating … |
| | I have a text area that I want a list to be entered. I am trying to seperate each list item and put it into a seperate sql entry. Could some one tell me what I am dong wrong? error_reporting(E_ALL); ini_set('display_errors',1); $textarray = explode("\n",$textarea);if(isset($_POST['textarea'])){ $textarea= $_POST['textarea']; $q = "INSERT INTO … |
 | Hello. How can I config django (python framework) with mysql? How can i use phpmyadmin to manage my database while i'm coding in django? Thank you. |
| | Hi, I know parsing json data has been discussed lots but what I want is probably a little simpler I need a little editing to the bleow php script to work as convert json data and push it into MySQL table since the script work as reading the json data … |
| | I'm making money lending system. In my database there are two mysql tables which are custormer AND income. All custormer info stored in custormer table. When I give loans these loan details stored in loan table. After I received loan amount from custormers(daily payments) these records stored in income table. … |
The End.