Posts
 
Reputation
Joined
Last Seen
Ranked #146
Strength to Increase Rep
+15
Strength to Decrease Rep
-3
93% Quality Score
Upvotes Received
269
Posts with Upvotes
244
Upvoting Members
149
Downvotes Received
17
Posts with Downvotes
16
Downvoting Members
17
65 Commented Posts
19 Endorsements
Ranked #75
Ranked #46
~667.74K People Reached
Interests
Data transformation and migration
PC Specs
LAMP, Msaccess, Mssql server. VB.NET
Favorite Tags
php x 1K
mysql x 484
mssql x 119
sql x 112

1,257 Posted Topics

Member Avatar for David_140

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 INNER JOIN tb_cliente C ON Pp.codCliente = C.codCliente INNER JOIN tb_funcionario F ON Pp.codFuncionario = F.codFuncionario INNER JOIN tb_produto P …

Member Avatar for Rose_17
0
505
Member Avatar for jyotiu

You can execute following query to determine whether new reservation for any room is confilicting with existing reservation for that room. [code] select * from reservtable where '{$fromdate}' <= check_out_date and '{$todate}'>= check_out_date and room='{$roomno}' [/code]

Member Avatar for Ahmad_74
0
2K
Member Avatar for stokie-rich
Member Avatar for wackyal

this is simple php email checker, use this to get your task completed function checkEmail($email) { if (!preg_match("/^([a-zA-Z0-9\._-])+([a-zA-Z0-9\._-] )*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/" , $email)) { return false; } return true; }

Member Avatar for Dani
0
4K
Member Avatar for amanu092

You can look joomla,wordpress, magento(inventory/store) demos on their sites for crm. I am not sure about ERP.

Member Avatar for Rajesh_48
0
807
Member Avatar for larry29936

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 link to download file can be rendered in html emebded with php loop of file table. echo "<a href='http:domain/contentfolder/{$filename}' target='_blank'>download …

Member Avatar for larry29936
0
170
Member Avatar for Greg_11

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 loop. .. . . <th width="5">select row</th> <th width="5">ID</th> . . While.. .. . . echo '<td><input type=radio name =selrow …

Member Avatar for JeanMilburn
1
361
Member Avatar for larry29936

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 ;

Member Avatar for pritaeas
0
273
Member Avatar for akgreen

This kind of solution is useful where php mysql application is build for internal use like in intranet enviroment. Some time operator at reception need to print receipts and bills directly for the customer, there this will help

Member Avatar for Yogesh_22
7
23K
Member Avatar for larry29936

Dear larry You need not to have two triggers. Only before insert trigger is fine.

Member Avatar for larry29936
1
257
Member Avatar for noelpasia

Visit following post and go through all comments, I think you will find proper solution [url]http://www.daniweb.com/web-development/php/threads/366629[/url]

Member Avatar for FOURATI
0
3K
Member Avatar for SimonIoa

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/

Member Avatar for jamesdave
0
3K
Member Avatar for VenusCrystal
Member Avatar for Gurjit_2

problem in line number 12 of first code block $controller->index(); change above to $controller->Index();

Member Avatar for Gurjit_2
0
898
Member Avatar for janicemurby

getlisted function must return array either first or second you passing, or anything you process convert it to array and return it in getlisted

Member Avatar for ryantroop
0
720
Member Avatar for Anthony_22

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 list (line 41). $sql = "INSERT INTO `User` (firstname,lastname, addresslin1, addresslin2, postcode,city, email,password,dttime, verificationcode, status)". " values ". "('$FirstName', '$LastName', …

Member Avatar for urtrivedi
0
546
Member Avatar for Med_2

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 of elements with same names document.formname.elements['elename'][0].value document.formname.elements['elename'][1].value

Member Avatar for urtrivedi
0
282
Member Avatar for Prosatanos

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

Member Avatar for urtrivedi
0
396
Member Avatar for mubashir_2

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']}";

Member Avatar for urtrivedi
0
160
Member Avatar for Ritesh_8

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 above loop when next record start add page to your fpdf object output your fpdf object after loop ends javascript …

