-
Replied To a Post in How to use $l_filename in <a href
1. What you are showing seems to be file upload part. 2. File content function not visible in your script. i.e. move_uploaded_file() to be moved to your folder. 3. Href … -
Replied To a Post in How to create a selectable list from sql results
1 use bootstrap css or any other you know for row hover https://www.w3schools.com/bootstrap/bootstrap_tables.asp 2 put your table under < form > tag Add one more th/td in header and whole … -
Replied To a Post in MYSQL 8 Query Join Problem
You may try following UPDATE download LEFT JOIN lookup ON download.ip_address between lookup.start_ip AND lookup.end_ip SET dowload.ref = lookup.id ; -
Replied To a Post in I need help with "before insert" Trigger
Dear larry You need not to have two triggers. Only before insert trigger is fine. -
Replied To a Post in MySql GROUP BY on script
You can use group_concat funtion SELECT col1_id, col1_name, GROUP_CONCAT(DISTINCT col2 ORDER BY col2 SEPARATOR ';') FROM table GROUP BY col1_id, col1_name http://www.mysqltutorial.org/mysql-group_concat/ -
Replied To a Post in Error in CRUD in PHP
run this query in backend phpmyadmin or any tool you have directly. You may find error there, solve and fix your query in your code. SELECT * FROM tb_pedido Pp … -
Replied To a Post in Column count doesn't match value count at row 1
specify column names as shown in following query. Make sure you spell column right as its in your table. There are more columns in your table then in your $variable … -
Replied To a Post in PHP Fatal error: Uncaught Error: Call to a member function....on null
problem in line number 12 of first code block $controller->index(); change above to $controller->Index(); -
Replied To a Post in PHP Warning: count(): Parameter must be an array or an object that impleme
getlisted function must return array either first or second you passing, or anything you process convert it to array and return it in getlisted -
Replied To a Post in Problem on calculating total in different modals
When you add any element with same name again the way if you have only set of elements then code is like `document.formname.elements['elename'].value` if you have more than one set … -
Replied To a Post in Oracle SQL. How to output more than one record?
No need to do loops now Listagg function may help you https://docs.oracle.com/cloud/latest/db112/SQLRF/functions089.htm#SQLRF30030 You can convert multiple records to single row as per your wish and with better performance -
Replied To a Post in Upload img Help
I assume you set session variable USERNAME OR USERID, when user logins So same can be used as path for your folder when he upolads anything $uploadpath="/webfolder/docfolder/{$_SESSION['USERID']}"; -
Replied To a Post in how to print payslip for each employee using javascript
You have to use only one fpdf object for whole process Loop through alll payslip record you have already written code for one payslip, so put that code in your … -
Replied To a Post in How to prevent PHPMail from sending when a page refresh
You can use browser cookie for same. 1) When page is loaded first set cookie say 'sendmail'to 0 in bottom of page in javascript. 2) on click of button to … -
Replied To a Post in MYSQL Excel Upload
I used following excel plugin, its very convenient https://www.mysql.com/why-mysql/windows/excel/ -
Replied To a Post in Problem with simple echoing a form
Remove curly braces around $_server variable, its used when you want to embed variable in string. echo "<form action ='<?=$_SERVER[PHP_SELF]?>' method = 'POST'/>"; echo "<input type='submit' name='off' value='Turn OFF Grow … -
Replied To a Post in Excel Upload fast
If you can change preference of file type, from excel to csv then after uploading csv file to server, you can use "load data infile" available in mysql http://dev.mysql.com/doc/refman/5.7/en/load-data.html -
Replied To a Post in PHP and JS Forms
You can put one more hidden variable in your form. Like type of post <input type=hidden name=method id=method value=''> before submitting set appropriate value whether method is post or ajax, … -
Replied To a Post in How do you change a value inside a variable
Learn here on your own without any help http://www.w3schools.com/php/default.asp -
Replied To a Post in Anyone Else Seeing DaniWeb Activity Dropping?
I too feel that it was hourly website now its daily one. -
Replied To a Post in query result
put 2 lines in your code after inculde statement, run the page and it will show you error /notice/warning include('dataentry/update-connect2.php'); error_reporting(E_ALL); ini_set("display_errors", 1); $sql="SELECT * FROM photos Order by stageno … -
Replied To a Post in populating value in the second textbox based on the value entered in first
You need jquery. Fire onblur even on first textbox entered call server page using jquery to fetch data from database based on first input get response and fill second box … -
Replied To a Post in Inserting data without disabling foreign keys
You need to prepare your script according to the dependencies. If you can sequence insertion script properly, no problem you will face. You need to study all foreign keys and … -
Replied To a Post in how to select single record from each year of last ten year ?
Here I am using direct year value instead of date in your $year_x variable. You must try to fetch query from database at once. You are firing same query every … -
Replied To a Post in Barcode scanner to scan tools in asp.net using vb
1) Decide which value you want to show as barcode, like say ITEM CODE 2) You can use font for displaying on report/page to display code in barcode format 3) … -
Replied To a Post in What is your preference when checking boolean values in If statements?
1) if(Method()==true) in this case code under if will only run if Method() return boolean true 2) if(Method()) in this case code under if will always run if Method() return … -
Replied To a Post in Mysql Count Number of rows
select a.Cutomer_id, a.Customer_Name, b.total1, c.total2 from Customers a left outer join (select customer_id, count(*) total1 from order1 group by customer_id) b on a.customer_id=b.customer_id left outer join (select customer_id, count(*) total2 … -
Replied To a Post in PHPExcel Grandtotal Error
Yes exactly put line 17-18 inside while loop. -
Replied To a Post in PHPExcel Grandtotal Error
Before line number 100 that is before ending while loop break the loop break; } //end of while OR fix the while loop query code (LINE 21), it is giving … -
Replied To a Post in Passing standard ID and section ID while onclick radio button
What you have done so far, submit it here? -
Replied To a Post in Trigger
It not possible to do any operation on same table whose trigger you are writing. -
Replied To a Post in select query to display username as email address
select concat(username,'@irma.ac.in') as email from student -
Replied To a Post in ORA-01403"no data found"
select deptid, deptname, location, employeeid into v_deptid, v_deptname, v_location, v_employeeid from dept where deptname = 'SALES'; Run this query directly in sql developer or terminal. See what data comes. Oracle … -
Replied To a Post in Relational Database in the cloud
I used to make exhaustive use of database constraint and features to deal with idotic input from users and super idotic code from developer. -
Replied To a Post in Google input tools fonts are not rendering in the website
no utf encode is needed in php just data base column in mysql need to be utf8_unicode_ci -
Began Watching Google input tools fonts are not rendering in the website
Iam facing a problem, Google input tools fonts are not rendering in my website. iam creating a website which support multi language to type. I have typed in malayalam and … -
Replied To a Post in Google input tools fonts are not rendering in the website
try to change collation to utf8_general_ci of the column where you store your malyalam content -
Began Watching Counting lates of employees
Hello I have created an attendance system but client requested to include a new fucntion iin it. Like there if employe comes and time in after the set time its … -
Replied To a Post in Urgent Need help PHP and MySQL stuff
Code seems to be fine, what error message you are getting. -
Began Watching Urgent Need help PHP and MySQL stuff
I need to create a form in php and mysql in which it will create a table on a default set database for example "ramgest" and i want it to … -
Replied To a Post in Notice: Undefined index: Du in C:\wamp\www\exercise\confirmation.php on lin
its not error, its warning, YOu can disable warning in your php.ini configuration file and restart apache service Make sure following line is off instead of on display_errors = Off -
Replied To a Post in Counting lates of employees
Run query in phpmyadmin select date_format(p_date,'%b-%Y'), user_id , sum( if(str_to_date(concat(p_date,' ',timein),'%Y-%m-%d %H:%i:%s') > str_to_date(concat(p_date,' ',clock_in_eve),'%Y-%m-%d %H:%i:%s') ,1,0)) late_days from presence group by date_format(p_date,'%b-%Y'), user_id having late_days>0 order by date_format(p_date,'%b-%Y'), user_id -
Replied To a Post in How to push data from one page to another [PHP]
This is not good idea what you want. You are making life of admin difficult. But still it is possible In user_quiz table , you can keep column last_question_sent So … -
Began Watching how to mark first value with new and the following with same value as old
I need check among items entering session array.Say $a=1, if $a enters the array for the first time then mark it new.Else if the same $a entered the array more … -
Replied To a Post in how to mark first value with new and the following with same value as old
Explain your case with more details. What you have and what you want to do. -
Replied To a Post in Linking multiple entries to a particular User email/Id in a database
yes, you are right For courses table Case 1 (if one person is going to learn subject only once in life time) keep 2 cols (subject_id, email_id) as primary key … -
Replied To a Post in can we pass values bw php and table
<table> <tr> <td> VALUE OF A</td> <td> <?php $a=10 ; echo $a; ?> </td> </tr> </table> -
Replied To a Post in can we pass values bw php and table
Embeding is something empower html http://www.w3schools.com/php/default.asp -
Began Watching can we pass values bw php and table
hello, i want to show mysql query results into a table on a web page...but can i pass variable values from html tp php script i wanna show as it … -
Replied To a Post in Linking multiple entries to a particular User email/Id in a database
Your case can be solved by using composite key (2 or more column together makes primary key of table) You can make (email_id, subject, year) as primary key If You …
The End.