Hi...
I have a navigation that has a list of employee name. And i used up and down key to see the names and i click enter key to view the data of that employee.Now, I want to have a color the name...
Type: Posts; User: newphpcoder; Keyword(s):
Hi...
I have a navigation that has a list of employee name. And i used up and down key to see the names and i click enter key to view the data of that employee.Now, I want to have a color the name...
Hi...
I have a button to generate data or save all data in the database.
Now, I want that when i click the button to generate data it will not save all data, i want first appear an alert or...
Hi
Before, I got a problem in using arrow up and down key in choosing employee name.. And now with the help of other I fixed it, but now I got an problem when I search the name of employee his...
I already change the post_max_size but still it did notwork...what is the used of BLOB?
Thank you
Hi..
I don't know if it is javascript or css issue.
I have a navigation list of my employee names and when I click the name his data will display at the right side.
I used onclick for...
Hi
I have a login page from login.php login.tpl
and after i login it will redirected to index.php which has a four templates.
I want to happen is to merge the login and index.php I mean the...
Hi
I have a problem in importing .xml files in my mysql database. my .xml file is also more than 3mb, so i change in my php.ini the upload_max_filesize = from 2MB to 100MB and also i change the...
I also tried to var_dump the $conn2
and the output is:
object(ADODB_mysql)#4 (66) { ["databaseType"]=> string(5) "mysql" ["dataProvider"]=> string(5) "mysql" ["hasInsertID"]=> bool(true)...
I tried to var_dump the $updateSQL and the result is:
UPDATE payroll.other_deductions SET BurialSeparationCont = 5, TaxAjt = 10, CashAdvance = 10, AdvanceShirt = 10, AdvanceMed = 10, AdvanceOther...
Good day!
I have if and else statement for update and insert data to database...
But only the insert statement was work or satisfied,
here is my code:
<?php
I tried this code: and I add Ref_No in my table
$sql = "SELECT em.EMP_ID, em.EMP_NO, s.Ref_No s.RangeCompensation, s.MonthlySalaryCredit, s.EmployeeShare
FROM $PAYROLL.sss s,...
Good day!
I have table in my database which I could check the range of compensatin,monthly salary credit, monthly contribution.
Now i am in the process of analyzing how can I get the monthly...
I'm not good in javascript, I encountered error in auto compute of Total Take Home Pay.
I want to happen is when i add other deduction also the take homepay will change.
Take home pay =...
Good day!
Theirs a programmer told me that could I used Union Statement to solve my issue in my query, but i can't imagine how can I do that, because my query I used case statement, I have no idea...
I tried new autocomplete from http://papermashup.com/jquery-php-ajax-autosuggest/ and i revise the code:
I change the autosuggest.php
before the code is like this:
<?php
$db = new...
I found an autocomplete by this link:
http://docs.jquery.com/Plugins/autocomplete
I want this because its simple, but the data is came from var data, but in my case, the data that I want to...
I tried to add the code from planetsourcecode, and my problem is automatically the data was display at the top without searching.
here is my revise code:
<?php
include("config.php");...
Hi
I found this code in internet, and i want to used it , but my database is mysql not mysqli, how can I change my syntax.
<?php $db = new mysqli('DB_HOST', 'USERNAME' ,'PASSWORD',...
I found sample autosuggest:
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?lngWId=8&txtCodeId=2492
I tried to use this in my code, but it did not work..
Here is my code where i want...
Good day!
I need an autosuggest/autocomplete script for my field Name..
I search code for that but when I tried it in my webpage it did not work. I used smarty template, php and mysql-adodb.
...
Good day!
I have Hours field in my database and the datatype is time, I have template that displayed the data of Hours, the data in database is like this 40:00:00 , I want to display the value in...
I tried this query:
UPDATE employee SET rendered = sec_to_time(time_to_sec('08:00:00') +
case
when time_to_sec(time(timein)) < time_to_sec('21:35:00') then 0
...
Is there any snytax/query except case statement if impossible to get the rendered from timein and timeout correctly?
The case statement that I post is produce correct data in oly one shift, the rest...
I have 3 shifts 21:35:00 to 05:35:00 , 05:35:00 to 13:35:00 , and 13:35:00 to 21:35:00
I have this data in my database:
EMP_NO| timein| timeout |total| rendered
DS-1001 2011-10-01 21:35:00...
I change my syntax from insert to update because the total field will only update because they are in same table of timein and timeout, so I used this syntax and i test it in mysql:
UPDATE...