11,093 Topics
 | |
| | 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  I want to get this result  [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, … |
| | Hi everyone, I am new to this concept. I need your help for Grouped Categories Multi Level Drill Down Bar Chart. Example: Category 1: Cars Category 2: Bikes ..... Category n: Buses Category 1: Cars i)Minimum sold cars ii)Average Sold Cars iii)Top Sold Cars First Drill Down: Here, I need … |
| | Dear all I am a beginner in web development. Please help to resolve the below problem. Right now I am creating a Workers Directory with sql database. This is including worker name, Location, Work and mobile numbers. > When customer select the specific job we need to filter particular job … |
 | Hi Dw. I have a MySql server database, and I'm polling data from the database. The problem I'm getting is that when I'm retrieving users activities I only get the first record only which is on `Row(0)` or the first record with that username. Suppose I have a database like … |
| | Dear devolepers, I have problem with my sql database, I want acces my sql database in my <LI> list plaese help to resolve this problem Here is my html sql database : my_db table : info_list Table columns : id,name,job,town,mobile1,mobile2,phone,adress i want to display town list in this <li> list … |
 | Hello. I am new to PHP/MYSQL. My array looks like this: Array ( [1] => item1 [2] => 1tem2 [3] => item3 [4] => item4 [5] => item5 [6] => item6 ) Array ( [7] => item1 [8] => item2 ) Array ( [9] => item1 [10] => 1tem2 [11] … |
| | Dear developers How to show contact details while clicking the particular name from <li> list Contact_list.php <?php $con=mysqli_connect("localhost","user","pass","nilambu1_mydb"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM n_info "); while($row = mysqli_fetch_array($result)) { echo "<li><a href='contact.php' data-transition='slidedown'> <img … |
 | : CREATE TABLE CUSTOMERS ( CUSTOMER_ID numeric(3) not null, LASTNAME varchar(50) not null, FIRSTNAME varchar(50) not null, STREET_ADDRESS varchar(50) not null, CITY varchar(50) not null, STATE char(2) not null, ZIPCODE char(5) not null, E_Mail varchar(50) null, Primary_Phone char(12) null, CURRENT_BALANCE real(8,2) not null, CREDIT_LIMIT real(8,3) not null, SALES_REP_ID numeric(3) not … |
 | Hi! Having a hard time figuring out how to solve this problem at hand. basically i have several tables that are inter connected in some manners but i need to full all this data and format it in a manner that it will show the total number of trips and …  |
 | Hello, i am a new php and html developer. kindly assist me for my querys thanks in advance raj |
| | I'm not sure whether this is a good question for this forum but, I'm struggling to set up a database to use in my school academic system that is supposed to record all student's scores and then be able to prepare a report that shows students ranks. The hardest part … |
| | How to add new languages in this example? <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <script type="text/javascript" src="https://www.google.com/jsapi"> </script> <script type="text/javascript"> // Load the Google Transliterate API google.load("elements", "1", { packages: "transliteration" }); var transliterationControl; function onLoad() { var options = { sourceLanguage: 'en', destinationLanguage: ['ar','hi','kn','ml','ta','te'], transliterationEnabled: true, shortcutKey: 'ctrl+g' }; … |
| | Is it possible to do pagination in Drilldown Graph? |
| | Sir I have this variable $date="2016-07-18" I want to get DATA from 2016-07-01 to 2016-07-17. In other words I want to get DATA of month given in $date (July) but excluding current date (18) How to write query $query = "select * from arrival where ........; Please help |
| | How to set a image as default as fixed like background and remaining images will have to change dynamically? in HTML, CSS  |
 | Customers pick When finished If on the book, such as the selection of Van Dyke VT01 from 1/07/59 - 2/07/59-day period, you will not be able to book your car again. It is based on the availability of the vehicle. I made a separate table Storage booking Van table separately … |
| | Hi all, I'm using the Laravel framework to create an application, and have a database question. I have a table called `posts`. I have been pulling the 10 most recent rows from here and making use of an offset variable for pagaination. Now however I also have a table `media` … |
 | Hi everyone, I have a submit form on my website that display's to the user once is has been submitted, The problem I have is the text is being displayed as Chris & Amy\&#39;s 30th It should be displayed as Chris & Amy's 30th What is the best way to … |
 | how can i pass the value of $lat and $long in the while loop going to the script for googlemap.. kindly see the code below; while($row = mysqli_fetch_array($query)){ $station = $row['STATION']; $pei = $row['PEIS']; $pga= $row['PGA']; $pgv= $row['PGV']; $lat = $row['LAT']; $lon = $row['LON']; } <script> function initMap() { var … |
 | sir can you help us or give us an idea in our System Tutorial (Thesis) in our subjet Software Enginieering, our professor required us to make a system that is not yet existed, Examples Grading system, Inventory System, Using VIsual basic 10 with the connection of data base, . sir … |
| | How to retrieve data from another database using PHP, mySQL? |
 | How to retrieve data from one database to another using PHP , mySQL? |
The End.