Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Urgent Help!

Customer{customer id, customer fname, customer lname, customer address1, address2, addresscity, adress_postalcode, customer tel no, customer_category} /* invoices and statements are usually posted, plan for it even if the course notes dont require it */

customer_category{cust_type, discount} /* four possible entries
Private =>0
Bus_Silver => .1
Bus_Gold => .25
Bus_Diamond => .4 */

single lookup table from the customer id then can reference pricing and returns policies
Hope this assists your school work

Databases
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: How to create a hyperlink for a text from database

sorry bloke,
you said you had the website in your database,
I read that to mean you had the full URI stored in the database
As indicated by nav33n have to include protocols
as long as the web page is stored consistently in the database
just rewrite the php to put the missing part of the uri in the href link

always
www company.com /* broken so the board does not make this a link */

<?php echo "<a href=\"http://".$row_WADAcompanies["Website"]."\">".$row_WADAcompanies["Website"]."</a>"; ?>

or always
company.com

<?php echo "<a href=\"http://www.".$row_WADAcompanies["Website"]."\">".$row_WADAcompanies["Website"]."</a>"; ?>
Web Development perl php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Punctuation Game

the quiz is wrong
four yards worth
can be written under other circumstance as
sixpence worth
therefore there are no apostrophes
If one answer is wrong, the others are likely to be also.

Geeks' Lounge
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: How to create a hyperlink for a text from database

wrong, what looked like wrong quotes, wasn't, shouldn't have edit the last post

<div class="WADAResultPrice"><?php echo "<a href=\"".$row_WADAcompanies["Website"]."\">".$row_WADAcompanies["Website"]."</a>"; ?></div>
Web Development perl php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: How to create a hyperlink for a text from database

try

<div class="WADAResultPrice"><?php echo '<a href='.$row_WADAcompanies["Website"].'>'.$row_WADAcompanies["Website"].'</a>'; ?></div>

the html in the php echo statment still has to be quoted as text, the php arrays variables dont

Web Development perl php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Centering Objects in Iframe

messed up
script failed
gone to debug

Web Development javascript
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Setting Field Length Of Result of Query

dynamically code the nested tables the same way the code generates the tables.
The code you have makes horizontal lines
one way is to output the sql query

<tr><td>$s</td><td>$s</td><td>$s</td><td>$s</td><td>$s</td></tr>

one way to make vertical lines

<td>%s<br>%s<br>%s<br>%s<br>%s<br>%s<br>%s<br></td>

its your code, mauck around with it :)

Databases mysql
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Setting Field Length Of Result of Query

Hi, it is being output to a table, but all of the passnger names go as a list within a passenger td, is it not possible to do something in the SQL query?

sql provides the output data (in rows)
formatting is done by your php script & the html css it generates
nest tables,

<tr>
<td>
<table><tr><TD></td></tr></table>
</td>
<td>
<table><tr><TD></td></tr></table>
</td>
Databases mysql
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Setting Field Length Of Result of Query

output into a table, and the width will adjust to the widest name, or set the td widths
tables are still useful for tabular data

Databases mysql
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Export Data to CSV format, new data since last download

line 22

$values = mysql_query("SELECT * FROM ".$table." where download_date = 0");

or
line 12

$result = mysql_query("SHOW COLUMNS FROM ".$table."  where download_date = 0");

or both, but I think line 22
not sure, not perfect in sql
test run it a few dozen times

the table update gets pushed into a php mysql statement
right before the exit; line 35

mysql_query("UPDATE table SET download_date = NOW() WHERE download_date = 0");
exit;
?>

that everything else is complete before the zeros are zapped

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: When website will open, popup has to come

dont use a popup
popups are routinely blocked for security
every day a larger proportion of browsers have popup blockers enabled.
because popups are annoying
sites that use popups get worse results than those that do not

use a layer and show/hide it as necessary

Web Development javascript
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: How to call css file for iframe?

the source for an iframe is a html file (xhtml php cgi asp etc)
you just put the css, or a call to the .css file in the <head> of the source file, the same as any other html file

Web Development html-css php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Export Data to CSV format, new data since last download

As for below, will I also need to to add "time" somewhere into the table?

THX!!

