10,940 Topics
 | |
 | i need help in the following code i am trying to create dynamic radio buttons from mysql db and want to insert into another table its not echoing data and not even inserting i am just beginner please help me out thanks in advance <?php $dbhost = 'localhost'; $dbuser = …  |
| | SAMPLE TABLE 1 =================================== product Division sales % =================================== product1 divsion1 99 product2 divsion1 51 product3 divsion1 50 product4 divsion2 98 product5 divsion2 41 product6 divsion2 40 product7 divsion3 97 product8 divsion3 31 product9 divsion3 30 =================================== Expected output 1 =================================== product2 divsion1 51 product3 divsion1 50 product5 divsion2 41 … |
 | HI, I have recently upgraded my mysql database to version 5.1.72 community log. I am having an issue that all my select queries are showing the columns as NULL if there is no entry added for a specific column. For exmaple I have a table table_employee and the employee name … |
 | Hi I'm new to php,i need a code for issue and edit in library management system can someone please help  |
 | Please help me .. how to calculate the binnary mlm calculation in php and mysql ... thanks in advances ... |
| | hello, i have one table in sql server and i made a form to editing this table from. so when i click edit in the table .. it takes me to the editing form with the chosen id .. what i need is to show all other feildes in the … |
 | I'm excited I just discovered a way to remove unused MySQL indexes and I wanted to share it with you guys. I'm following the tutorial here: https://www.percona.com/blog/2012/06/30/find-unused-indexes/ We happened to have already been using a Percona-fork of MySQL. It just so happens that Percona has been our database consultants for … |
| | Hi I have a master table Company info where information like revenue, profit, expenses etc are captured. Now i want to retrieve companies who has made profit every year since last 5 years. Issue is some company have latest data of 2017 and some have latest dat until 2016. How …  |
 | if a group of students pass out from their college or university etc. now how to create a database that a teacher can see his how much his student got success in life  |
 | I'm trying to generate barcode tickets after successful booking and it's working fine. But yesterday (08-Jan-2017) night at 11.59 pm, one customer booked 2 tickets but the ticket sl.no was duplicate. Tthat is both tickets sl.no was 1. Actually it should be 2. But the next customer's tickets sl.no was … |
| | there are five tables (personTb, addressTb,churchTb) each holds data pertinent to an individual; (personAddress,personChurch) each hold the primary key for the person table and corresponding table IE personAddress holds primary key for addressTb. ​ both snippets work, my question is;** Is my join correctly formatted? ** select concat(personTb.p_fName,' ',personTb.p_mName,'. ',personTb.p_lName) …  |
 | Hello. I've been learning a bit of PHP for a small school project. The project is almost done just that 1 thing is missing. I need a way to output something I searched into CSV / Excel. I found a script which im using currently. It works beautifully I just …  |
 | Im creating a social network site and i was able to create a user folder each time a new user signs up but my problem is copying a default image from a folder to that user folder how can i do that? I've searched the web on solutions like using … |
 | Hi everyone, I am trying to run a select query using the results from an earlier successfull query. See below - $stmt = $conn->prepare("SELECT * FROM tab1 ORDER BY id DESC"); $stmt->execute(); $total = $stmt->rowCount(); $cstmt = $conn->prepare("SELECT * FROM tab2 WHERE otdc_ref='$stmt->otdq_ordernum'"); $cstmt->execute(); $total = $cstmt->rowCount(); while ($row = …  |
 | Hello i want to make a statement that increases a row on a table on MySql every time one visits the page. The $_GET['ID'] its ok dont waste your time with that. This is the statement require 'config.php'; $db = getDB(); $ID=$_GET['ID'] ; mysqli_query($db, "UPDATE table SET count = count … |
 | hello fellow web developers, i am trying to develop a schools web portal, i need to design it such that students details can be submitted, retrieved for deleting or editing or printing, i already have material guides on how go above adding editing or printing, how do i display and … |
| | Hello, I built a website on my personal server and everything work fine. But when I uploaded it on the production server there is a problem with the database - the character encoding is wrong so the text is unreadable (users submit greek words). The collation of the tables is … |
| | The other day I tweeted that MySQL unions are my new best friend. I just want to take that back. I just spent the past six hours (it's now 5 am) overhauling a MySQL query and removing one of the unions actually sped up performance. Dazah is really my first …  |
| | What is FIND_IN_SET() performance like? It it something that should be avoided at all costs? I want to search a column that consists of comma-delimited numbers for rows that contain a specific number. |
 | I'm beginner to **php/mysql** (quite familiar with PHP, mysql), **novice** to **XMPP**. I have created my site in simple **php/mysql/javascript/jquery**. I'm trying to add simple Private Chat to my web site. Trying to integrate **[JSXC Chat](https://www.jsxc.org/examples.html)** into my website. Please Guide me how to create **chat database**, install **XMPP server**, … |
 | Please help me out. I have a table with one row. I can add rows to it by clicking add button which adds rows through javascript code. I have 3 dropdown columns and one textfield and one more textfield which is not editable. So i need total of last column. … |
 | Hello, Recently I am dealing with bad performance in an php application that I have build, googling this issue I found out that using services like memcached you can archive a huge performance improvements. The weird thing comes when I try to find a very good and detailed example I … |
| | Hi, I am looking to create a MySQLi class(MVC pattern), I already have the following functions: Query, Execute, Results. Below is a PDO version of a Bind statement and was wondering if you could do the following in MySQLi or something similar in MySQLi: public function bind($param, $value, $type=''){ if(is_null($type)){ … |
| | Good afternoon all, The issue I am having is that when POST data values are looped through inside the while loop as each record is compared with the POST data and the database record for any changes. For this test the data from the post is exactly correct. The if … |
 | I am trying to put a post feed on the homepage but I am with difficulties on it. I think my query it might be wrong, but I want to pick the username from 'blabs' table and see if that 'username' from the same table is the user or the … |
 | The recently active list for admins and mods (team) appears broken, at least regarding myself. Currently it says I was last active 4 days ago, yet I've been on and active every day for the last 4 days (including posting and admin duties - the infractions list even shows my … |
| | How to store the following curl_exec output into mysql table? sent,success,114661698,709081462,+919900123456 sent,success,134707665,937687314,+917795987654 Eg: var1='sent' var2='success' var3='114661698' var4='709081462' var5='+919900123456' --------------------------------------------------- var1='sent' var2='success' var3='134707665' var4='937687314' var5='+917795987654' Thanks in advance |
| | Hey guys, I am doing a friend list and it's not working very well. Well I tried to show all the user's friends but it's not working, it only shows one instead of all. In MySQL friends_request I have something like this: username1 -> username2 username1 -> username3 username2 -> … |
 | help please.. guys this is just the only problem in my program i cant print my data from sql..i need my thesis to finish soon..help please.. heres my code <?php require('fpdf.php'); $fullname = ""; echo $contractno = $_REQUEST['contractno']; echo $sname = $_REQUEST['sname']; echo $fname = $_REQUEST['fname']; echo $mi = $_REQUEST['mi']; … |
 | **Note: this project is being restarted after one year of in-action, using the most relevant files I am able to locate. All final code will be adapted to MySQLi.** Versions of this code functioned properly to the best of my knowlege; now, with a new host I am having issues … |
The End.