Posts
 
Reputation
Joined
Last Seen
Strength to Increase Rep
+0
Strength to Decrease Rep
-0
0% Quality Score
Upvotes Received
0
Posts with Upvotes
0
Upvoting Members
0
Downvotes Received
2
Posts with Downvotes
2
Downvoting Members
2
1 Commented Post
0 Endorsements
~66.6K People Reached
Favorite Tags

83 Posted Topics

Member Avatar for jacksantho

Hi, How to create a dynamic drop down list using php. My drop down list should be: Example: if manager logins : the manager should see only the manager list of a company. if employee logins: the employee should see only the employee list of a company. Please help me …

Member Avatar for tapananand
0
792
Member Avatar for jacksantho

Hi, can any body, tell me how to follow the url rewriting using .htaccess. Am using xampp,where can i able to find .htaccess file. How to change/add in the .htaccess file, to get the changed URL in the address bar [url]http://www.example.com?name=value[/url] to change in the address bar as [url]http://www.example.com[/url] Please …

Member Avatar for bathina.gunasekhar
0
8K
Member Avatar for jacksantho
Member Avatar for diafol
0
118
Member Avatar for jacksantho

Hi, Please look at my code Declare @tableName varchar(100), @total int, @sql nvarchar(2000),@id varchar(4) set @tableName='details'; set @id='C'; SELECT @sql= ' select @total = count(*) from details where id='+@id exec sp_executesql @sql, N'@total int output', @total output select @total Error: Msg 207, Level 16, State 1, Line 2 Invalid column …

Member Avatar for BitBlt
0
209
Member Avatar for jacksantho

Hi, How to get the correct output of this html file, without **"removing or altering the existing lines in the given file"** filename: sample.html <html > <head> <title>Test</title> </head> <body> <div> ¿Hola cómo está? </div> </body> </html> Describe 2 solutions to fix the problem and get the correct output in …

Member Avatar for timir126
0
81
Member Avatar for jacksantho

Hi, How can i populate the values in the drop down(second drop down) from the select query on choosing the option from the first drop down ? Examples: First Drop Down : Listing out all the "department name" using select query. Second Drop Down : Now, i need the output …

Member Avatar for JorgeM
0
115
Member Avatar for jacksantho

Hi, Any body please help me out, am facing the following error Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 1704 bytes) in C:\xampp\htdocs\phpexcel\Classes\PHPExcel\Style\Borders.php on line 517

Member Avatar for riverspart
0
216
Member Avatar for jacksantho

