Jump to content

plusnplus

Members
 View Profile  See their activity

  • Posts

    33

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by plusnplus

    Export to excel not work from pc client but work in server.

    in PHP Coding Help

    Posted

    Hi..,

    I use below method to export data to excel.

     

    header('Content-type: application/ms-excel');

    header('Content-Disposition: attachment; filename=abc.xls');

     

    if I run the script from the server. (http://localhost/export.php) it is work. (pop-up window if i want save or open the file)

     

    but if i run the script from the client (http://192.168.1.5/export.php) it is not work. (nothing happen)

     

    any idea how to solve this?

     

    php code show in the browser

    in PHP Installation and Configuration

    Posted

    It would help if you showed what opening php tag you are using in your code.

     

    after i put <?php ( before just <? ), it work properly.

    since so many pages (more then 200) I need to update, any other way beside that update opening tag?

     

    i just wonder, why apache+mysql+php in windows server 2008 need this opening tag?

    my intranet server, using ubuntu 10.04, without that (<?php), the web page work properly.

    php code show in the browser

    in PHP Installation and Configuration

    Posted

    hi..,

    i have pc development, using win xp sp3, apache+mysql+php the code/ webpage work prefect.

    i have intranet server, using ubuntu 10.04, apache+mysql+php the code/ webpage work prefect.

    but.., when i copy to live web server, using win server 2008, apache+mysql+php, all php code show in broswer.

    if there is a html code, it show correctly, but the php code, show just like text in the browser.

     

    how to solve this problem?

    thanks for any help/ info

     

    can insert image to excel file, but the alignment is up-side down :(

    in PHP Coding Help

    Posted

    Hi..,

    My code is like:

    <?php
$filename ="excelreport.xls";
print "<table border=1>";
print "<tr ><td valign=bottom><img src=http://abc/images/big.png ></img></td>
<td valign=bottom><img src=http://abc/images/small.png ></img></td>
</tr>";
print "</table>";

header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);

?>

    when I open the excel file, the images alignment is from top to bottom(equal from top of image).

    what i want is from bottom to top(equal from bottom of image).

     

    i did try using valign in td property, but still the images equal from top of image

     

    thanks for any reply/ help

    Is error:"XML Parsing Error: no element found" have something to do in php.ini?

    in PHP Coding Help

    Posted

    Hi..,

    I have code:

    <?php
header("content-type: text/xml");
$xmlData = file_get_contents("http://www.google.com/ig/api?weather=new%20york");
echo $xmlData;
?>

    and get error:XML Parsing Error: no element found.

     

    is this kind of error need some setting in php.ini?

    or what i should look at phpinfo() to make sure the setting is ok.

    or.. is there any setting in apache?

    i'm using win XP, apache, php and mysql.

     

    if i type direct in browser: http://www.google.com/ig/api?weather=new%20york

    it give me the xml file withour any error.

     

    thanks for any reply/ help

    Is there a sound file(wav/mp3) that play less then 1 second?

    in Other

    Posted

    Hi all,

    i need a super sound file that the duration maybe less then 1 second.

    maybe the bit rate higher/ smaller or audio rate higher/ smaller?

     

    The purpose is i want to have sound in jquery fade-in and fade-out effect.

    the fade-in and out is about 1 second each.

    so if i have 100 item fade-in and out, the sound (play duration in 1 sec), play little bit late/ lag, compare what the fade-in and out object show in screen.

     

    thanks for any reply/ help

    How to play sound repeatedly in javascript?

    in Javascript Help

    Posted

    Hi..,

    I have a loop in javascript, i want to play sound each time the loop start.

    my html code  is:

    <embed src="sound12.wav" autostart=false width=0 height=0 name="sound1"
enablejavascript="true" HIDDEN="TRUE">

    my javascript code:

    for (var i = 0; i < str_code; i++) {
        // do something
EvalSound('sound1');
  }

     

    edit: the sound only play once, even the loop is 10 times

     

    thanks for any reply/ help

     

    how to solve: XML Parsing Error: no element found

    in Third Party Scripts

    Posted

    Hi pornophobic,

     

    it is still give me the same error:

    XML Parsing Error: no element found

     

    it that possible the error because, my company block something in firewall?

     

    but like i mention before i able to see without error if i type directly to browser(firefox):

    http://www.google.com/ig/api?weather=new%20york

     

    actually i try other weather api script from yahoo, still not show same error, but not if i put direct in browser.

    how to solve: XML Parsing Error: no element found

    in Third Party Scripts

    Posted

    Hi..

     

    I try to get google weather info into my website.

    when i try this code:

    <?php
header("content-type: text/xml");
$xmlData = file_get_contents("http://www.google.com/ig/api?weather=new york");
echo $xmlData;
?>

    i got error : XML Parsing Error: no element found

     

    but when i directly type http://www.google.com/ig/api?weather=new york into the browser, it give me the xml file.

    Any idea how to solve this problem?

     

    Thanks for any reply/ help

     

    How to close div tag automaticly?

    in Javascript Help

    Posted

    Hi..,

     

    I need to close a pop-up window that call from jquery.

    After I do update something to database inside that pop-up window, i want the window automaticly close without refresh any page.

    Below is how i do it:

    1. a link to call the pop-up from php

    <a href=# title='$id' class='button' onclick=SetJsValue('$id')>

     

    2. ajax function

    function SetJsValue(pass_id){
	var ajaxRequest;  // The variable that makes Ajax possible!
	try{
		// Opera 8.0+, Firefox, Safari
		ajaxRequest = new XMLHttpRequest();
	} catch (e){
		// Internet Explorer Browsers
		try{
			ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
		} catch (e) {
			try{
				ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
			} catch (e){
				// Something went wrong
				alert("Your browser broke!");
				return false;
			}
		}
	}
	// Create a function that will receive data sent from the server
	ajaxRequest.onreadystatechange = function(){
		if(ajaxRequest.readyState == 4){
			var ajaxDisplay = document.getElementById('ajaxDiv');
			ajaxDisplay.innerHTML = ajaxRequest.responseText;
			var varredirect=ajaxRequest.responseText.indexOf('success');

			if (varredirect!= -1 ) {
					window.location = "index.php"
			}

		}
	}
	var pass_id = pass_id;
	var queryString = "?pass_id=" + pass_id;
	ajaxRequest.open("GET", "customer.php" + queryString, true);
	ajaxRequest.send(null);
}

     

    3. body of my php page

    div class="popupContact">
	<a class="popupContactClose">x</a><br>
<div id='ajaxDiv'></div>
</div>

     

    4. pop-up java script:

    function loadPopup(){
//loads popup only if it is disabled
if(popupStatus==0){
	$(".backgroundPopup").css({
		"opacity": "0.7"
	});
	$(".backgroundPopup").fadeIn("slow");
	$(".popupContact").fadeIn("slow");
	popupStatus = 1;
}
}

     

    5. some part of my pop-up window

    print "<form name='customer_form' method='POST' action='customer_update.php' target='_blank'>";

     

    //=== some form input

     

    print "<tr><td align=right colspan=4 ><input class=Body name=button_sub type='submit' value=Update > </td></tr>\n";

    print "</form>";

    After i update to database, I close this new window.

     

    My question is: how to close <div id='ajaxDiv'></div> automaticly after i update user input into database?

     

     

     

    Thanks for any help/ reply

    *Sorry if i post in wrong forum section

    How to make this query better ?

    in MySQL Help

    Posted

    After run few test, the query not run properly.

    for more info:

    table_sales record is like:

    cust_id          item_id      item_qty

    abc                100            100

    abc                110            100

    abc                120            100

    abb              100            100

    abb                120            100

    abb                130            100

    aba                110            100

    aba                120            100

    aba                130            100

     

    Thanks for any help/ idea

    How to make this query better ?

    in MySQL Help

    Posted

    Hi,

    my query is:

    select distinct cust_id from tabel_sales where item_code !='110' and cust_id not in (select cust_id from table_sales where item_code='110')

     

    purpose of the query is to get customer that NOT have item code 110.

     

    this query work fine, but take very long time (for 12.000 record plus)

    is in mysql have timeout setting?

    in MySQL Help

    Posted

    Hi dreamwest ,

     

    it is something statistic record that need display in full -+ 12,000 records. records in table actually more then 60,000 records.

    is mysql not the right one to do the job? or there is setting to make longer timeout beside one in apache setting?

     

    btw, how actually 'LIMIT 1,20' working ? when i try it, it only display 20 record, but the sum of 12,000 records still calculate and show.

     

    is in mysql have timeout setting?

    in MySQL Help

    Posted

    Hi dreamwest ,

    thanks for the reply.

    the query is just normal query:

    - select  16 field

    - with 4 condition

    - from 1 table

    - sort by 6 field

     

    estimated record to be display -+ 12.000 records

     

    i'm using normal pc :

    intel core 2 duo, e8400 @3 ghz,

    2gb ram

    sata harddisk 250 gb.

    win xp

    apache 2.0

    php 4.0

    mysql 4.0

     

    if i make more condition in query, the result can get full -+ 1000-1500 records, but once i reduce the query condition, the broswer always stop in 1800 plus record.

     

    btw, how to indexing record in the table?

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.