almostbob 866 Retired: passive income ROCKS

my google query, was 'include thread teaser in title attribute'
theres a bunch of em

My simplest answer is to download a copy of vbulletin and read the code.
not knowing the data structure, just giving 'duh' column names
something like

select postheading firstpost href from postlist where readflag=nul

and output

echo '<a href=\''.$href.'\' title=\''.substr ( $firstpost, 0, 150 ).'\'>.$postheading.'</a>';

from the database

almostbob 866 Retired: passive income ROCKS

The link is created from an sql database, the database query creates the title attribute in the link as the first 'xx' characters of the Original post in the thread
without any idea of the database structure
or the sql needed to pull the thread and title from the database

You could browse the Vbulletin source
other bulletin board software source
use google
browse sql & php manuals,
there is 99% likely to be a tutorial on this, somewhere
You could avoid re-inventing the wheel, and use a forum, or part of one, already available

almostbob 866 Retired: passive income ROCKS

css

// for a element titles
a[title] { font:bla; background:(url to image with round corners); color:bla;  padding: enough to bring the background out; }
// for all element titles
*[title] { font:bla; background:(url to image with round corners); color:bla; padding: enough to bring the background out; }
almostbob 866 Retired: passive income ROCKS

Thankyou Cwarn23, straightens the kinks a little
Rob

only a little

Ancora Imparo

almostbob 866 Retired: passive income ROCKS

php returns static html pages
nothing else is seen on the user browser, unless part of the html is a javascript, then the javascript is dynamic (from the user perspective)
Trying to get my head round how what you want could not be solved with a mod_rewrite rule, with lower overheadI might (grimace(probably)) be missing somethingbut I guess my learning curve isnt helping your problem, sorry

almostbob 866 Retired: passive income ROCKS

Just one
you seem to misunderstand what you are doing
the site will no longer function.
processing of the order
inventory control etc
must react to user input so cannot be static html.

almostbob 866 Retired: passive income ROCKS

Dont have a safari browser installed,
apple wont 'play nice' with the other 5 browsers,
even MS 'plays nice'r than apple
push your site through http://www.browsershots.org (blatant plug) and see what it looks like on 99% of possible browser OS combinations, it may be a **expletive deleted** on the version of safari you could access

almostbob 866 Retired: passive income ROCKS

ignoring proper html that validates, just to show the necessary code

<table>
<tr>
<td align='right'>label :</td>
<td> content</td>
</tr>
<tr>
<td align='right'>long label :</td>
<td> content</td>
</tr>
</table>

table ( tacky)
or

<style type='text/css'>
.left { width:35%; text-align:right; float:left;}
.right {width:60%: text-alight:left; float:right;}
</style>
<div>
<span class='left'>label</span>
<span class='right'>content</span>
</div>
<div>
<span class='left'>long label</span>
<span class='right'>content</span>
</div>

css

almostbob 866 Retired: passive income ROCKS

screen shots in IE FF opera maxthon avant

look pretty close to me, problem is, exactly? I might be missing it?

Lose the autoplay video,
it'll kill you in search engines

almostbob 866 Retired: passive income ROCKS
.textfield_effect { background:url('searchtheweb.jpg'); }
.textfield_effect:focus { background:none; }
almostbob 866 Retired: passive income ROCKS

winzip
freezip
easyzip

or any other of the zip/ra/gzip/tar creation utilities
to compress for distribution is done locally on your development machine not on your server, although the files are .php .inc .sql they are just text files, nothing special,

tiger86 commented: thanks. I was hoping it was that simple but I always ask the experts when I'm not sure :) +2
almostbob 866 Retired: passive income ROCKS

hope it works for you
I use the script to load large images of the inpage thumbnails so the fullsize image changes instalntly on mouseclick
+ have some instructional .pdfs load so they open onclick

almostbob 866 Retired: passive income ROCKS

its working and showing picture but when I click picture does not disappear.

onfocus='style="background:none;";

my javascript is not perfect, sorry
try

onfocus='this.style.background="none";'

not perfect = not good at all

almostbob 866 Retired: passive income ROCKS
<form action="blabla google blabla get the url from webmnaster tools blabla" method='get'>
<input type='text' style="background:url('searchtheweb.jpg');" onfocus='style="background:none;";'>
<input type='submit' value='Search' >
</form>

see the attached image

google MSN(bing) and yahoo have a bunch of html buttons to do just that on their webmaster gadgets pages

almostbob 866 Retired: passive income ROCKS

It is possible, preferable?, to actually preload the .pdf file so that the impression of instant loading is given.
in the page prior to the pdf linked page add a preload script

