PriteshP23

Hello, I have one query with timestamp. I got below error. select users.login, FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(ticket_history.create_time)-UNIX_TIMESTAMP(ticket.create_time))) from ticket_history_type inner join ticket_history on ticket_history.history_type_id=ticket_history_type.id inner join ticket on ticket.id = ticket_history.ticket_id inner join users on users.id = ticket_history.change_by where ticket.create_time BETWEEN '2014-10-01' AND '2014-10-15' AND ticket_history.name ='%%new%%Fermeture réussie%%' group by users.id *`error: function …

Hello, I have used Single Translation Table Approach to make multilanguage site in PHP. You may see [here](http://www.apphp.com/tutorials/index.php?page=multilanguage-database-design-in-mysql#single_translation_table_approach) The current index page is not working. My objective is to have one example to use these tables and display one working page. For example: It should work like [this](http://demo.codeursolitaire.com/multilanguage/index.php) **by using …

Hello, I have one big XML file (600 MB - 850 MB) in format "**cells_yyyymmdd_hhmi.xml**" I would like to specify that everyday i will have new file with new date. So, *there should be general way to read it and cut it*. For exmaple, i have file of 7th January. …

Hello, I have csv filename with date. Everyday i have same csv file with respective date. I need to read filename (*everyday date changes in filename*) and do operation. For example, I have file "**cells_20140106_165532.csv**". I did like this to read it in general: $filename = "cells_".date('Ymd_hmi').".csv"; $file_contents = file_get_contents($filename); …

Hello, I have one "**tar.Z**" file. Objective is to unzip it by shell script and check the date. * archive: filename_20140103_1540.tar.Z #!/bin/bash cd $REP_DATAS/path u=$(date +%u) if [ ${u} -eq 1 ] ; then dateQ=`date --date='-3 day' +'%Y%m%d_%H%m'` else dateQ=`date --date='-1 day' +'%Y%m%d_%H%m'` fi tar xvf filename_"dateQ".tar.Z > error: > …

Hello, I have one tar.Z file. I have to run shell script **daily** as it is required to update the database. customer_yyyymmdd_hhmi.tar.Z sales_ yyyymmdd_hhmi.csv (5 MB - 20 MB) purchase_ yyyymmdd_hhmi.xml (650 MB - 950 MB) I have made small part of XML file. There are 4 parts. There is …

I need urgent help. **When i turn on my laptop, it reboot and/or SCAN whole laptop with C Drive.** How to solve this? Thanks in advanced.

Hello, I would like to solve form validation and filename problem. Here is my code: /************************** Step 1: Select Cell************************************/ if(isset($_POST['SmartPhone'])) $checked1=$_POST['SmartPhone']; $form->add_checkbox('SmartPhone','SmartPhone',$checked1); if(isset($_POST['Apple'])) $checked2=$_POST['Apple']; $form->add_checkbox('Apple','Apple',$checked2); /************************** Step 2: Select Model************************************/ if($_POST['SmartPhone']==false and $_POST['Apple']==false) { $this->add(new error('<span style="color:red">Select your cell..!!</span>')); $this->step1(); return; } if(isset($_POST['S4'])) $tech2=$_POST['S4']; $form->add_checkbox('S4','S4',$tech2); if(isset($_POST['iPhone 5'])) $tech3=$_POST['iPhone 5']; …

I need urgent help. I need ONLY select ALL button for my code: if($_POST['SmartPhone']==false and $_POST['Apple']==false) { $this->add(new error('<span style="color:red">Select your cell..!!</span>')); $this->step1(); return; } if(isset($_POST['S4'])) $tech2=$_POST['S4']; $form->add_checkbox('S4','S4',$tech2); if(isset($_POST['iPhone 5'])) $tech3=$_POST['iPhone 5']; $form->add_checkbox('iPhone_5','iPhone 5',$tech3); if(isset($_POST['iPhone 5s'])) $tech1=$_POST['iPhone 5s']; $form->add_checkbox('iPhone_5s','iPhone 5s',$tech1); //In addition, i want to know how to put "Select …

PFA...!! **Please look at the table data carefully.** I need to delete the rows. I need urgent help..!! Table: CREATE TABLE IF NOT EXISTS `version` ( `nidt` varchar(11) NOT NULL, `noeud` tinyint(3) NOT NULL, `VERSION` float NOT NULL, `ETAT_FONCT` varchar(20) default NULL, `idnap` varchar(25) NOT NULL, `nidtint` bigint(20) NOT NULL …

I need to develop Feedback module in PHP/MySQL. **I would like to know the database design and flow to manage this system.** > There are questions for 2 tools which i need to store in my databse and need to create report like %of Positive Response, % of Negative Response, …

This query is not working. I need urgent help. Thanks a lot in adv. **ROWS affected: 0** I have cross checked the data in the table for the given condition. $sql = 'UPDATE LTE_noria_cellule cel_bk_up SET cel.NAP_'.$site->ur().' = '1' '. 'WHERE cel.nidt IN ( select gn from LTE_noria_candidat_bk_up can INNER …

I would like to get Type, Id and Height values in database table. It is not working. There is no error message. Objective is to get RESPECTIVE "Type" from Catalaog which has same Reference from Installed. Well, I have 850 Mb XML file and i just would like to present …

I am trying to read XML file and store in sql table. I got two errors. PHP Warning: XMLReader::open(): Unable to open source data Warning: XMLReader::read(): Load Data before trying to read // In addition, Please let me know the filename in below cases. case 1: Code: Select all $reader->open($topdir."/nap/".$code->no()."_city.xml"); …

I am not able to insert data from CSV file with "¤" Character. Please help me to solve the problem. Thanks a lot in advanced. CSV File: FirstName¤LastName¤City¤Year |$| Bill¤Gates¤NW¤2013¤|$| David¤Beckham¤London¤2010¤|$| PHP Code: $csv_file = "Contacts.csv"; $csvfile = fopen($csv_file, 'r'); $theData = fgets($csvfile); $i = 1; do { $insert_csv = …

How to read **550 MB** XML file in php? I couldn't put data in php file like: $xml =<<<EOT <?xml version="1.0" encoding="utf-8"?> <data> ..... ... </data> EOT; In addition, when i did from command line, it "**kill**" the process. *Any idea ?*

I have 3 tables as mentioned below: Users Code Name NW London 1 Bill ---- ---- Contacts Code Country 1 USA Location Country City USA NW I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i …

I would like to get **all** Equipment values. *I have used DOM Document.* It is reading **ONLY LAST Element**. *Equipment Id: 28*. I need all three. Thanks in advanced. XML File: <?xml version="1.0" encoding="UTF-8"?> -<Physical> <Catalog> </Catalog> -<Installed> -<Equipment> <Id>26</Id> <Ref>Tew12</Ref> -<Characteristic> <CharacteristicName>Height</CharacteristicName> <CharacteristicValue>160</CharacteristicValue> </Characteristic> -<Characteristic> <CharacteristicName>Tilt</CharacteristicName> <CharacteristicValue>30</CharacteristicValue> </Equipment> -<Equipment> …

I want to do in French (By default) & seconadry option is English. I have a *two image flag* on login.php page. It should **ALWAYS** visible in the site. I created two files lang_FR.php and lang_EN.php. *How one set French as default language and translate it according user choice ?* …

I had saved files in folder "uploads".I want to display uploaded filename in the table. There are two files. london.jpeg & usa.pdf Table: no Name File 1 abc london 2 xyz usa When one click on london or usa, one should able to see the file. I need urngent help. …

I would like to get name of Tilt and its value 30. I am not able to get the value of Tilt. Let me know if you have any idea. Thanks in advanced. XML File: <?xml version="1.0" encoding="UTF-8"?> -<Physical> <Catalog> </Catalog> -<Installed> -<Equipment> <Id>26</Id> <Ref>Tew12</Ref> -<Characteristic> <CharacteristicName>Height</CharacteristicName> <CharacteristicValue>160</CharacteristicValue> </Characteristic> -<Characteristic> …

Hello All, Objective is to manage **radio button Dynamically**. One should be able to *add/delete radio button by ADD and DELETE button* in form. To make CLEAR the question, please look at the image "BUTTON". In addition, it should be displayed with updated values (*Need to manage from database side …

It is not working AFTER refresh anymore: // php <div style="padding-left:280px;"> <!-- Add --> <input type="button" class="btnAjouterConfigure" id="add" value="Ajouter" style="text-decoration:none; width:100px; height:41px; line-height:34px; font-weight:bold;" onclick="addnature()"/> &nbsp; <!-- Delete --> <input type="button" class="btnSupprimerConfigure" id="delete" value="Supprimer" style="text-decoration:none; width:100px; height:41px; line-height:34px; font-weight:bold;" onSubmit="return deleteRadioButton();"> <div id="fooBar"></div> </div> <br /> <div style="height:auto; padding-left:280px;" id="mainRadio"> …

I am beginner at AJAX. There are two Select Menus: Month & Year. The objective is to display data in the table **AFTER selection of YEAR**. Based upon selected values data should be displayed in the table. Thanks a lot in advanced. <!DOCTYPE html> <?php $year=$_GET["year"]; $month=$_GET["month"]; $year = array( …

Hello friends Please give me the answer.

I would like to solved out the SESSION part in ALL files. SESSION is not working properely anymore. In addition, i need to solved out the javascript errors. Objective is to access the *dashboard.php and other pages* from LOGIN.php and CREATEACCOUNT.php **WITH validation and SESSION**. There are two files: login.php …

Session is not working. When user do Sign IN or Sign UP, after that on every page (dashboard.php and configure.php) user email should be displayed. It is not displaying any error but it is not working. I have used md5 method for password. I have problem regarding set session. Let …

JavaScript is not working: // HTML <form id="formLogin" name="formLogin" method="post" action="" onsubmit="validateForm(this) /"> <div class="divLogin"> <table> <tr> <td> Enter your Email: </td> <td> <input type="text" id="checkemail" name="txtEmail" required="required" autocomplete="off" /> </td> </tr> <tr> <td> Enter your Password: </td> <td> <input type="password" id="checkpwd" name="pwd" minlength="6" required="required" autocomplete="off" /> </td> </tr> </table> …

Hi friends, Waht are the differences between Sessions and cookies in PHP? Please explain with examples. Thanks & Regards Jasonmark

I have a search form with only one text field. The problem is that the width of that `text field` is not same. the style is form#index-table-form input[type="text"] { width: 106px; height: 24px; position: absolute; outline: none; right: 0; top: 6px; border: 1px solid #3772af; padding-left: 6px; padding-right: 24px; font-family: …