10,939 Topics
| |
Hi, I was asked by my lead engineer to configure and migrate current database to elasticsearch that he believe will overcome the slow query issues . We are using laravel 5.2 , and using Amazon Web Services : Amazon Elasticsearch Service . I already done a proof of concept on … | |
Hi, All Presently I am working on a MLM (Multi Level Marketing) Software using PHP & MySQL. But I am not being able to display the Down line Tree of any particular member. I am using Pre order Tree. But my product should support Spill Over Binary Tree. Please Help … | |
Hi, I am new to this concept. How to export data from database in EXCEL for various standards with "dynamic headings" . | |
[CODE]<?php header('Content-type: image/JPG'); $username = "root"; $password = ""; $host = "localhost"; $database = "image"; @mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error()); @mysql_select_db($database) or die("Can not select the database: ".mysql_error()); $query = mysql_query("SELECT * FROM img"); while($row = mysql_fetch_array($query)){ echo $row['image']; } ?> [/CODE] that code display … | |
<?php error_reporting(E_ALL ^ E_DEPRECATED); // connection to database include 'database.php'; ?> <?php if (isset($_FILES['image']) && $_FILES['image']['size'] > 0) { //// Temporary file name stored on the server $tmpName = $_FILES['image']['tmp_name']; // // Read the file $fp = fopen($tmpName, 'r'); $data = fread($fp, filesize($tmpName)); $data = addslashes($data); fclose($fp); } $name=$_POST['name']; $email=$_POST['email']; … | |
I have been trying to get my PHP script return two different pages namely: get2015 and get2016. The aim is to have these two pages have pagination links below them. To achieve this i have written two scripts in two different files that look like this: file 1 = functions.php … | |
I have 2 tables that look like this.(see below). Table one is named tableX and table 2 is named tableY. +-------+---------+ | count | post_id | +-------+---------+ | 3 | 7209 | | 3 | 7210 | | 1 | 7211 | | 1 | 7212 | | 1 | … | |
I'm trying to learn OOP and i'm trying to create a class which will select me info from a table and a line that i choose. (trying my best to explain it good, not sure if i'm doing very well tho) This is my code in the class: class SelectQuery … | |
I have a table in mysql with the following data: | StartDateTime | FinishDateTime | | 2016-08-18 10:00:00 | 2016-08-18 11:00:00 | | 2016-08-18 12:00:00 | 2016-08-18 14:00:00 | | 2016-08-31 17:00:00 | 2016-09-01 09:00:00 | What I would like to get as the output is | Month | Duration … | |
Hi!, I am getting a warning message while trying to update values in textfield but the values are getting updated in database. here is my code, <?php $id = $_GET['id']; //print_r($id); $action = $_GET['action']; $page_name = mysql_real_escape_string($_POST['page_name']); $page_content = mysql_real_escape_string($_POST['page_content']); if (isset($action) && $action=='edit') { $sql = "SELECT * FROM … | |
$sql = "SELECT doc FROM file_loc where file_id='1'"; while($results = mysql_query("$sql") or die("Invalid query: " . mysql_error()); { // set the header for the image header('Content-type: application/pdf'); header('Content-Disposition: inline; filename = "' .$results . '"'); header('Content-Transfer-Encoding: binary'); if (isset($results)) { $pdf = new FPDI(); // get the page count $pageCount … | |
Hi guys you might know this about qr code im just a newbie here, my problem is that i can't produce simple qrcode that will fetch the data through the database , i wanted to create a single row of database and display it as a qrcode, can you help … | |
Sir I want to generate a query which will convert data from rows to columns I have this table ![aa.png](/attachments/large/4/266c6d1b9efd2e2621152dc5a3cad11e.png "align-center") I want to get this result ![bb.png](/attachments/large/4/54b2cbea895fc42a71c7e5109c612946.png "align-center") [IMG]http://i66.tinypic.com/2hfjep4.png[/IMG] Workers amount will go to column in relevant data Group by code. I wrote this query session_start(); require_once("includes/connectw.php"); $query = … | |
Hello, I am new to Jquery and task is given to me to "make a progress bar for task completion " . For example: there are 4 Sections and all those 4 section have different youtube videos . After the user clicks the section and watch the video of that … | |
hello my dear Friends, for a long time i was not here. I hope u all are geting well. again i have problem in login form anyone can guide me plz, code is below <?php include "conn.php"; if($_SERVER["REQUEST_METHOD"] == "POST"){ $username = filter_input(INPUT_POST, 'username', FILTER_SANITIZE_SPECIAL_CHARS); $password = filter_input(INPUT_POST, 'password', FILTER_SANITIZE_SPECIAL_CHARS); … | |
I'm tyring to figure out a way to compare the information in 2 different tables from 2 different databases. If they are in the same database it's easy enough but I haven't found a way to do it from 2 different databases. | |
Can anyone give example for this? I have user dashboard with graphs and tables, maps. It takes sometime to load after successful login. For that , I need a loader which waits till the page loads all the data. | |
After a server issue, my client has restored the MySQL files before their issue, but MySQL is having problems bringing their database back up. (i'm waiting for more information as the exact nature of the issue) I have the ibdata1 ib_logfile0, and ib_logfile1files, and all the .frm and .ibd files … | |
File drop database if exists contacts create database contacts; use contacts; create table names ( ID mediumint not null auto_increment primary key, firstName varchar(20), lastName varchar(20) ); create table addresses ( ID mediumint not null auto_increment primary key, nameID mediumint not null, addr1 varchar(30), addr2 varchar(30), city varchar(30), state varchar(10), … | |
Hello, I am trying to save the date field into mysql table. The date field in my jsp form is in format MM/DD/YYY and in database as YYYY/MM/DD. How can I retrieve the date from form and insert into the table with YYYY/MM/DD format ? | |
hi all , Am doing event management project. In jsp page am using javascript date picker. Then i passed that to servlet page by the following code. DateFormat formatter ; formatter = new SimpleDateFormat("dd-MM-yyyy"); Date date=formatter.parse(request.getParameter("date")); now I want to insert date in mysql database , How can I achieve … | |
Hello i am trying to put a value into a field on a table in my database. The value changes accordingly so the type of the column is ENUM ('P','A','T') but everything i do the value tha is been inserted is 'P'. this is the html `<input type="hidden" id="type" name="type" … | |
My Error info isnt being clear enough for me to understand the problemIs there anything worng here so i can continue on lookng for the probelm: $sql = "INSERT INTO boards ( title, genre, creator, tagline, intro, remessage, visability, recruitment, reqsheet, reqdice, reqgroup, ppweek) VALUES ( $title, $genre, $creator, ". … | |
Hello, I have two tables in mysql using php> 1) Consumers 2) Monthly Billing In Consumers that table contains about 100s of Consumers , and it increase monthly. 2) Monthly Billing for Billing. What i want to do ? Is there are any way that i can generate monthly billing … | |
Dear Developers, This is the part of my blog.While adding new post to my blog the category option not updating to database add_post.php <h2>Add Post</h2> <?php //if form has been submitted process it if(isset($_POST['submit'])){ $_POST = array_map( 'stripslashes', $_POST ); //collect form data extract($_POST); //very basic validation if($postTitle ==''){ $error[] … | |
Hi. I have tried to save the Json data retrieved below in vain. When I connect the database and try to insert the post data, the script no longer retrieves or decodes the data. When I leave it, the API tells me the data was reconciled or decoded. How can … | |
Hi , I want to create one product page , on nav-bar when user clicks on product before showing all product it should show one form and after filling form then and then only all products will be shown to the customer. I am trying to do this in php … | |
Hi, I added the "dayOverview" dropdown list that needs to assign to the database, but when I test it, it is uneditable. How? Please check lines 51 and 164 - 176. Download the attendance form zip file: https://drive.google.com/file/d/0B07_pOHhTox3bS1mVXpiTUN3RVk/view?usp=sharing Inside there is the database table called attendance.sql. You need xampp and … | |
How can I convert (move) individual HTML webpages in bulk into mysql forum? What I have is just the 1000s of html pages which consist of question and answers. Now how can I move then into into mysql forum. This is how my question/answer html pages looks like this:- drive.google.com/file/d/0B4RFn3PmjNy9YTNkbE5mejBfV1U/view?usp=sharing … | |
Hello DaniWeb Users; I'm not a good coder here please hold on me, My machine is linux ubuntu 14.04 and I install apache2 also the php5. I was trying to create a simple log in page here (no registration thing) So in mysql I just create 3 fields (user_id, username, … |
The End.