16 Posted Topics
Re: The error says that MySQL socket is corrupted. You may ask your server admin to fix it. | |
Re: You can use `filter_var($input, FILTER_VALIDATE_INT)` in PHP to validate the user input. Replace `$input` with the value entered by the user. | |
Hi, IS there any way to load a `*.dll` file at run time into PHP project. For instance I want to use the functionality for encrypting the a string using `MCRYPT` module without installing the module. I found on internet that with the usage of `COM` class I can achieve … | |
Hi, I am working on an aplication which contains two different portals (admin and members). `http://localhost/app/` is used for the members login and `http://localhost/app/admin` is used for admin's login. When I log in into members and admins portal both works fine but if I logout from one portal another portal … | |
Re: Check this: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html | |
Re: For the usage of 'telnet' on Windows, you need to install the 'Telnet Client' on your system. To install the 'Telnet Client' follow the instructions: 1. Start Server Manager. Click Start, right-click Computer, and then click Manage. 2. If the User Account Control dialog box appears, confirm that the action … | |
Re: To achive this you need to make sure that the each query is written in a single line; so that we can convert each line into an array index. Example: $arrayQuery[0] = 'Here goes the first query' $arrayQuery[1] = 'Here goes the second query' Following is the code: <?php $arrayQuery … | |
Re: Use the following query: SELECT orderlist_id, brandname, packsize, quantity, mrp, ourRate, Sum, user_id, userName, date FROM orderlist WHERE user_id = '$userid' AND userName = '$usern' AND date >= NOW() - INTERVAL 3 MONTH; | |
Re: Where you defined `getStyle()` function? | |
Re: Instead of using comparison operator (`>=`) and logical operator (`AND`) you can use the `BETWEEN` operator. `BETWEEN` operator process the query fast as compare to comparison operator and logical operator. Use the following query to get your result. `SELECT * FROM report_card_table WHERE expirydate BETWEEN CURRENT_DATE() AND DATE_ADD(CURRENT_DATE(),INTERVAL 3 MONTH);` | |
Re: $UserName, $Password, $Name are always used as `VARCHAR` in database. So you have to change your query to: `INSERT INTO users (username, passward, name) VALUES ('$UserName', '$Password', '$Name')` Moreover you select only 3 columns to insert the values but you were inserting 4 values. I removed `NOW()` from your query. | |
Re: To achive this you need to use Ajax. Please share your database structure and HTML Form you designed for your application so that I can work on this. | |
Re: Your code seems correct, please share your table structure so that I can check further. | |
Re: Yes, storing the large session data may slow down the web server. To overcome this issue I highly recommend you to install MemCacheD on your server. | |
Re: To achive this you need to change 'item type' inside the form as follows: <?php // Make a MySQL Connection mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("pinjaman") or die(mysql_error()); // prepare a qurey $query = "SELECT item FROM tablename"; // here you need to change the 'tablename' as per your table … |
The End.