<script language="javascript" type="text/javascript">
//<![CDATA[
<!-- 
image1 = new Image();
image1.src = "http://mysite.com/mypdf.pdf";
//-->
//]]>
</script>

The code above placed between </body> and </html> in the page containing the link to the .pdf file (or html file with the .pdf in it) instructs the browser to download the pdf file to the browser cache, but just leave it there.
(filetype is irelevant image() is convenient, use the same script for any filetype as it is not ever going to be rendered)
the download happens after the page is fully rendered so does not delay the current page.
on clicking the link to the .pdf file (or html page) the browser finds the .pdf in the browser cache and does not download it, but displays from the cache, at apparently blinding download speeds.In browsers with javascript disabled, the function degrades gracefully

almostbob 866 Retired: passive income ROCKS

It is better to validate the form on submission, as well
character strings can equal representations of the character you dont want, &quot;

<script type='text/javascript'>
function isAlphabet(elem, helperMsg){
 var alphaExp = /^["']+$/;
 if(elem.value.match(alphaExp)){
  alert(helperMsg);
  elem.focus();
 return true;
}else{ return false; }
}
</script>
<form>
Letters Only: <input type='text' id='letters' onkeyup="isAlphabet(document.getElementById('letters'), 'Cannot contain quote characters')" />
</form>

Fragment only, not checked for long strings

almostbob 866 Retired: passive income ROCKS
select NAME from tablename order by name;
almostbob 866 Retired: passive income ROCKS

.xls is proprietary and contains more than just the data, not sure if your functions are accurate, but they appear to match what I have seen before

excel can read/write .csv comma separated values
php can read/write .csv comma separated values
which is great if the data is all you need, not sure if equations transfer

a bunch of tutorials on creating writing .xls with phphttp://www.google.com/search?php .xls tutorial have no idea how myself

(Good Luck)

almostbob 866 Retired: passive income ROCKS

excel file format is proprietary,
excel can read/write .csv comma separated values
php can read/write .csv comma separated values

a bunch of tutorials on creating the button to do so http://www.google.com/search?hl=en&q=php+export+mysql+table+as+.csv+tutorial&meta= have no idea how myself

almostbob 866 Retired: passive income ROCKS

I have coded prince1.shtml based on almostbob's suggestion but am having a problem getting the bigimage to display. Suggestions please.

I wasnt happy with this document.getElementByID('bigimage').src=image;} but I couldnt see an error either my javascript is **expletive deleted**
there could be quotes in my javascripts, that I cant think of.
anyone who is good at javascript,
please help

I found at http://www.webdeveloper.com/forum/archive/index.php/t-64917.html a similar thread with answers
DosVdanye

almostbob 866 Retired: passive income ROCKS

loading the image onclick may not be as fast as you need for hi res images, but will speed page load because most people do not click images, so only the thumbs will be required

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" >
<head>
<script language="javascript" type="text/javascript">
<!--
(document.getElementById) ? dom = true : dom = false; //select ie mozilla
function hideIt() {
 if (dom) {document.getElementById("layer1").style.visibility='hidden';} //ie
 if (document.layers) {document.layers["layer1"].visibility='hide';} } //mozilla
function showIt(image) {
 if (dom) {document.getElementById("layer1").style.visibility='visible';document.getElementByID('bigimage').src=image;}
 if (document.layers) {document.layers["layer1"].visibility='show';document.getElementByID('bigimage').src=image;} }
onResize="window.location.href = window.location.href"
//--></script>
</head>
<body>
<img src='thumb1.jpg' onClick="showIt('/largeimage1.jpg');">
<img src='thumb2.jpg' onClick="showIt('/largeimage2.jpg');">
<img src='thumb3.jpg' onClick="showIt('/largeimage3.jpg');">
<img src='thumb4.jpg' onClick="showIt('/largeimage4.jpg');">
<div id="layer1" style="position:fixed; left:20px; width:65%; top:20px; visibility:hidden;">
<img id='bigimage' src='blank.jpg' onClick="hideIt();" alt='Click to close this image'>
</div>
</body></html>

Code not guaranteed, but may be a jumping point

almostbob 866 Retired: passive income ROCKS

as well as tutorials at php.net and a hundred other sites

there are thousands of premade php scripts for download from sourceforge hotscripts phpscripts and hundreds of other repository sites, that may be lready to do what you require in many cases

almostbob 866 Retired: passive income ROCKS

