- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 2
- Posts with Downvotes
- 2
- Downvoting Members
- 2
83 Posted Topics
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 … | |
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 … | |
Hi, Can anybody please me, how to increase the performance of the web server? Thanks ![]() | |
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 … | |
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 … | |
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 … | |
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 | |
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>";** … | |
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 … | |
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 … | |
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. | |
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 … | |
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 … | |
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 … | |
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 … ![]() | |
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] | |
I want to take backup of my server database at my local machine........ how can i do this...... Thanks in advance | |
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() { … | |
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 … ![]() | |
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 … | |
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. ![]() | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 ? | |
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 … | |
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 | |
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); /** … | |
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 … | |
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 | |
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 … | |
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 … | |
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 | |
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. | |
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. | |
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 | |
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 … | |
hi, [CODE]print "<tr><td><b>click</b></td><td><a href=test.php?id=$id&code=$pcode&name=$pname§ion=$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 … | |
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] … ![]() | |
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 | |
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>"; … | |
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 | |
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 … | |
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 … | |
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 … | |
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 | |
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 … |
The End.