no,
The table update after successfully downloading those records with a value of 0
will place a timestamp in the flag column now() is the sql equivalent of php time() timestamps are numeric and represents the number of seconds from 1/1/1970
currently in the range of 123460000 (last month included the unix milestone 1234567890 o'clock)

using a timestamp is better than a text date time, its smaller in the database, faster, can be compared easier as to prior or later dates, and on output can be whatever date format needed.

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Export Data to CSV format, new data since last download

add column to table download_date with a default value = 0
any newly created rows will have a download date value of zero
a simple table update to post a date to the field for any that have been downloaded already

when downloading update table so that the time the new data was downloaded is recorded.
Then at any later stage reports can be done should any data go missing, of downloads by date and recreate any spreadsheets that go fubar

/* dbconnect */
select * from table where download_date = 0
/* output to csv php script */
/* if (csv file ok ) */
update table set download_date = now() where download_date = 0
/* else print error message suggest retry etc */

code NOT correct for your application.
consider answer as a thought exercise / aid
without dbase structure any code would be so wrong as to be ridiculous

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Pull DIV till it fitting the page

this code is useless for checking this problem
it does not include any of the includes or css
css controls positioning
the included files have content that may push the page around
post a link to the faulty page,

UI / UX Design web-design
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Browser Script Conflicts.(FIREFOX)

It does not work in IE7 either
there are several hundred nul characters scattered at random through the source
redo with a text only editor, or change the editor used config to save html as plain text

Web Development javascript
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: how to install a php script once on a single domain?

php domain lock google search most php obfuscators have a domain lock function
you can configure, zip and disseminate the locked files in one pass

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Please help to find the whois of .in, .co.in etc.
Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Intro Student needs help 
<script type="text/javascript">
function Grades() {
homework = document.getElementById("homeworkbox").value; 
labwork = document.getElementById("labworkbox").value; 
midterm = document.getElementById("midtermbox").value; 
finalexam = document.getElementById("finalexambox").value; 
finalexam = parseFloat(finalexam);
midterm = parseFloat(midterm);
labwork = parseFloat(labwork);
homework = parseFloat(homework);
finalgrade = (.25 * homework) + (.20 * labwork) + (.25 * midterm) +(.30 * finalexam);
document.getElementById("finalgradebox").value = finalgrade; }
</script>

there is an extra quote in the script type definintion
"text"/javascript"
&
you were operating on variables finalexam|midterm|labwork|homework before they were defined
it is easy to do

<script type="text/javascript">
function Grades() {
finalexam = parseFloat(document.getElementById("finalexambox").value);
midterm = parseFloat(document.getElementById("midtermbox").value);
labwork = parseFloat(document.getElementById("labworkbox").value);
homework = parseFloat(document.getElementById("homeworkbox").value);
finalgrade = (.25 * homework) + (.20 * labwork) + (.25 * midterm) +(.30 * finalexam);
document.getElementById("finalgradebox").value = finalgrade; }
</script>

probably runs faster

Web Development javascript
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: The best free site builder?

since the 80s (god I'm old) plain text editors
now notepad++, wamp & DevPHP
probably 2 times faster than I can be with a wysiwg editor, and the code is better, and allows for templating the whole site
Just added six new properties to my site(real estate leasing), ~400 pages in about 5 minutes.
templates and databases

Anything other than FrontPage,
it was barely tolerable when it was first released, and has gottten only further behind with every new version.
MS do have some good software the visual studio set mentioned by Godfear http://www.microsoft.com/express/download/
and there are hundreds of php IDEs at sourceforge.net if your host is not asp enabled

UI / UX Design web-design
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: amazing background

Your second post, with the stamped feet held breath & demand for cooperation, is the behaviour of a ...
the third post in complete denial of your first post is further example of ...

i want to know how i make amazing background like www.elissalovers.net
in photoshop and how
or in flash

utter ...

How not to win friends or influence people
calm it down, look for yourself first, then ask politely.
you dont have the right to expect anything of any other person

plonk

UI / UX Design multimedia web-design
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: "Are pop-up windows dead, are there alternative methods?

popup windows are dead for malware risks
flash is disabled in large and small corporates
Flash and popups severely limit the possible customer base

z-index and invisible/visible layers are the way to go

this post
http://www.daniweb.com/forums/attachment.php?attachmentid=9343&d=1235567703
has an alternative pseudo popup script attached

UI / UX Design ui-ux web-design
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: A reason to use tables instead of divs

I have over 600 pages on my site php generated from sql tables and includes
changing layouts of all takes about a minute,
changing layout of one page only, takes much longer than changing all of them

UI / UX Design web-design
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Cool feature on this website.
UI / UX Design multimedia web-design
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: cross browsing

try to rephrase the post, and describe the problem
post the code that is causing the problem
someone may be able to assist
there is not enough information given in this post

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: including this in php file

first pass
inc_rate.php must be contains a lot of <header> processing

try at the top of the code

<?php require('inc_rate.php'); ?>

then your page
and at the location you want the response

<?php getComments("1");
submitComments("1","$PHP_SELF"); ?>

havent yet read through all the include file,
which also has other includes in it, real spaghetti code,

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Payment gateways?( urgent)

contact paypal
sign up as a merchant
add the code they give you

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: including this in php file

without the rest of the code inc_rate.php so that anyone can find what the functions getcomments() and submitcomments() is supposed to do, its a little difficult
post the code

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: url variables, iframes, and ???

I can do it in php => implies there is a method in ASP
but why an iframe
an include menu is more compliant with more browser types that dont support iframes
any how

in the iframe menu

<a href='/index.php?something=value1' target='_top'>page1</a>
<a href='/index.php?something=value2' target='_top'>page2</a>
<a href='/index.php?something=value3' target='_top'>page3</a>
<a href='/index.php?something=value4' target='_top'>page4</a>
<a href='/index.php?something=value5' target='_top'>page5</a>
<a href='/index.php?something=value6' target='_top'>page6</a>

index.php page

<!doctype blah bla>
<html blah bla>
<head>
bla bla
</head>
<body>bla bla
<iframe src="<?php echo $something; ?>" width='bigenough' height='tallenough' frameborder='0'>iframe</iframe>
</body></html>

cant guarantee the syntax for ASP but there must be an analog

Web Development asp
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: refer files outside a folder

Warning: include_once(./common/dblayer.php) [function.include-once]: failed to open stream: No such file or directory in /home1/careergl/public_html/converters.php on line 8

Warning: include_once() [function.include]: Failed opening './common/dblayer.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home1/careergl/public_html/converters.php on line 8

  1. filenames are quoted include_once('./common/dblayer.php');
  2. count the dots . and .. are not the same
  3. Ensure the file is where you think it is relative to the calling file
Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: i want messaging system

No and I wont install it for you either
GOOGLE

Web Development asp
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: i want messaging system

dont reinvent the wheel
there messaging boards already available for download that work, doo all you ask
and you dont have to code 1000s of lines for

this board runs on one Vbulletin
there are literally 1000s

Web Development asp
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: amazing background

Google
gradient fill
gradient background

its a 1px high, very wide image repeated in Y direction
1000s availble for download at 'webmaster tools' sites

read the css guides on how to repeat backgrounds

try it
if it works Done, yourself
If it doesnt work post the code that didnt and then someone will point you at the cause
nobody is here to do it FOR you
and even less will answer if you behave like an **expletive deleted**

UI / UX Design multimedia web-design
maydhyam commented: Good response! +2
efaith77 commented: I agree almostbob. +3
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: How to rename/hide the title of the popup window

a <div> can be replaced with, or filled with, anything else, so the invisible field can contain anything

if you dont care this 'stuff' that is so important will be invisible to more than can see it
and that anyone can pull the uri from your window whether you display it or not

PLoNK

Web Development javascript
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Text Enable/Disable 
<input type= "text" name ="ch1" <?php if(!S_GET['e'] == 3)  {echo "disabled=\"disabled\"";} ?>">
Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: How to hide query string in url with .htaccess

checkout the apache.org mod_rewrite tutorials

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: keeping checkbox check when page changes

By browser 'back' button or by navigation form buttons, it makes a difference how you navigate

Web Development asp.net
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Get footer down there!

If I can type a url
or cheat any predefiend (fiend=evil sneaky -on purpose not a spelling error) variable
w ww.yoursite.com?path=malwaresite.com/malicious/nasty
and point your pages to something malicious if any path is accessible to the outside world
it may not be very likely -

Murphy II : If anything CAN'T go wrong, it will at the worst possible time.
O'Toole : Murphy is an optimist

If you fix it in design, and lock down the code,
there will never be anyone even look for an attack vector, and you will feel the design effort totally wasted
If you don't, the single tiny obscure security flaw that no-one will notice,
will be hit 10 times in the first 5 minutes

The same can usually be done in php processing and no part of the path be visible to the outside world

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: How to rename/hide the title of the popup window

The attached archive contains a demo file, with no typos
( I dont trust my typing NEmore so its one that does work )
the table cell class='bottom' can contain any other html or iframe or php include, this is just a demo, sizes are adjustable etc

demohome.zip (1.02 KB)
Web Development javascript
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: free PHP script to add calendar
Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: How to rename/hide the title of the popup window

Repeated:: Do Not use Popup Windows, they will be blocked by popup blockers ::
That code Does NOT work on anybody's browser except Yours because everybody else will block your popup windows especially popups that attempt to hide their location, Big RED flags possible malware - or how to get blacklisted 101
Popup will not be seen the information will not be read.

Use a div and hide unhide it as necessary
The div can be any size required and can contain any source required, precisely the same as a popup window, but the div has no displayed uri, and does not trigger popup blockers or any other antimalware scanners

example given in prior post

(And I was even POLITE about it)

Web Development javascript
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Loading Drop down Menu From External File

in the iframe menu
'target='_top' will change the highest level url
target='_parent' will change the immediate parent window url

ergo
menuiframe.html

<a href='home.html' target='_top'>Home</a>
<a href='page1.html' target='_top'>page 1</a>
<a href='page2.html' target='_top'>page 2</a>
<a href='page3.html' target='_top'>page 3</a>

its just a matter of
Read The F(ine) Manual http://www.w3schools.com/tags/tag_a.asp

UI / UX Design web-design
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Get footer down there! 
<div id="footer" style='bottom: 0;'>
Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Web Site using PHP?!?

The same way as you make a website using html
First - read the f manual

think what you want to do
learn how to do it,
Try it
post what didnt work for code gurus to tweak

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Parameter from form combo box to report

post the code for the access guru to look at, wrapped in code tags so it has line numbers etc and one will usually find the problem

Databases microsoft-access
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Problem with Counter

your counter is blocked by my Hosts file, it is externally hosted by a site in the MSMVP hosts file, (not a good thing)
External Javascripts: depend on the availablility of the hosting site. Timeout = no script, I can only assume that the host server times out sometimes and the script is not loaded.

wont even talk about how crap the fixed px divs look sitting in the middle of a 1960px wide screen
try the same proportions in % of screen width for your layout, pleasant surprise, it adjsusts to have a very similar appearance on most monitor os browser window size combinations

eg <div width='150px'> replace with <div width='15%' >
its not so hard, make the site with whatever drag and drop wyswig you like, then edit the html and set relative sizes instead of fixed.
external CSS is better than setting every div to a size separately, and easier

checkout how great/good/ok/bad/ugly your site looks to the rest of the world at http://www.browsershots.org

Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Retrieving WordPress entries to own web hosted site?

RSS, syndicate your wordpress blog(s) and read the most recent rss feed(s) on your web page
http://wordpress.org/extend/plugins/rss-stream/ is the wordpress plugin
and you just get a feedreader plugin for your web page, like http://www.rss-specifications.com/feed2html.htm

UI / UX Design ui-ux web-design wordpress
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: How to rename/hide the title of the popup window

That code is not working on anybody's browser except yours
all recent browsers include popup blockers, you get flagged as a 'bad site'
try using a fixed position div and making it visible or invisible at need.

code snipped, styles set in external stylesheet enough dragged in to make it 'understandable'

<!-- doctype etc html head -->
<script language="javascript" type="text/javascript">
<!--
(document.getElementById) ? dom = true : dom = false;
function hideIt() {
 if (dom) {document.getElementById("layer1").style.visibility='hidden';} //ie gecko
 if (document.layers) {document.layers["layer1"].visibility='hide';} } //mozilla ff
function showIt() {
 if (dom) {document.getElementById("layer1").style.visibility='visible';}
 if (document.layers) {document.layers["layer1"].visibility='show';} }
//--></script>
</head>
<body>
<button onClick="showIt();">Important Information</button>
<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()">
<font color="#ffffff"><Strong>Close</strong></font></td></tr>
<tr><td>important stuff you want em to see</td></tr>
<tr><td align="right" onClick="hideIt()"><font Color="#ffffff"><Strong>Close</strong></font></td></tr>
</table>
</div>
</body>
</html>
Web Development javascript
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Current Working directory

Your code

<link rel = "sheet" style = "text/css" href = "/project/elijah/elijah.css" />

shouild be

<link rel="stylesheet" type="text/css" href="/project/elijah/elijah.css" />

even before you make it

<link rel="stylesheet" type="text/css" href="./elijah.css" />
Web Development php
Member Avatar for almostbob
almostbob 866 Retired: passive income ROCKS
Re: Movie Database

no recommendations, this is the first reult of a google search for private movie rating php script
http://www.howtocreate.co.uk/php/moviedb.html

Databases