Member Avatar
I´m in disgrace with the framework Codeigniter version 2.2.0, it only displays the json response, no errors, no chart... Code **Model** function get_pata() { $this->db->select('theyear, cantidad_alumnos, rawkw, rawkwxgei'); $this->db->from('pdc_factor_gei'); $query = $this->db->get(); return $query->result(); } **Controller to handle data from Model and display in view;** function data_fik() { $data = …
by Mario A._1 in Web Development ()
Member Avatar
I have created template for user to user chat module. Need help to complete realtime chat. Need some validations like highlight chat window on message received if it is inactive. `to_id` is collected in script (`var userid`). how to collect `from_id` , if user is logged in via php. currently …
by hrushi9 in Web Development ()
Member Avatar
I have a database to manage students 1. I want to Select students that are in level 1 fom the students table 2. Select the subjects from the subjects table 3. and echo the matching results on am html table any help?
by eternalcreator in Web Development ()
Member Avatar
Working on law firm website. Different Lawyers have assigned different cases ( in same law firm). For that purpose it needs Family Tree implementation to collect clients history. There is main table `persons` personID primary key AUTO INCREMENT firstName lastName sex birthDate birthPlace deathDate deathPlace parents, spouse, childre all are …
by hrushi9 in Web Development ()
Member Avatar
I need to create a form with five dropdown select lists. Making a selection in any list will cause the other lists to repopulate. It's fine if the page refreshes in order to repopulate the lists, although eventually I'd love to have it happen dynamically (using Ajax or JQerry). The …
by INSPIREDNZ in Web Development ()
Member Avatar
My question is related to an [answered question](https://www.daniweb.com/programming/web-development/threads/506078/parsing-xml-to-extract-attributes) that was asked here on the ever reliable forum - Daniweb. I have been trying to insert the parsed data as a string into mysql table in vain. This is what i am trying to do..... From the solution in the link …
by Amaina 14 in Web Development ()
Member Avatar
/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 …
by nathan_8 in Databases ()
Member Avatar
Hi Guys! i need some help, with recurring invoices or payments. I have Application which i developed recently to my customer. And inside of App i got a module to invoice clients, for a product, which this product is valid only for one year starting may for each year and …
by hell hansen in Databases ()
Member Avatar
I'm trying to get the text value from a select dropdown menu that is populated by a database using the following function: <?php function searchintspokenlang() { require ('../../../connect_db.php'); $queryintspoken="SELECT Language FROM languages"; $result=mysqli_query($dbc, $queryintspoken); while ($row = mysqli_fetch_array($result)) { echo "<option value='" . $row['Language'] . "'>" . $row['Language'] . "</option>"; …
by Rishi_3 in Web Development ()
Member Avatar
Hi, can we import .xls file in mysql? or how to upload .csv(Comma delimited) with multiple language using Load data? how to save multiple languages in .csv(Comma delimited) ?
by AntonyRayan 15 in Web Development ()
Member Avatar
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 …
by Muaz_1 in Databases ()
Member Avatar
Hi, I am new to this concept. How to export data from database in EXCEL for various standards with "dynamic headings" .
by AntonyRayan 15 in Web Development ()
Member Avatar
<?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']; …
by kingwash in Web Development ()
Member Avatar
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 …
by Amaina 14 in Web Development ()
Member Avatar
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 | …
by Amaina 14 in Web Development ()
Member Avatar
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 …
by שנהב in Programming ()
Member Avatar
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 …
by A_7 in Databases ()
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
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 …
by rheiniel 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
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
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
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
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 ()