'framesets are bad ssi is better' - that tutorial is at least ten years old
current practice excludes ssi
php is far more developed, flexible, powerful than SSI,
ssi is redundant
nothing that ssi can do is not able to be done by php (asp for ms fans)
much that php can do is not able to be done by ssi
learn one use one (might as well be the one that does more)
ssi cannot compile itself a slideshow, php can
php reads and writes databases, sends mail.

This site is php
500 000+ users, millions of posts, millions of images, all a click away

almostbob 866 Retired: passive income ROCKS

when you get the database contents assuming the row is array $row
$row is assumed to have a value inserted into the html textareaif you create a javascript variable of $row you could compare textarea.value with that javascript variable onblur and enable the button
code as thought process only,

<script type='text/javascript'>
<!--
function checktext()
if document.textarea.value() != "<?php echo $row['textarea']; ?>" { enable_submit_button_of_some_kind  };
--></script>
<textarea rows='6' cols='60' onblur=checktext();><?php echo $row['textarea']; ?></textarea>
almostbob 866 Retired: passive income ROCKS

Read the instructions by Google, in the prior link,
Google explain the use and submission of sitemaps
Nothing any one else has to say really matters, does it

almostbob 866 Retired: passive income ROCKS
almostbob 866 Retired: passive income ROCKS

pauses to avoid being sarcastic. . . . .

  • name servers map canonical names to ip

I bought the site through GoDaddy like I always have...
I am using HostGator as the space provided.
I pointed the domain to hostgator and began making the website.

the canonical name for your site is registered at godaddy
mapping the name to the host is propogated from godaddy
usual delay is 24-72 hours
for some reason at the moment godaddy help screens suggest 5-7 days (worst case) in propgating name server changes, hosting changes, et al, before the site will be accessible from http: //canonical name

if that is not significant in not being able to access more than the default 'parking' address,
WTF is

almostbob 866 Retired: passive income ROCKS

http://help.godaddy.com/article/788

godaddy : 5-7 days for domain name registraion transfer of nameserver update

almostbob 866 Retired: passive income ROCKS

Likewise, fire the developer
trying to hide that they havent kept up with current best practice

almostbob 866 Retired: passive income ROCKS

Links,
your content has to be good enough that other sites post links to it
the more sites that link to you, the more often search spiders will find reference to your site and the higher it will rank in the algorithms
there are link services that post thousands of links to your site to trick search engines, DONT, it just get you de-listed.
Create a sitemap and submit it to Search enginesRead the instructions by Google, in the prior link,
Nothing any one else has to say really matters, does it

almostbob 866 Retired: passive income ROCKS

A very interesting side career,
some of the things hidden in obfuscated code when the author just got fired would . . . . . . . . .

glad it helped

almostbob 866 Retired: passive income ROCKS

Google webmaster tools
has a very good section on how to get indexed, and get good rankings
do not use a link exchange, they are negative in effect
proper site design, keywords, content, incoming links from indexed sites do work
made the first page for our region, and field, and get many customers off google

almostbob 866 Retired: passive income ROCKS

spent a lot of time repairing obfuscated and over-escaped codes where the original writer left the company, and they have no copy of the source

veledrom commented: Perfect help. Thanks almostbob +2
almostbob 866 Retired: passive income ROCKS

http://centricle.com/tools/html-entities/ copy the escape coded texted in the box and click the decode button

<p><span class="caps">APRIL</span></p>

<p><span class="caps">SAT</span> 18<br>
<span class="caps">OPEN TUTORIAL </span>(10.00- 4.00)<br>
This day will include a session on Reflective Practice, Alternative Formats and Physical Skills. It is open to all SWs although the majority of participants are likely to be <span <p><span class="caps">APRIL</span></p>

<p><span class="caps">SAT</span> 18<br>
<span class="caps">OPEN TUTORIAL </span>(10.00- 4.00)<br>
This day will include a session on Reflective Practice, Alternative Formats and Physical Skills. It is open to all SWs although the majority of participants are likely to be <span
almostbob 866 Retired: passive income ROCKS
<div id="footer">
<p><a href="link.html">Link</a> &nbsp;
<a href="link.html">Link</a></p>
</div>
<!-- or -->
<a href="link.html">Link</a> <a href="link.html">Link</a></p>

both give Link Link
everything inside <a></a> is link,
if you want spaces that arent underlined and clickable add them outside the <a></a> tags,

&nbsp; = html 'hardspace' non-break space

or you can add margins & padding to your links in css

almostbob 866 Retired: passive income ROCKS

I like resurrected topics.
sometimes 'best practice' changes and being told a better way to do something than the way I have been doing it is useful.
I dont really notice signature urls.
I only play with my sig

almostbob 866 Retired: passive income ROCKS

