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

Put NEW and updated data on the site, Not from google. Use metatag and target your visitors. Good Luck..!!

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> …

Session is stored in server but cookie stored in client. Session should work regardless of the settings on the client browser. There is no limit on the amount of data that can be stored on session. But it is limited in cookie. Session can store objects and cookies can store …

Try this: width:106px; position:relative;

How to fixed the layout of page for ALL screens? I mean to say on "ANY" size of COMPUTER SCREEN, Page-layout should be the same. In fact, i would like to put width:100% ONLY for header and footer. I would be more than happy IF i can have small EXAMPLE …

Hello, I would like to know the best way to design a website which one can have best view in Chrome, IE, Safari, Firefox, iPhone. In addition, css part should be easy to manage. For the moment, I have found many problems in css and the layout also. I would …

Line 35 should be changed. $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link);

I would like to design HTML form with css and validation. I want to have Textbox with colours indication. I have done with button to make it more meaningful. I would like to do same for the textbox. I want to have light blue colour bydefault and when one clicks, …

I would like to know why the content section is taking more width in my design page? Here is my CSS code : body { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; color:#414141 } p { padding-left: 10px; padding-right: 10px; } #wrapper { width: 100%; min-width: 100%px; max-width: 100%px; margin: …

I need your urgent help. Please help me to solve it out. Thanks a lot in advanced for your time. error: java.lang.StringIndexOutOfBoundsException: String index out of range: 150 Lines of code in this place there: if (text.length ()> 150) { text.replaceAll summary = ("<[^>] *>", ""). substring (0, 150) …

I want to display message box. I don't know why it is not working. Instead of "Already Registered..!!" message it displays " Duplicate entry 'test' for key 'nom' " . Thanking you in advanced. $query = " SELECT * FROM Humeur_log WHERE prenom = '".$prenom."' AND nom = '".$nom."' AND …

I want to display table by default in ascendind order with dynamically changing header. Here is my code. It is displaying the rows unordered. It should be in ascending at first look and then can change by column. $order = (isset($_GET['sortCostCode']) && strcasecmp($_GET['sortCostCode'], 'desc') == 0) ? 'DESC' : 'ASC'; …

I would like to know the best way to manage the two drop down menu on the PHP page. 1st menu : Select Type of House (House1, House2, ) 2nd menu : Select Number of Rooms (1,2 .. 12) The system should be displayed price based on selected items. Need …

I need to make time difference of 24 hours from registed time. In my database, there is column datelog with type "timestamp" Default value: CURRENT_TIMESTAMP I need the result if user with data: 2012-10-02 14:51:41 Test1 Test 2 User must not be able to register for next 24 hours. Thanks …

How to sort by column header dynamically in the table ? Table should be sorted by all column. <?php $order = (isset($_POST['sortCostCode']) && strcasecmp($_POST['sortCostCode'], 'desc') == 0) ? 'DESC' : 'ASC'; $query = 'SELECT * FROM `Humeur_log` ORDER BY `Humeur_log`.`logid` DESC LIMIT 0 , 30' . $order; $result = mysql_query($query); …

Hello Everyone..!! I am beginner at PHP. I would like to have solution for "\n" in textfile php. $file = "testFile.txt"; $fh = fopen($file, 'a+') or die("can't open file"); $firstname = $_POST["prenom"]; $lastname = $_POST["nom"]; $mood = $_POST["humeur"]; $datestring = date("d/m/y "); $timestring = date("H.i.s"); $data = "$firstname ; $lastname …