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
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
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 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 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 ()
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 ()