Member Avatar
$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 …
by chandnee in Web Development ()
Member Avatar
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); …
by zebnoon1 -3 in Web Development ()
Member Avatar
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.
by Henryu in Web Development ()
Member Avatar
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 …
by Himanshu Chawla -5 in Web Development ()
Member Avatar
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.
by AntonyRayan 15 in Web Development ()
Member Avatar
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 = …
by phphp in Databases ()
Member Avatar
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 …
by archibald_1 in Databases ()
Member Avatar
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), …
by lewashby 14 in Databases ()
Member Avatar
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 ?
by Sushmitha_1 in Web Development ()
Member Avatar
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 …
by anand01 in Web Development ()
Member Avatar
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" …
by SimonIoa 39 in Web Development ()
Member Avatar
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, ". …
by CreatorZeus in Web Development ()
Member Avatar
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 …
by spluskhan -2 in Web Development ()
Member Avatar
this is the response i get (1045, "Access denied for user 'point3hu_leo'@'197.253.66.85' (using password: YES)") Press any key to continue . . . from pony.orm import * db = Database() db.bind('mysql',host= 'poin.com',user='pointeo', password = 'lxxxx',db = 'poi_data')
by mcroni in Databases ()
Member Avatar
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[] …
by Faisal_13 in Web Development ()
Member Avatar
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 …
by Eddy_1 in Web Development ()
Member Avatar
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 …
by sohan_1 in Web Development ()
Member Avatar
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 …
by SpottyBlue in Web Development ()
Member Avatar
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 …
by Mani_7 in Web Development ()
Member Avatar
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, …
by zelrick -1 in Web Development ()
Member Avatar
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 …
by AntonyRayan 15 in Web Development ()
Member Avatar
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 …
by Faisal_13 in Web Development ()
Member Avatar
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 …
by Mr.M 32 in Software Development ()
Member Avatar
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 …
by Faisal_13 in Web Development ()
Member Avatar
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] …
by Gurjit_2 in Web Development ()
Member Avatar
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 …
by Faisal_13 in Web Development ()
Member Avatar
: 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 …
by Pam Thomas in Databases ()
Member Avatar
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 …
by skullscript in Web Development ()
Member Avatar
Hello, i am a new php and html developer. kindly assist me for my querys thanks in advance raj
by Raj_18 in Web Development ()
Member Avatar
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 …
by savedlema 17 in Databases ()