- Strength to Increase Rep
- +15
- Strength to Decrease Rep
- -3
- Upvotes Received
- 269
- Posts with Upvotes
- 244
- Upvoting Members
- 149
- Downvotes Received
- 17
- Posts with Downvotes
- 16
- Downvoting Members
- 17
- Interests
- Data transformation and migration
- PC Specs
- LAMP, Msaccess, Mssql server. VB.NET
1,257 Posted Topics
Re: 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 … | |
Re: 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] | |
Re: 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; } | |
Re: You can look joomla,wordpress, magento(inventory/store) demos on their sites for crm. I am not sure about ERP. | |
Re: 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 … | |
Re: 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 … | |
Re: 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 ; | |
Re: 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 | |
Re: Dear larry You need not to have two triggers. Only before insert trigger is fine. | |
Re: 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] | |
Re: 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/ | |
Re: i Hope sysadmin/sysadmin may work | |
Re: problem in line number 12 of first code block $controller->index(); change above to $controller->Index(); | |
Re: getlisted function must return array either first or second you passing, or anything you process convert it to array and return it in getlisted | |
Re: 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', … | |
Re: 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 | |
Re: 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 | |
Re: 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']}"; | |
Re: 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 … | |
Re: 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 … | |
Re: I used following excel plugin, its very convenient https://www.mysql.com/why-mysql/windows/excel/ | |
Re: 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>"; | |
Re: 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 | |
Re: 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. | |
Re: change line number 13 with follwing line, comment your if condtion if (in_array($loc_con1[$j], $loc_con)) | |
Re: I think wriring html code within script is creating problem, keeep document.write fucntion comented or write them with with normal/standard html | |
Re: 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 … | |
Re: Learn here on your own without any help http://www.w3schools.com/php/default.asp | |
Re: I too feel that it was hourly website now its daily one. | |
Re: 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; … | |
Re: 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"; ![]() | |
Re: 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 | |
Re: 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. | |
Re: 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 … | |
Re: 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. | |
Re: 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 ![]() | |
Re: 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 … | |
Re: What you have done so far, submit it here? | |
Re: 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. | |
Re: 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 | |
Re: try to keep h:/path not semicolon put it as colon and restart apache service Though I am not sure | |
Re: I used to make exhaustive use of database constraint and features to deal with idotic input from users and super idotic code from developer. | |
Re: try to change collation to utf8_general_ci of the column where you store your malyalam content | |
Re: Code seems to be fine, what error message you are getting. | |
Re: 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 … | |
Re: 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 | |
Re: 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] |
The End.