Hi, I can show data from the database using query [CODE=php] <?php $con = mysql_connect("localhost","root","root"); if (!$con) { die('Could not connect: ' . mysql_error()); } $a= $_POST["SiteId"]; mysql_select_db("abc", $con); $result = mysql_query("SELECT * FROM sitepinfo WHERE SiteId='$a'"); echo "<table cellpadding=2 cellspacing=2 width=100% > <tr> <th bgcolor=#5D9BCC>SiteID</th> <th bgcolor=#5D9BCC>Maintained By</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td bgcolor=#FEE9A9>" . $row['SiteId'] . "</td>"; echo "<td bgcolor=#FEE9A9>" . $row['MaintainedBy'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?> [/CODE] Now It shows for example 5 results , I want an Approve, Edit, and Delete button like image I Attached, please tell …

Member Avatar
Member Avatar
+0 forum 11

Dear All I have developed a lease management System. I have stored 4000+ Lease agreements and purchase orders. Folders Structure Main Folder : LAPO Subfolders: North , Center , South Subfolders : 1245 , 9867 like these (numeric) In each numeric folder there are 2 files LA.pdf and PO.Pdf How I can print them all

Member Avatar
Member Avatar
+0 forum 12

Hi, I am using XAMPP for developing my Inventory management system. I have stored the XAMPP in Drive C in Windows. But there is a risk if windows corrupt I will lose all my data , So I want to save the XAMPP in Drive D and acces all the pages stored in httdocs from Drive D . Please Guide me.

Member Avatar
Member Avatar
+0 forum 19

Hi, I have developed a website using Fireworks + Dreamweaver and website is for 1024X768 pixels. Now I want , it detects the browser and resolution of the user and if user resolution is 800X600 it shows a web page of 800X600 . i have developed in both resolutions. please guide me.

Member Avatar
Member Avatar
+0 forum 17

Dear Sir I am using PHP Mailer for SMTP Authentication, Everything is working fine [url]http://phpmailer.worxware.com/index.php?pg=methods[/url] But AddCC is not working , I am using Windows 2003 Server, and it says this function works with SMTP Mailer , not with the Mail Mailer. [quote]AddCC($address, $name = "") string $address string $name Adds a "Cc" address. Note: this function works with the SMTP mailer on win32, not with the "mail" mailer. [/quote] I can't Understand this line : Note: this function works with the SMTP mailer on win32, not with the "mail" mailer. [CODE=php]<html> <head> <title>PHPMailer - SMTP basic test with authentication</title> …

Member Avatar
Member Avatar
+0 forum 8

Operating System: Windows 2003 Server Using XAMPP Now , I have to develop a Scheduler for these reports, For Example I have 3 Reports. These reports are PHP Files Report1.php Report2.php Report3.php I want to send them(Execute them) automatically as follows Report1.php on Monday 9AM Report2.php on Friday 9AM And Report 3 on Saturday 12PM. Do you have any Idea?

Member Avatar
Member Avatar
+0 forum 14

Hi, all this is my file expire_show.php it shows expiry of those agreements which will expire with in 90 days from current date. Users have to login to their accounts for viewing these expiry alerts. but they require these alerts on their email. [B]1. how i can format these for email? 2 how I can send automatic email daily to selected persons?[/B][CODE=php] <?php $con = mysql_connect("localhost","root","root"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("onm", $con); $result = mysql_query("SELECT * FROM lease_center WHERE (current_date() >= (LAPeriodEnd - INTERVAL 90 DAY)) AND (current_date() <= (LAPeriodEnd - INTERVAL 0 DAY)) …

Member Avatar
Member Avatar
+0 forum 14

Whenever I tried to access Oracle DB from PHP , it shows error Everything is ok, Path is okay. I changed php.ini file to. I am using old version of xampp Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in E:\xampp\htdocs\Fuel\Fuel\server\inspur2.php on line 6 Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in E:\xampp\htdocs\Fuel\Fuel\server\inspur2.php on line 7 Warning: ocierror() [function.ocierror]: OCIError: unable to find error handle …

Member Avatar
Member Avatar
+0 forum 2

Hi, I have Folder Which Name is **LAPO** and There are three Folders insider whihc names are **North**, **Central** and **South**. In North Folder there are many Folders Like **9876** , **9877** , **9333**, **9853** etc. In all Folders there are files Named PO.pdf There are more then 1400 Folders in North Folder and I want to print all PO.PDF Files of North Folders ***Path will be LAPO/North/9876/PO.Pdf*** How I can Print all documents by just one instruction or one click and all pages will be printed via printer. All numeric ocdes like 9876 are also present in database (MySQL)

Member Avatar
Member Avatar
+0 forum 3

hi, all i need to add combobox in datagridview. actually i have 3 fields in database which are Sid Fee status what i want to add combo column in field [status] with two option PAID or UNPAID which a user can select and update it . i am all clear with filling the datagridview from database and updating but only problem is adding a combobox in third field that is status. i tried it with this [CODE] Dim combo As DataGridViewComboBoxColumn DataGridView1.Columns("combo") combo.Items.Add("PAID") combo.Items.Add("UNPAID") [/CODE] above code add the column with combobox but not with field status but as a …

Member Avatar
Member Avatar
+0 forum 2

I saved the link refrence in Databse like /PEDB/SupportDoc/5/PRFF or0444.pdf and used [ICODE]<a href=".$r1[10]." target=_blank>View</a>[/ICODE] to show the documents but when I click on view its not showing document because link break where space put in and show blank in explorer like /PEDB/SupportDoc/5/PRFF

Member Avatar
Member Avatar
+0 forum 14

Hi, I want to make a form , in which I have 4 input Fields. [LIST=1] [*]Date1 [*]Date2 [*]Calender Days [*]Working Days [/LIST] When I enter date1 as 2011-04-07 and date2 as 2011-04-11 Then I require in Calender Days = 5 inclusive of date1 and date2 and Working days = 3 as SAT, SUN Off

Member Avatar
Member Avatar
+0 forum 10

Hi, I have 3 feilds in my invoice processing Table. [LIST=1] [*]Submet [*]Return [*]Resubmitted [/LIST] Now I am using this query [CODE=mysql]SELECT `SRNo` , `VenName` , `Submet` , TO_DAYS( NOW( ) ) - TO_DAYS( `Submet` ) AS Days FROM `invmain` WHERE `Status` = 'SENT TO PAYABLE' AND `Submet` != '0000-00-00' ORDER BY Days DESC [/CODE] But this query give me result only on base of Submet. But I need result on Resubmitted also when its resubmitted. I need below mentioned Results... if Submet date is 2011-03-22 this will show days pending 2. But if Submet is 2011-03-10, but it will …

Member Avatar
Member Avatar
+0 forum 6

Dear All I have 2 Pages smtpAuth.php contents.php When I use this code [CODE]$body = file_get_contents('contents.php'); $body = eregi_replace("[\]",'',$body);[/CODE] It cannot show PHP variables values in Send email. Content.php file attached as contentsphpfile Whole HTML working fine but PHP DataBase values are not showing in Email.

Member Avatar
Member Avatar
+0 forum 8

Hi, I am in a company where SMTP is currently not available and port 25 is also blocked, Therefore I have choosen to send email via PHP Mailer Class but whrn I setup everything its giving me error... Second I did not understand this line [ICODE]$mail->IsSMTP(); // telling the class to use SMTP $mail->Host = "gmail.com"; // SMTP server[/ICODE] [CODE]SMTP -> ERROR: Failed to connect to server: Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP? (112107656) SMTP Error: Could not connect to SMTP host. Mailer Error: SMTP Error: Could not …

Member Avatar
Member Avatar
+0 forum 10

Hi, I have developed a SMS Application. There is a file name my.php I want to execute it after every 10 seconds so I can get new files which arrive. please guide me

Member Avatar
Member Avatar
+0 forum 9

Hi I have to develop a code for file configuration in PHP. My basic text file is stored in C:\abc my text file name format is Mobile#_Code.request Example: 923135470808_9033.request Now I want to read code 9033 from the name of text file which always be there after _ and before .request After getting code I will get data from MySQL DB and want to put this result in the form of message in the text file like "Hi 9033 your remaining balance is 50USD" Now after putting message in same file I want to rename the file name as 923135470808_9033.done …

Member Avatar
Member Avatar
+0 forum 5

Hi , I have 5 quries, each query showing expense of different category. like Lease,Diesel,Security,Electricity, Maintenance. 3 quries using 6 tables and 2 quries using 2 tables means 6 tables used in total. Now I want To Show Expense Using one query so I can Get complete Sum of Expenses. Here are my All Queries Diesel: (Using 2 Tables Diesel info and Rates(its uesed in onother 2 quries also)) [CODE]$result = mysql_query("SELECT FORMAT(ROUND( Qty * Itemrate ),2) FROM `diesel_info` INNER JOIN rates ON diesel_info.marker = rates.item AND MONTH( diesel_info.Date ) = MONTH(rates.Date ) WHERE diesel_info.Code =$a AND MONTH( diesel_info.Date )=$m …

Member Avatar
Member Avatar
+0 forum 13

Hi, I am using UNION ALL to get Sum of expense of different categories from various tables. Now I got Site against their Sum of expenses but When I make this query as table(tbl2) ans select site,Max(Expense) from tbl2 it shows correct Max(Expense) but first Site id of tbl2. Here is my query [CODE=mysql]Select Site,Max(Expense) from ( Select Site,Sum(Category_Total) as Expense from ( ( SELECT 'Diesel' AS Category,Code as Site,ROUND(SUM(Qty * Itemrate)) AS Category_Total FROM `diesel_info` INNER JOIN rates ON diesel_info.marker = rates.item AND MONTH( diesel_info.Date ) = MONTH( rates.Date ) Group by Site ) UNION ALL ( SELECT 'Lims …

Member Avatar
Member Avatar
+0 forum 2

hi this is my code. I want to validate new password with repeat password befor user press submit. [CODE]<p align="center">To reset your password, provide your current password</p> <form id="form1" name="form1" method="post" action="pcq.php"> <table border="0" align="center" class="mytable2" style="margin-left:175px" > <tr> <td>Current Password</td> <td> <input type="password" name="oldpass" style="width:150px;" /> </td> </tr> <tr> <? $user=$_SESSION[myusername] ?> <td><input type="hidden" name="usr" id="usr" value="<?php echo $user; ?>"style=" width:150px;" /> </td> </tr> <tr> <td>New Password</td> <td><input type="password" name="pass" style="width:150px;" /></td> </tr> <tr> <td>Repeat New Password</td> <td><input type="password" name="rpass" style="width:150px;" /></td> </tr> <tr> <tr> <td> </td> <td > <input type="submit" value="submit" > <input type="reset" value="Reset"></td> </tr> </table> </form>[/CODE]

Member Avatar
Member Avatar
+0 forum 6

Hi, this is my query. I calculate difference of 20 days from pDate(Process Date) form today. But I want if rfDate(Resubmitted date) it will count from rfdate and ignore Pdate. [CODE=mysql]SELECT * FROM `lims_payment` WHERE TO_DAYS( NOW( ) ) - TO_DAYS( `pDate` ) >20 AND rfDate LIKE '0000-00-00'[/CODE]

Member Avatar
Member Avatar
+0 forum 4

hi this is a code for [B]export to excel[/B]. I want to color the headers light blue and all result of query like one white then one grey and repeat. [CODE=php]session_start(); $a= $_GET["id"]; function cleanData(&$str) { $str = preg_replace("/\t/", "\\t", $str); $str = preg_replace("/\r?\n/", "\\n", $str); } # file name for download $filename = "EIMS_Finance" . date('Y-m-d') . ".xls"; header("Content-Disposition: attachment; filename=\"$filename\""); header("Content-Type:application/vnd.ms-excel"); $flag = false; $qry1=mysql_query("(SELECT * from Table where Id=$a"); while(false !== ($r1=mysql_fetch_assoc($qry1))) { if(!$flag) { # display field/column names as first row echo implode("\t", array_keys($r1)) . "\n"; $flag = true; } array_walk($r1, 'cleanData'); echo implode("\t", array_values($r1))."\n" ; …

Member Avatar
Member Avatar
+0 forum 8

This is my table which I used to get access time of users at every single minute. [CODE]-- -- Table structure for table `members_log` -- CREATE TABLE IF NOT EXISTS `members_log` ( `SrNo` int(11) NOT NULL AUTO_INCREMENT, `UserName` varchar(25) NOT NULL, `access_time` datetime NOT NULL, PRIMARY KEY (`SrNo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ; [/CODE] I used this query in my connection file. [CODE]mysql_query("INSERT INTO members_log (UserName,access_time) VALUES ('$_SESSION[myusername]',NOW())");[/CODE] Now I want to add more functionality in it. I want to know user click which page of DB when time inserted.

Member Avatar
Member Avatar
+0 forum 4

Hi, this is my query [CODE]$result = mysql_query("SELECT SUM(`qty`) FROM sims_ac WHERE region ='North'");[/CODE] How I can show this [CODE]$result[0][/CODE] without using While loop or any other loop.

Member Avatar
Member Avatar
+0 forum 6

Hi this is my Form , when User fill form and by mistake he click on back button. I want when he open it next time all values be there, so he cant type again [CODE]<form name="form1" method="post" action="checklogin.php"> <input name="myusername" type="text" value="Enter Your Username"onfocus="this.value=''" /> <input name="mypassword" type="password" id="mypassword" /> <input type="submit" name="Submit" value="Login" /> </form>[/CODE]

Member Avatar
Member Avatar
+0 forum 4

Hi, this is my option value. June is my Default selected Value, but there is a small issue. When Users select any month like January-2010, when he/she click on submit button. Page will show again June in Option. But I want which the user selects. [CODE=php]<td> <label>Billing Month <span class="small">Like September-2010</span> </label></td> <td> <? $year = date("Y") ; ?> <select name="b" class="billmonth"/ > <option value=<? echo "January-".$year; ?>><? echo "January-".$year; ?></option> <option value=<? echo "February-".$year; ?>><? echo "February-".$year; ?></option> <option value=<? echo "March-".$year; ?>><? echo "March-".$year; ?></option> <option value=<? echo "April-".$year; ?>><? echo "April-".$year; ?></option> <option value=<? echo "May-".$year; ?> …

Member Avatar
Member Avatar
+0 forum 15

Hi, this is my file which showing result. I put check box for each result. [CODE=php]<? include("config.php"); echo "<form method=post name=myform action=b.php >"; $result=mysql_query("Select Distinct region,MaintainedBy From info"); while($ro=mysql_fetch_array($result)) { echo "<tr bgcolor=#FFFFFF style=color:#000000;>"; echo "<td>" . $ro[0] . "</td>"; echo "<td>" . $ro[1] . "</td>"; echo "<td><input name=id[] type=checkbox value='{$ro[0]}`{$ro[1]}' /> </td>"; echo "</tr>"; } echo "<input type=submit style=width:100px name=itmlist value=Add To List/>"; echo "</form>" ?>[/CODE] and action file of a.php is b.php [CODE=php]<? include("config.php"); if($_POST['id']=='') die("Please Select An Item To Add in List <a href='a.php'><b>Go BACK</b></a>"); foreach ($_POST['id'] as $tab) { $arr=split("`",$tab); echo "<table width=50% bgcolor=#EFEFEF >"; echo …

Member Avatar
Member Avatar
+0 forum 3

I can easily change settings in IE6 for printing Background Colors and Images. But How I can do same in Google Chrome. Please see attached image ...

Member Avatar
Member Avatar
+0 forum 2

Dears [INDENT]This is an electricity billing Site link [url]http://www.mepco.com.pk/ls/defftree.asp[/url][/INDENT] I click on each link and SELECT and COPY/PASTE , It takes 3 hours minimum each day to save all pages in Excel. I want to get all pages automatically using PHP or Query. Because higher management demand reports each day.

Member Avatar
Member Avatar
+1 forum 15

This is my form: I want to calculate Units Billed when user enter present and previous reading before submission. [CODE] <form action="EIMS_North_Inserted.php" method="post"> <table class="mytable" align="center"> <tr> <td><label>Site ID <span class="small">Example N-WAH-8620</span> </label></td> <td> <input type="text" name="a" id="course" value="" class="input"/> </td> <td> <label>Previous Reading <span class="small">Regular bills</span> </label></td> <td> <input type="text" name="e" id="e" value="<?php echo $e; ?>" class="input"/> </td> <td><label>Present Reading <span class="small">Regular bills</span> </label></td> <td> <input type="text" name="f" id="f" value="" class="input"/> </td></tr> <tr> <td><label>Units Billed <span class="small">Regular bills</span> </label></td> <td> <input type="text" name="g" id="g" value="" class="input"/> </td> <tr> <td colspan="2"> <input type="submit" name="submit" style="width: 200px; height: 20px; cursor: pointer; …

Member Avatar
Member Avatar
+0 forum 38

The End.