Member Avatar for urtrivedi
0
7K
Member Avatar for cainam29

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 send mail set cookiet in javascript 'sendmail'to 1, call php mail handler. 3) When php code is executed check cookie …

Member Avatar for urtrivedi
0
1K
Member Avatar for AntonyRayan

I used following excel plugin, its very convenient https://www.mysql.com/why-mysql/windows/excel/

Member Avatar for urtrivedi
0
301
Member Avatar for Cody_4

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 Light'/>"; echo "</form>";

Member Avatar for Cody_4
0
398
Member Avatar for AntonyRayan

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

Member Avatar for urtrivedi
0
189
Member Avatar for James_43

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, same can be captured in your php handler.

Member Avatar for jacks009
0
235
Member Avatar for amith_ami

change line number 13 with follwing line, comment your if condtion if (in_array($loc_con1[$j], $loc_con))

Member Avatar for rayearth_1
0
10K
Member Avatar for mblan180131

I think wriring html code within script is creating problem, keeep document.write fucntion comented or write them with with normal/standard html

Member Avatar for mblan180131
0
223
Member Avatar for geoamins2

write two php files, one for showing all other data file 1.php 1)fetch data from mysql with primary key 2) show all columns 3) <img src='file2.php?imgid=currid'> file2.php //it will contain code you have written to show image in your post above, but it will use one get parameter to load …

Member Avatar for Pallavi_1
0
1K
Member Avatar for jelly46
Member Avatar for urtrivedi
0
203
Member Avatar for JOSheaIV
Member Avatar for amith_ami

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 time for each year, so It is causing time delay. $year_1=2005; $year_2=2006; $year_3=2007; $year_4=2008; $year_5=2009; $year_6=2010; $year_7=2011; $year_8=2012; $year_9=2013; $year_10=2014; …

Member Avatar for amith_ami
0
341
Member Avatar for wikit

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 asc";

Member Avatar for diafol
0
183
Member Avatar for jiah2345

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 with response watch the link https://www.youtube.com/watch?v=a-uu3LTT-Lc

Member Avatar for urtrivedi
0
103
Member Avatar for Ian_7

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 based on that design which table insert will go first and so on till last table.

Member Avatar for urtrivedi
0
236
Member Avatar for Deva Kaur

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) for eg. if your code is LIKE XYZ3949, you need to encapsulate it with asterisk mark , *XYZ3949*, and display …

Member Avatar for pritaeas
0
346
Member Avatar for zachattack05

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 any value. It will not run for false/blank/null.

Member Avatar for JOSheaIV
0
574
Member Avatar for ribrahim

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 from order2 group by customer_id) c on a.customer_id=c.customer_id

Member Avatar for diafol
0
277
Member Avatar for ehpratah

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 more then one record i guess. OR If you generating mulitple files, then intialise excel object inside while loop and …

Member Avatar for ehpratah
0
626
Member Avatar for AntonyRayan
Member Avatar for Dili1234

It not possible to do any operation on same table whose trigger you are writing.

Member Avatar for Kuripaner
0
202
Member Avatar for Azii
Member Avatar for tony75

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 is case sensitive. Make sure "Sales" spelling match with case also.

Member Avatar for urtrivedi
0
247
Member Avatar for UK-1991

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

Member Avatar for UK-1991
1
745
Member Avatar for centenond

try to keep h:/path not semicolon put it as colon and restart apache service Though I am not sure

Member Avatar for Gaurav_20
0
936
Member Avatar for Dani

I used to make exhaustive use of database constraint and features to deal with idotic input from users and super idotic code from developer.

Member Avatar for Dani
0
253
Member Avatar for annya
Member Avatar for annya
0
413
Member Avatar for radu.campian
Member Avatar for TheEdsgurl

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 the moment user submits question, admin will see on his screen the last question submitted by all users. On admin …

Member Avatar for matrixdevuk
0
264
Member Avatar for lily90

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

Member Avatar for almostbob
0
441
Member Avatar for rajabhaskar525

You need to purchase packages from service provider, who will provide you the api and ip addresses for interfacing your website and their website for sending sms. [url]www.smsmuic.co.in[/url]

Member Avatar for Bishnoi_1
1
2K

The End.