10,946 Topics
 | |
 | I have affiliate api of amazon,ebay,flipkart and snapdeal. I want to combine all api results to my web page with pagination. Like this website https://www.compareraja.in/mobiles.html If possible please suggest any ideas. I am using opencart for development.  |
| | I have scenario where one user can refer two codes to other one will become right and other left.Now this right can have two child left and right and so on same for left child user.... So this is binary tree like strucutre so i am selecting a user from … |
 | I am building a system that will take about 20 million records. I am confused, if I should put all these records in one table or I should split it among severals tables to speed up the performance. |
 | Why was `INSERT DELAYED` deprecated? https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html I used to use it and it was incredibly useful.  |
| | I have an InnoDB table called `articles_read` with fewer than 20,000 rows in it. It consists of 3 columns: member_id article_id timestamp There are two indexes: A unique index on (member_id, article_id) and a regular index on (timestamp). It is read from fairly more than it is written to, and …  |
 | I have a database with only one table which has around 2 Million rows and 60 columns. I created a php application with multiple search filters like name, country, state, surname, domain etc which will filter and display the result in HTML table. But the problem is, every text field …  |
| | Hello every one i am having one doubt i have a set of links[url].Now there is pave ackages like 6 links,25 links package. if two user select 6 link each day and both will have same links[url] .now i when user log in then on adversitment page he visit each … |
 | 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 … |
 | hi im attempting to update a script and i have come across the following error PHP Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, null given in so here was the orginal $sql = "select * from chat where (chat.to = '".mysqli_real_escape_string($_SESSION['usernamechat'])."' AND recd = 0) order by id ASC"; … |
 | /* initialize the calendar -----------------------------------------------------------------*/ var date = new Date(); var d = date.getDate(); var m = date.getMonth(); var y = date.getFullYear(); /* selects the events to load in the calendar -----------------------------------------------------------------*/ $.ajax({ url: 'process.php', type: 'POST', data: 'type=fetch', async: false, success: function(response){ json_events = response; } }); $('#calendar').fullCalendar({ //events: … |
| | Hello I am facing a problem while creating a view in MySQL, I tried all the possible solutions I got from internet but was failed. actually I have two **tables 1** is for installment schedule which contains a planned schedules and the **table 2** contains all installment payment which has … |
 | Hello all, I have the following code. Connection connection = getMySQLConnection(); try { Statement st = connection.createStatement(); String SQL = "SELECT ID, NAME FROM STUDENT WHERE ID=5"; ResultSet rs = st.executeQuery(SQL); System.out.println("SQL =" + SQL); while (rs.next()) { // do something... } } catch (SQLException se) { se.pringStackTrace(); } From … |
| | I'm trying to do use X-editable to do inline editing instead of having textboxes and such, I'm editing labels that I would like to send in a post method to update the values in the database. Is there anyway to send any kind of data within the <form> besides using … |
| | My SQL query is: UPDATE REGISTRUDENT set qual=1 WHERE studentolevelsubjects AS sls INNER JOIN courserequirements AS csreq ON sls.subject_id = csreq.subject_id WHERE sls.stud_id = '$stud_id' AND sls.grade_id>=csreq.min_grade AND sls.examno = '$examno' AND csreq.course_id = '$course_id' I'm having issue comparing two different table to get if a registrant qualified based on … |
 | /DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …  |
| | Hi, I'm trying to insert some values to database based on how many values are clicked but currently it only takes the last clicked field. I have tried hard coding with mysql_real_escape_string and the dreamweaver way. Both still give me the same last picked value instead of several values separated … |
 | I'm trying to reset my mariadb password following this site -> https://www.rosehosting.com/blog/how-to-reset-your-mariadb-root-password/ but when I enter `mysql -u root` I get the following error: `ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")` Any ideas? Thanks. |
 | What's wrong with my code? my save button is not working.. I need help please? thanks! here's my code: <?php include('header.php'); session_start(); ?> <?php include('navbar1.php'); ?> </br> </br> </br> </br> <form class="form-horizontal" method="post" enctype="multipart/form-data"> <input type="text" name="applicant_name" placeholder = "Applicant Name" required> <br></br> Applicant Type: <br/> <select name="applicant_type"> <option value="">Please … |
| | Hello all, I have an spring MVC app, that connects to my backend MySQL DB. I have my data source configured properly in my spring bean config XML file, as follow: <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3406/mydb" /> <property name="username" value="root" /> <property name="password" value="passwd" /> … |
| | Controller: function addblogs() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<br /><span class="error"> ','</span>'); $this->form_validation->set_rules('blog_title','Blog Title'); $this->form_validation->set_rules('description','Blog Description'); $this->form_validation->set_rules('category_id','Category Name','required'); $this->form_validation->set_rules('position','Position'); if($this->form_validation->run()== FALSE) { $data['categorylist']=$this->blogs_model->categories_dropdown(); $data['mainpage']='blogs'; $data['mode']='add'; $this->load->view('templates/template',$data); } else { $this -> blogs_model -> insertblogs(); $this->flash->success('<h2>blogs Added Successfully!</h2>'); redirect('blogs'); } } Model: function categories_dropdown() { $this->table = 'categories'; $this->where('status',1); $categorylist=$this->dropdown('category_id','category_name'); return $categorylist; } function … |
| | hello i need solution for to create a insert/select/delete/update stored procedure in mysql and how to call them from php currently i am using xampp 1.6.6 version of software thank you  |
The End.