Hi, How to store while data result set into the session variables and how retrieve the appropriate the session values of the hyperlink on test.php(on another page)... please help me out...thanks Hi, session_start(); $query="select id,name from test"; $result=mssql_query($query); while($row=mssql_fetch_assoc($result)) { $pid=$row['id']; $pname=$row['name']; echo "<tr>" echo "<td>"; ** echo "<a href=test.php>$pid</a>";** …

Member Avatar for broj1
0
4K
Member Avatar for jacksantho

Hi, Am using index page with the iframe and redirecting to the login page(login.html). On going to the page, index.html, am getting redirected to login.html. In login.html, it's ask for USERNAME and the PASSWORD. On entering, wrong username or the password, my iframe size keeps on decreasing on each submit …

Member Avatar for fobos
0
108
Member Avatar for jacksantho

Hi, In my windows machine, just i have installed xampp and the drupal 7. I need of debugging tool, so am going for the Eclipse PHP Development Tool (PDE). I don't know, how to install on my windows machine. Can anybody give me a step by step installation to carry …

Member Avatar for veedeoo
0
233
Member Avatar for jacksantho

Hi, On executing CROSS APPLY Clause using UDF: create function Reg(@pc int,@pp varchar(15)) Returns Table As Return select cr from crt where piod=@pc and cr=@pp Go select distinct a.cr from cdet AS a CROSS APPLY Reg(a.cr,a.piod) AS a where a.piod='208'** Am getting this following errors: Incorrect Syntax near '-'. Thanks.

Member Avatar for BitBlt
0
311
Member Avatar for jacksantho

Hi, Am having, some doubt, please clarify this? [CODE] 1. Using Import/Export wizard, can i able to import the excel data into the temporary table ? How ?[/CODE] 2. The following TSQL is working fine. Can i able to do this, from the CLIENT Machine itself. I don't want to …

Member Avatar for adam_k
0
692
Member Avatar for jacksantho

Hi, Trying this Query, [CODE][B]DECLARE @SR VARCHAR(8),@SC CHAR(15),@ST CHAR(15),@SNO int; SELECT * FROM (SELECT DISTINCT ROW_NUMBER() OVER (ORDER BY a.rno) AS rowid, @SR=a.rno,@SC=a.kat, @ST=a.type FROM SMas a, SDet b WHERE b.id='X' AND a.rno=b.rno) AS C WHERE C.rowid=4 [/B][/CODE] but getting this following error: [CODE][B][I][U]Msg 102, Level 15, State 1, Line …

Member Avatar for jacksantho
0
217
Member Avatar for jacksantho

Hi, Any one please help me out. Server: In Windows 2008, am having the database file (*.bak ) in the following locations [CODE][B]C:\program files\Microsoft Sql server\backup\test.bak[/B][/CODE] I needs to copy, the [B]test.bak[/B] file in my local machine (windows xp) in the following path[B][CODE] C:\backup[/CODE][/B] Using batch script, i needs to …

Member Avatar for jacksantho
0
334
Member Avatar for jacksantho

Hi, I am Using iframe for the URL masking. But it's not working for me. Am using Xampp: [B]1. [url]http://localhost/professor.html[/url][/B] (a).professor.html page in xampp htdocs folder [B](htdocs/professor.html)[/B] (b).professor.html page -> Is a authenticated Page, getting userid and the password in the professor.html page and once the login gets true, moves …

Member Avatar for diafol
0
1K
Member Avatar for jacksantho

In the address bar, i am getting the clean URL. I want to parsed it out.please help me out. [url]http://example.com/folder/test.php?stuid=xx44[/url]

Member Avatar for vaultdweller123
0
99
Member Avatar for jacksantho

I want to take backup of my server database at my local machine........ how can i do this...... Thanks in advance

Member Avatar for pritaeas
0
83
Member Avatar for jacksantho

Hi, Please help me out to get this issue solve. Am don't know, how to get the output. This is the way, i need. But i don't know. (a)select distinct empid from emptable where year=2011 order by empid (b)I needs to pass this empid with the while loop: while() { …

Member Avatar for Tess James
0
221
Member Avatar for jacksantho

My question is that first i need to create the 10 checkboxes which i have already done and then when i set the value of any of the checkboxes as checked, it should be saved in a session after clicking on the submit button.After clicking on the submit button the …

Member Avatar for diafol
0
131
Member Avatar for jacksantho

Hi, For the users, i grant the permissions to create a table and then i also given the permission to alter table i.e grant alter on san to user; Logging as user: Table (design mode), am getting the error: "You are not logged on as the database owner or system …

Member Avatar for arden_k
0
134
Member Avatar for jacksantho

Hi, In my record set, it's returning 67 rows. Some times(on iteration), am getting correct values from the record set and some times am getting wrong values from the record set. Am unable to solve this issue ? please help me out.

Member Avatar for gowans07
0
208
Member Avatar for jacksantho

Hi, Here is the code. Set con1 = CreateObject("adodb.connection") Set rs3 = CreateObject("adodb.recordset") con1.Open "Provider=sqloledb;Data Source=xxx;Initial Catalog=yyy; User Id=sa; Password=@1234;" rs3.Open "select a.courseid,a.semester,a.period,c.Category,b.credit,a.gradecode,d.GradePoint from x a ,y b,z c,m d where a.rollno='" & pprollno & "' and a.semester<>'" & prsem & "' and a.period<>'" & pperiod & "' and a.categoryid=c.categoryid …

Member Avatar for ChrisPadgham
0
430
Member Avatar for jacksantho

Hi, I dont know, what mistake i made in my code. [CODE][B]test1.php[/B] <?php namespace MyNameSpace; class A { public function B() { echo "san"; } } ?>[/CODE] [CODE][B]test2.php[/B] <?php include('test1.php'); $test=new MyNameSpace::A(); $test->B(); ?>[/CODE] [B][url]http://localhost/test2.php[/url] Error: Parse error: syntax error, unexpected T_STRING, expecting T_VARIABLE or '$' in C:\xampp\htdocs\MyNameSpace\test2.php on line …

Member Avatar for gilgil2
0
5K
Member Avatar for jacksantho

HI, Am having a table named "test" in the server A -> running Sql Server 2000. [CODE] synchronized in server B (Insert,update and delete in the server A)[/CODE] Am having the same table named "test" in the server B -> running Sql Server 2005. I don't know, how to carry …

Member Avatar for BitBlt
0
215
Member Avatar for jacksantho

Hi, I need to change [B][url]http://localhost[/url] to [url]https://localhost[/url][/B] 1. I am working on the Apache(Xampp). 2. Operation System -> Windows Machine. 3. Am having [CODE]"DIGITAL CERTIFICATE"[/CODE] (license one - Am not using a self signed certificate) 4. I don't know how to configure this "DIGITAL CERTIFICATE" in my Apache Web …

0
47
Member Avatar for jacksantho

Hi, In my server, just i have installed XAMPP with the PHP version 5.3.1 and the apache version Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 . Am having a website, its run using http protocol : [B]http:[/B]//www.example.com I wants to make it to [B]https:[/B]//www.example.com I don't how to complete this …

Member Avatar for Buppy
0
116
Member Avatar for jacksantho

Hi, Am very new to the c# platform. I needs to create a crystal report on the environment visual studio 2008. 1. I need to create a crystal report using c# with ASP web applications. 2 .Can anyone provide me a [CODE][I]tutorial link on "crystal report"[/I][/CODE] with the use of …

0
71
Member Avatar for jacksantho

Yeah, its it possible to have multiple form in a single page. for example: <form action=test.php method=post> --- -- </form> <form action=test.php method=post> --- --- </form> Both the form action is the same test.php. Any problem ?

Member Avatar for reganstar
0
181
Member Avatar for jacksantho

Hi, Guys Could anyone tell me how to import MsExcel data into MySQL using PHPExcel. I want to make an upload system for my users. They want to upload their data which is in Ms Excel format into MySQL databases...Please teach me how to do that... And I appreciate your …

Member Avatar for vimalnath53
0
146
Member Avatar for jacksantho

Hi, I needs to upload the excel file and how can i read this excel file cell by cell using PHPExcel class and needs to import into database(mysql or mssql).please help me out. thanks in advance

Member Avatar for vimalnath53
0
77
Member Avatar for jacksantho

Hi, I was trying to import the excel values in mysql DB. While trying, am facing this error. Please help me out: [CODE]Fatal error: Call to undefined function mysql_real_espace_string() in E:\xampp\htdocs\read.php on line 49[/CODE] CODING: [CODE]<?php ini_set('memory_limit', '16M'); set_time_limit(0); require_once("E:/xampp/htdocs/phpexcel/Classes/PHPExcel.php"); $inputFileName='./xls/test_data.xls'; /** Identify the type of $inputFileName **/ $inputFileType=PHPExcel_IOFactory::identify($inputFileName); /** …

Member Avatar for jacksantho
0
1K
Member Avatar for jacksantho

Hi, Anyone please help me out. Am having a table with field name 'status' with the values 'yes' or 'no'. Really, i wants to change this 'yes' or 'no' status automatically using mssql server. But i don't have an idea to continue on this work. for example, now the value …

Member Avatar for jacksantho
0
1K
Member Avatar for jacksantho

Hi, I am facing the parser error in the following line: [CODE]<td><select name="type"><option value=" ">select the type</option><option value="C" [B]"'.if(trim($_POST['ctype2'])=="C") echo "selected".'"[/B]>Calcium</option><option value="V">Vitamin</option></td> </tr> [/CODE] Error: Parse error: syntax error, unexpected T_IF in C:\xampp\htdocs\test.php on line 78

Member Avatar for bijoy340
0
222
Member Avatar for jacksantho

Hi, 1. Just am created a user for the login 'test'. 2. As with this login 'test', i logined to the server. 3. I don't have the permission to create the database. 4. So i tried this query: [CODE] use master grant create any database to user go[/CODE] 5. Am …

Member Avatar for pritaeas
0
3K
Member Avatar for jacksantho

Anyone please help me, just i am very new to this content management system. In drupal, i am having this following roles : students, teacher, principal. Students -> should have only access to see only their personal information and their marks. Teacher -> should have only access to see their …

0
39
Member Avatar for jacksantho

I have a stored procedure. This proc returns some data that needs to be put in an excel format. Is it possible to create a excel file to have the result of a select statement from the database? please help me out. Thanks

Member Avatar for buddylee17
0
321
Member Avatar for jacksantho

Hi, I need to get a cell values and to print that cell values in another cell using PHPExcel? For Ex: A12:5 . I need this same value "5" to be printed in the cell B12. thanks for your help.

Member Avatar for pritaeas
0
143
Member Avatar for jacksantho

Hi, Anyone please me out, i need to sum the excel values dynamically? code: [CODE] $col=1; $row=29; $start=23; $end=28; $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, "=SUM($col.$start:$col.$end)"); [/CODE] cell values are not getting up added ? Am facing error. thanks in advance.

0
47
Member Avatar for jacksantho

Hi, can anybody, please help me out. [CODE][B]select * from log where id <='%07%' [/B][/CODE] Am facing the syntax error, what is the actual query? my id look like this: 1.mtg10kl 2.mtg07kl 3.mtg06kl 4.mtg09kl I need the output this: 1.mtg07kl 2.mtg06kl please help me out .thanks in advance

Member Avatar for jacksantho
0
106
Member Avatar for jacksantho

Hi, Am created a login and an user to access sql server instance and the database. [CODE]Creating Login: create login xxx with password='secret'; Creating User: use testdb; create user yyy for login loginname; [/CODE] And then i login with this login name(xxx) and also i can able to access the …

Member Avatar for adam_k
0
225
Member Avatar for jacksantho

hi, [CODE]print "<tr><td><b>click</b></td><td><a href=test.php?id=$id&code=$pcode&name=$pname&section=$psection target=\"_blank\">Click</a></td></tr>"; [/CODE] I am passing all the values to test.php through hyperlink. Problem is: I can able to get only id and code. $pid=$_REQUEST['id']; // values getting $pcode=$_REQUEST['code']; //values getting $pname=$_REQUEST['name']; // values not getting $psection=$_REQUEST['section]; // values not getting I don't know to find what …

Member Avatar for Morta
0
154
Member Avatar for jacksantho

Hi, If i turned OFF in php.ini file magic_quotes_gpc = Off; my code is working finely, when by using unserialize. Problem here: If i turned ON in php.ini file magic_quotes_gpc = On; [CODE] echo "<br>"; echo "<table>"; echo "<tr><td><b>confirm</b></td><td><a href='test.php?cname=confirm&cid=".base64_encode($id)."&code=".base64_encode($pcode)."&pname=".serialize($name)."'>Confirm</a></td>"; echo "</table>"; [/CODE] ($name is an array).Not unserialised--problem here [CODE] …

Member Avatar for diafol
0
281
Member Avatar for jacksantho

Hi, I wants to display my results on the browser. Table1 Table2 sno name sno name 1 sss 3 kkk 2 aaa 4 xxx I need the tables on both side. How can i do this ? Thanks

Member Avatar for jacksantho
0
2K
Member Avatar for jacksantho

Hi, Am having only one check box. I wants to pass checkbox values through hyperlink. I needs to know, either it is an checked checkbox or an unchecked uncheckbox. Based upon checked checkbox, i carry out my remaining coding part. [CODE]echo "<br>"; echo "<table>"; echo "<tr><td colspan='2'><font color='blue'><b>download PDF document:</b></td></tr>"; …

Member Avatar for jacksantho
0
198
Member Avatar for jacksantho

Hi, Please help me out . I need to retrieve the records from 11th row onwards using select query. Please help me out . Its urgent. Thanks

Member Avatar for adam_k
0
330
Member Avatar for jacksantho

Hi, This was am using in my code: [CODE]echo "<table>"; echo "<tr><td><b>Please, confirm or reject: </b></td><td><a href='thanks.php'>Confirm</a></td>"; echo "<td><a href='reject.php?name=$name&officerid=$pofficerid&officername=$pofficername&txt1=$ss'>Reject</a></td></tr>"; echo "</table>"; [/CODE] On clicking [B]Reject[/B] link, my all values(name,offiderid,officername,txt1) that am passing through hyperlink tag getting visible in the URL. I don't need the user, to see my passing …

Member Avatar for fusedreality
0
263
Member Avatar for jacksantho

Hi, Please look at this: [CODE]<?php print ' <form> <td><input type="text" name="txt" maxlength="7" style="text-transform:uppercase"></td> </form> </html>'; if(isset($_POST['submit']) { $val=$_POST['txt']; #header(); } ?>[/CODE] my text box values gets erased after submit button. If i use header function: error is [B]Warning: Cannot modify header information - headers already sent by (output started …

Member Avatar for jacksantho
0
3K
Member Avatar for jacksantho

i have a little form with a select list, and i am submitting the form every time i select an item. the problem is that, after selecting a value and submitting the form, the selected item doesn't remain selected. Is there any method to keep the selected item selected in …

Member Avatar for almostbob
0
14K
Member Avatar for jacksantho

Hi, Any body please help me out: [CODE][B] while loop { $val=mysql_num_rows($result14); $blnk=array(); array_push($blnk,$val); } $blnkarraysum=array_sum($blnk); [/B][/CODE] Values are not at all getting add up. why ? thanks in advance

Member Avatar for cereal
0
325
Member Avatar for jacksantho

Hi, In my home page, i had one submit button(form action $_SERVER[PHP_SELF]). By clicking submit button,(by some action), its shows me the "Accept" and "Reject" button. My "Accept" button(data should save in my database) is not at all working for me .(i pointed this also to form action $_SERVER[PHP_SELF]).But if …

Member Avatar for ddymacek
0
102

The End.