wrong css in iefix.css

@charset "utf-8";
/* CSS Document */

body{
overflow: hidden;  /*I did this to get rid of the bottom scroll bar in IE*/
}

got rid of all scroll bars in IE
reset the width of the divs to % instead of fixed pixels then the site wont have horizontal scrollbars and the iefix.css file can be removed

almostbob 866 Retired: passive income ROCKS
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<style type='text/css'>
<!--
.top { background-color: #000070; color: #ffffff; text-align: right; }
.bottom {  background-color: #efefef; padding: 15px; text-aliign:right;}
-->
</style>
<script language="javascript" type="text/javascript">
<!--
(document.getElementById) ? dom = true : dom = false;
function hideIt(textID) {
 if (dom) {document.getElementById(textID).style.visibility='hidden';}
 if (document.layers) {document.layers[textID].visibility='hide';} }
function showIt(textID) {
 if (dom) {document.getElementById(textID).style.visibility='visible';}
 if (document.layers) {document.layers[textID].visibility='show';} }
//--></script>
</head>
<body>
<button onmouseover="showIt('layer1');" onmouseout="hideIt('layer1');">?</button> Question mark help
<br>
<button onmouseover="showIt('layer2');" onmouseout="hideIt('layer2');">?</button> second Question mark help
<div id="layer1" style="position:fixed; left:20px; top:40px; visibility:hidden;">
<ul compact='compact' class='bottom'>
<font size="+1"><b>help page</b>:<br/>
Blah blah blah
<li>blah blah blah</li>
<li>blah blah blah</li>
<li>blah blah blah</li>
<li>blah blah blah</li>
<li>blah blah blah</li>
</ul>
</div>
<div id="layer2" style="position:fixed; left:20px; top:40px; visibility:hidden;">
<ul compact='compact' class='bottom'>
<font size="+1">second help page:</font><br/>
Blah blah blah
<li>blah blah blah</li>
<li>blah blah blah</li>
<li>blah blah blah</li>
<li>blah blah blah</li>
<li>blah blah blah</li>
</ul>
</div>
</body></html>

same script, recoded for multiple divs

almostbob 866 Retired: passive income ROCKS
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<style type='text/css'>
<!--
.top { background-color: #000070; color: #ffffff; text-align: right; }
td.top { background-color: #000070; color: #ffffff; text-align: right; }
td.bottom { background-color: #efefef; padding: 15px; }
.bottom {  background-color: #efefef; padding: 15px; }
-->
</style>
<script language="javascript" type="text/javascript">
<!--
(document.getElementById) ? dom = true : dom = false;
function hideIt() {
 if (dom) {document.getElementById("layer1").style.visibility='hidden';}
 if (document.layers) {document.layers["layer1"].visibility='hide';} }
function showIt() {
 if (dom) {document.getElementById("layer1").style.visibility='visible';}
 if (document.layers) {document.layers["layer1"].visibility='show';} }
onResize="window.location.href = window.location.href"
//--></script>
</head>
<body>
<button onmouseover="showIt();">?</button> Question mark help
<div id="layer1" style="position:fixed; left:20px; width:45%; top:20px; visibility:hidden;">
<table border="0" cellspacing="0" cellpadding="3">
<tr>
<td Align="right" onClick="hideIt()" class="top">
<font Color="#ffffff"><Strong>Close</strong></font>
</td>
</tr>
<tr>
<td class="bottom">
<center><font size="+1"><b>help page</b>:</font></center>
Blah blah blah
<UL compact>
<li>blah blah blah</li>
<li>blah blah blah</li>
<li>blah blah blah</li>
<li>blah blah blah</li>
<li>blah blah blah</li>
</ul>
</td>
</tr>
<tr>
<td Align="right" onClick="hideIt()" class="top">
<font Color="#ffffff"><Strong>Close</strong></font>
</td>
</tr>
</table>
</div>
</body></html>

the javascript can be recoded to display any of multiple hidden divs dependant on which button is mouseovered

almostbob 866 Retired: passive income ROCKS

saveimage.php

<?php if(!$file) return false;
header("Content-disposition: attachment; filename=$file");
header('Content-type: image/jpeg;');
readfile("$file");
?>

image link

<a href='saveimage.php?file=hires/image.jpg'><img src='lowres/image.jpg' alt='click to save hires image'></a>
almostbob 866 Retired: passive income ROCKS
if (!strpos(#_post['textbox'],'http://') == 0) { return false}

/* return false can be any thing, have successfully used header("location: $_server"); to bounce incorrectly filled pages back */ }
or javascript can check similarly in the <form onsubmit='javascript'> before submission

almostbob 866 Retired: passive income ROCKS

the javascript needs to know which buton has been clicked, as the processing differs slightly.

<script type='text/javascript'>
<!--
function validate(text) {
if (text=='process1' ) {/* do something*/}
else {/* do something else*/ }
}
-->
</script>
<form onsubmit='validate("submitbtn");'>
<!-- bla bla -->
<input type='submit' name='submitbtn' value='process1'>
<input type='submit' name='submitbtn' value='process2'>
</form>

unchecked code, thought process only

almostbob 866 Retired: passive income ROCKS
button { background-color: #e4e0d8; } 
button:hover { background-color: #66cdaa; } 
button:active { background-color: #66cdaa;  } 
button:focus { background-color: #66cdaa; } 
form { PADDING: 1px; margin: 1px; }
img { border: 0px; }
input { background-color: #efefef; border: 0px; border-bottom: 1px solid #000000; }
input:hover { background-color: #dfdfdf; }
input:focus { background-color: #dfdfdf; border-bottom: 1px solid #101010; }
input:active { background-color: #dfdfdf; border-bottom: 1px solid #101010;}
input[type=button] { background-color: #e4e0d8;  }
input[type=button]:hover { background-color: #66aaaa; }
input[type=button]:focus { background-color: #66cdcc; }
input[type=button]:active { background-color: #66cdff; }
input[type=submit] { background-color: #e4e0d8;  }
input[type=submit]:hover { background-color: #66cdaa; }
input[type=submit]:focus { background-color: #66edea; }
input[type=submit]:active { background-color: #669d9a; }

snipped from my .css I dont use images slows down loading, here in rural dial up land, but css four state works for inputs

almostbob 866 Retired: passive income ROCKS

a submit button 'onmousedown' is onsubmit in the parent <form>
a submit button has no 'onmouseup' because the form has already been submitted,

almostbob 866 Retired: passive income ROCKS

I have a table with the following date field entry named datetime:
07-05-2009
Which I am assuming is an entry for 07-05-2009 (d/m/Y)

or it could equally be m-d-y
thats the other reason why dates and times should be stored as a timestamp
timstamp is smaller faster and un-ambiguous

Will Gresham commented: +1, completely forgot that point :) +2
almostbob 866 Retired: passive income ROCKS

i have seen many form if some one press the button it takes to the other page also it sends tha data?

well Yeah, php form processing is in the target page not the form page
and validation failure is something like
if !$post['variable'] {header ("location: $_SERVER['http_referer']"); }[code=php]if !$post {header ("location: $_SERVER"); }

almostbob 866 Retired: passive income ROCKS

shtml php asp would be so much easier to code than trying to 'dynamic' the iframe.
just one line of code in each page file, and change the extensions to
.shtml

<!--#include virtual="/mainmenu.html" -->

.php

<?php include('/mainumenu.html'); ?>

.asp

// dunno never used it

for whatever scripting language the hosting account supports.
This one, the solution,
is easier than it appears looking forward,
looking back, piece of cake

or -use a frameset

<frameset rows='160,*'> <!-- top menu --><!-- or --><frameset cols='160,*'> <!-- left menu -->
<frame id='menu' src='mainmenu.html'>
<frame id='main' src='reikiwhatever.html'>
<noframes>If frames disabled this text appears</noframes
</frameset>

where mainmenu.html <a> s include target="main" to open them in the other frame
there will be then only a single page scrollbar

almostbob 866 Retired: passive income ROCKS

You install MYSQL on apache
equivalent I think to installing acess on windows
you can run MYSQL on other web servers, on windows, on OS10, but there has to be an underlying OS

csharplearner commented: Thank you for the explaination +1
almostbob 866 Retired: passive income ROCKS

From a prior thread
Check for new version
(I thought once, now I just paste)

diafol commented: Nice one AB - thought fgc would fail for same reason as include. Doh! +3
almostbob 866 Retired: passive income ROCKS

[Rant = My favorite Subject]

simplify the database
change any text dates "October 15 2008"(smalltext 15 characters) etc to timestamps (Int(10))
strip out the $signs
you only need them when you print out information echo '$ '.$sPrice; is just as fast and causes no $_ errors
the database should contain
no formatting
no text dates or times
nothing but data in its basic form,
its easier to manipulate, smaller, faster, cheaper to maintain
and you can calculate on the fields, which is more difficult to do with text representations,
not so much now for 50 items, 50Bytes extra per row isnt much
but when the db grows to 500 000 items and there are millions of transactions in the transaction table, 50Bytes per row is a lot

[/Rant]