dbrimlow
-
Posts
712 -
Joined
-
Last visited
Never
Posts posted by dbrimlow
-
-
I changed @ 10 of my php pages back to html.
I revised the pages with pure css layout and converted the navbar includes insert to an external jscript navbar write.
What I want to do is have anyone who bookmarked the php versions of the pages auto-redirected to the new html versions.
I am temporarily using a redirect link within the php pages themselves.
Thanks,
Dave -
You want to use "name based hosts" as follows:
<virtualhost www.cmcdaniel.com>
documentroot c:\apache2\htdocs\cmcwebsite
servername www.cmcdaniel.com
</virtualhost>
<virtualhost www.awesomeframes.com>
documentroot c:\apache2\htdocs\awesomeframes
servername www.awesomeframes.com
</virtualhost>
It is tricky on local binary systems (self installed AMP or phptriad or WAMP).
But it should work. You may have to turn on the name based Vhost mod.
This is assuming that the 2 sites are folders with full websites contained within. If you have one website set up in htdocs, and a folder for the other it will not work.
-
I have two tables that are exactly the same in stucture.
table 1 gets populated by an auto dump sent via a custom 3rd party inhouse application. It works fine for 90% of our tables, but for one table the application is limited ... so I created a manual table to allow showing the same array as all the others.
table 2 is manually populated, to provide data in fields not usually included in table 1 dump.
I then have 2 sets of arrays that search both tables for the same content, and defines how it should display on the page in a description and in a bulleted amenities list. eg:
Table1 select includes -
if ($myrow[coop] == "COOPERATIVE") {
$description .= ", COOP";
$building[]="Cooperative";
}
if ($myrow[coop] == "CONDOMINIUM") {
$description .= ", CONDO";
$building[]="Condominium";
}
if ($myrow[coop] == "CONDOP") {
$description .= ", CONDOP";
$building[]="Cond-Op";
} etc., etc.
Table2 select includes:
if ($mytownhouse[bldg_type] == "townhouse") {
$description .= ", TOWNHOUSE";
$building[]="Townhouse";
}
if($mytownhouse[bldg_type] == "brownstone") {
$description .= ", BROWNSTONE";
$building[]="Brownstone";
} etc., etc.
This worked fine for the first year or so, it would provide data missing in table 1 with data from table 2.
But now, after a recent upgrade of our custom app., the dump is including some of the data that was missing from table1. So now, I am getting duplicate amenities.
These conditional arrays are both HUGE lines of text - easily spanning over 800 lines of code.
What I want know, is if there is an EASY way for me to exclude any duplicates among the tables from displaying, and set one table as the default source in the event of a duplicate?
I can compare each and every field and if both have data, ignore one or the other, but there MUST be a simple tables wide compare statement. Something like:
if (($myrow[$building()] !="") && ($mytownhouse[$building()] !="") {
$building()=$mytownhouse [$building()];
}
I don't know if I explained this coherently or not, and I don't think the above would work.
Dave -
This is also a cool little hack I found online to center a website using css.
body{
margin: auto;
text-align: center;
}
//then put your entire site in a containing div:
#containall{
background-color:#fff;
width: 800px;
text-align:left;
margin: 0 auto;
}
Works fine in IE and FF. You can even take a header out of the container and have it .
-
You are using an "xhtml" doctype, yet your tag level coding is an amazingly frightening jumble of improper xhtml and html 4.0. On a quick check, there are 198 tags that need to be fixed to work as an xhtml. And THAT is only tags. You are also missing a content type meta charset (<meta http-equiv="Content-Type" content="text/html; charset=iso-utf-8" />
In other words ... it is not valid xhtml. It is ignoring almost every rule of xhtml. There should be no capital tag level code. All tags should close ("<BR>" is as wrong as you can get in xhtml. It should be "<br />". And that is only the tip of the iceberg.
This following NOT valid xhtml OR html 4.0!:
<IMG SRC="/images/home/faststreambanner3.gif" alt="" width="564" height="176" border=0 valign=top>
(IMG SRC should be img src, and alt="" should never be empty or missing! all measurements must be something "564" is nothing ... "564px" is something. border=0 is REALLY nothing (even in html 4.0) ... border="0px" is something in html 4.0, there is no such thing as valign=top and "height" should never, NEVER be anywhere in your body tag whatsoever ... it is exclusively a css style.
This is how it would work in xhtml - it should all be in the css under a class div like
.faststreambanner img {
width: 564px;
height: 176px;
border:0px:
padding:0px;
margin:0px;
}
This is even worse:
<div style="border: 2px; #FFFFFF" class="section">
<a class="item2" href="/expressstripe.html">ExpressStripe</a>
<a class="item2" href="/expraid.html">ExpressRaid</a>
<a class="item2" href="/xtend.html">XtendSAN</a>
</div>
What is... style="border: 2px; #FFFFFF" class="section"?
Is it a div style? if so, what is "section"?
"section" should be a style that has "style" attributes INCLUDING "border" style info (border: 2px solid #fff;)
This is just plain sloppy - where are the semi-colins? what is a "10"?:
<style type="text/css">
<!--
.style1 {font-size: 12px}
.style3 {font-size: 10px}
.style4 {font-size: 10}
.style5 {color: #FF0000}
.style6 {font-weight: bold}
-->
</style>
The code is so bad that even the w3c html validator blew up!
[a href=\"http://validator.w3.org/check?verbose=1&uri=http%3A//www.attotech.com/index.html\" target=\"_blank\"]http://validator.w3.org/check?verbose=1&ur....com/index.html[/a]
Your css is scary! Absolutely NO browser other than IE can understand this.
IE will take any "junk" code and display it as valid. But ANY Standards compliant browser will smack you in the back of the head for using code like this.
Your whole site needs to be fixed to comply with either html 4.0 or xhtml (whichever you finally settle on).
Your css needs to be completely revised ... I have no idea where this came from, but you have a few style sheets that seem to have the same tag level function (which means only the one that is last in your order will work (the "cascade" in css). Do you really know what each css item is for?
Tag selectors:
yours (note missing semi-colin)-
A {
TEXT-DECORATION: none
}
BODY {
FONT-SIZE: 12px; COLOR: #000000; FONT-FAMILY: Arial, Helvetica, sans-serif; BACKGROUND-COLOR: #FFFFFF;}
correct:
body {
font-size: 12px; color: #000000; font-family: Arial, Helvetica, sans-serif; background-color: #FFFFFFA;
}
a {
text-decoration: none;}
*****************************
But! Here is the "good news". If you change your doctype to html 4.0:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
You have under 30 validation error. that are easily fixed.
I applaud anyone who trys to get there code working outside of IE, and it's intentionally counter-web standards BS. It takes time to be "de-programmed" like anyone removed from an evil cult does ... but it is well worth it. Becaue you will suddenly notice better goodle placement for natural search results as well as at least a 20% increase in activity (those who would rather stick needles in their eyes than use IE).
The best tool to help fix your website is the w3c html validator at:
[a href=\"http://validator.w3.org/\" target=\"_blank\"]http://validator.w3.org/[/a]
Once the html is valid, go and validate your css at [a href=\"http://jigsaw.w3.org/css-validator/\" target=\"_blank\"]http://jigsaw.w3.org/css-validator/[/a]
Good luck!
Dave -
[!--quoteo(post=339511:date=Jan 24 2006, 02:18 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jan 24 2006, 02:18 PM) [snapback]339511[/snapback][/div][div class=\'quotemain\'][!--quotec--]
No idea -- that makes no sense at all.
[/quote]
LOL!!!! That's what we've been saying!
Okay, it has to be related to the fact that I am using w3c standard. That's really the only difference between FF and IE that could cause this.
THEREFORE, it MUST be something in the way we are instructing the php to INSERT and auto increment.
Okay. I just created a record and it worked fine. THEN I added the above html back to the table and WHAMMO! Duplicate blank entry!!!! I'm sorry, this is really really weird!
Here is the auto-increment command and the first of the insert commands (7 tables - 7 query inserts):
//get next available id number
$maxquery = "select * from setups order by id asc";
$max_result=mysql_query("$maxquery") or die(mysql_error());
while($result_row=mysql_fetch_array($max_result)) {
$id = $result_row[id];
}
$id++;
//store data into setup table
$query = "insert into setups (id, address, city, state, location, block, lot, bldg_size, land_area, zoning, stories, description2, sale_price, contact, title, exclusive, show_address, form_type) values ('$id', '$address', '$city', '$state', '$location', '$block', '$lot', '$bldg_size', '$land_area', '$zoning', '$stories', '$description2', '$sale_price', '$contact', '$title', '$exclusive', '$show', '$form_type')";
$result=mysql_query("$query") or die(mysql_error());
//store data into photo table
$photo_query = "insert into photo....(I used same format as above for all of the queries)"
//store data into expense table
$expense_query = "insert into expense...
//store data into cost table
$cost_query = "insert into cost ...
//store data into income table
$income_query = "insert into income ...
//store data into date table
$date_query = "insert into date ...
//store data into rent table
$rent_query = "insert into rent...
mysql_close();
?>
Now. Someone tell me how would any subsequent html tag could add a row to the tables?
Dave -
I have a php form that sets an ID auto increment insert whenever a new row (record) is added by form.
It works fine when submitted via IE.
But, when submitted via FF it adds a blank row to the DB table (along with the correct row) and auto increments them both (ex: id 07 & id 08)!
We scoured the code and could find no reason for it to do this. Then, I noticed, and removed, 2 small unecessary (and improperly used) image placeholders in two <td> tags:
<tr>
<td><img name="placeholder" src="" width="32" height="1" alt="placeholder"></td>
<td width="220"><img src="" width="220" height="1" alt="" style="background-color: #FFFFFF" /></td>
When removed, it properly inserted one incremented row.
How could a static html tag (no matter how poorly entered) dynamically add an insert to a table?
For the static tags, I use validated w3c standard xhtml transitional (which the TD tags obviously didn't conform to).
I don't get it.
-
[!--quoteo(post=330045:date=Dec 23 2005, 04:54 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Dec 23 2005, 04:54 PM) 330045[/snapback][/div][div class=\'quotemain\'][!--quotec--]
The inconvenience of having to have similar login credentials to both DBs precludes to use of this technique for any DB that you haven't explicitly set up in this fashion. If it's up to you, keep the related tables in the same DB; if it's not, consider doing this in middleware or via temporary tables, otherwise you'll get caught with your pants down in the credentials ever change!
I suppose the other important issue is making sure there is a common relational key (ID) between the 2 DB tables.
-
[!--quoteo(post=330058:date=Dec 23 2005, 05:21 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Dec 23 2005, 05:21 PM) 330058[/snapback][/div][div class=\'quotemain\'][!--quotec--]
First, even with a standard upload form, you should be able to automatically change the name of the uploaded file to whatever you want -- including the listing ID -- so I don't understand why this is a problem.
Second, storing binary data in BLOBs is OK, as long as a) you store the BLOBs in their own table with a foreign key referencing the listings and b) you don't store the entire binary data object in a single BLOB field.
Take a look at [a href=\"http://php.dreamwerx.net/forums/viewtopic.php?t=6\" target=\"_blank\"]this excellent tutorial[/a] -- it covers all of the scripting, and addresses my two caveats above as well.
Hope that helps.
Thanks. I decided to do the smart thing and simply have the photo upload as a pop-up ( after the form submit is clicked) that loads them to a folder, renames them (12345a, b, c, d, etc) which auto associates them with the listing ID. I'll have the form include a hidden link to the photos file using the listing ID (12345a,b, c, d) pointing to the folder where photos are stored.
I appreciate the reply.
Dave
-
I am creating a form that among various and typical fields, there is a photo upload.
My user is a specialized real estate agent, so I need to attempt using as few steps as possible for them to enter the listing data.
Usually, I edit, name and upload photos to a folder and have a link in the db (the photo naming conventions I use are the listing ID# (234567a, 234567b, etc.).
But in this case, I simply want to automate the process as much as possible. This bozo is not going to rename the photos, so creating two forms will not help the photo associate with the listing ID.
I was thinking of simply uploading the photo and inserting it into the DB along with the other fields.
Can, and if so, how, would one upload binary media like photos, mp3s, etc.?
I tried making the field, blog-binary, and it did upload, but I haven't tried to display it, yet. Of course, doing a query in phpmyadmin just shows the actual binary code.
-
Can someone point me in the right direction? I am using Dreamweaver MX 2004 and need help with a dynamic site. I am using mysql and PHP through Dreamweaver.
I have a record store selling on artist’s albums.
The album.php page shows all the albums and allows you to select which album you want to see detail. The albumID is passed to the album_detail.php page. This page has album descriptions, price, etc. It also list the songs In the album. This all works. I want the viewer to click on the sing name and it will play a sample of the songs. That’s where I am having a problem. See below.
I have a database with a table album and song. Following is the database sql. on.
/*
SQLyog Enterprise v4.0
Host - localhost : Database - isaiahrecords
**************************************************************
Server version 4.0.0-alpha-nt
*/
create database if not exists `isaiahrecords`;
use `isaiahrecords`;
/*
Table structure for album
*/
drop table if exists `album`;
CREATE TABLE `album` (
`albumID` int(11) NOT NULL auto_increment,
`album_name` varchar(70) default NULL,
`album_description` text,
`album_price` varchar(7) default NULL,
`album_cover` varchar(100) default NULL,
`album_coverthumbnailURL` varchar(100) default NULL,
`album_special` char(3) default NULL,
`album_buy` varchar(255) default NULL,
PRIMARY KEY (`albumID`)
) TYPE=MyISAM;
/*
Table data for isaiahrecords.album
*/
INSERT INTO `album` VALUES
(1,'Ask','This cd is dedicated to the many children of God who are smooth jazz lovers. The project is a presentation of familiar jazz tunes that have been remixed, rewritten and crossed over to portray a version that expresses the life of Christ and timelessness of His Word. Get ready jazz lovers, this one will keep you with your finger on the repeat button. The Jazz Project , created for your listening pleasure. Enjoy it with all of your friends.','15','Albumcovers/ask.jpg','Thumbnails/ask_thumb.jpg','no','http://www.aitsafe.com/cf/add.cfm?userid=3351260&product=Ask Album CD&price=15.00&units=1&return=isaiahrecords.com'),
(2,'Crossing Over','This cd is dedicated to the many children of God who are smooth jazz lovers. The project is a presentation of familiar jazz tunes that have been remixed, rewritten and crossed over to portray a version that expresses the life of Christ and timelessness of His Word. \n\nGet ready jazz lovers, this one will keep you with your finger on the repeat button. The Jazz Project - created for your listening pleasure. Enjoy it with all of your friends.','15','Albumcovers/jass.jpg','Thumbnails/jass_thumb.jpg','no','http://www.aitsafe.com/cf/add.cfm?userid=3351260&product=The Jazz Project Album&price=15.00&units=1&return=isaiahrecords.com'),
(3,'One More Night with The Frogs','One More Night With The Frogs - Presenting new album from Arthur. It is an uplifting mixture of smooth jazz and some originals from Arthur that will truly bless your soul. And of course, there is \"The Frog!\".','15','Albumcovers/frog.jpg','Thumbnails/frog_thumb.jpg','no','http://www.aitsafe.com/cf/add.cfm?userid=3351260&product=One MoreI Night With The Frogs&price=15.00&units=1&return=isaiahrecords.com'),
(4,'Making Music I - Authur & Family','Arthur and Family Vol. 1 offers an assortment of Arthur’s most requested concert selections like “I’ll Tell It” and “Center Of My Joy.” This project includes a captivating background vocal mix featuring some of the most gifted vocalist from Arthur’s church family. Listen to the debut of Arthur’s daughter Alex as she sings lead on the crossover and remix of the song “Missing You” which also includes a special debut of the poetic voice of her mother Jill. The songs on Family Vol. 1 are prepared and selected for the enjoyment of the whole family! ','15','Albumcovers/mm1.jpg','Thumbnails/mm1_thumb.jpg','no','http://www.aitsafe.com/cf/add.cfm?userid=3351260&product=Making Music II II Album&price=15.00&units=1&return=isaiahrecords.com'),
(5,'Making Music II - Authur & Family','Arthur and Family Vol. 2 presents a “live” concert performance where Arthur is joined by friends who present a variety of musical styles and talents. The background vocalists from Vol. 1 are out front singing inspirational songs of worship and praise. Listen for yourself and experience praise and worship in an atmosphere filled with joy and excitement. Join in and sing along to some of your favorite tunes!','15','Albumcovers/mmII.jpg','Thumbnails/mmII_thumb.jpg','no','http://www.aitsafe.com/cf/add.cfm?userid=3351260&product=Family Album CD&price=15.00&units=1&return=isaiahrecords.com'),
(6,'Christms Joy','Christmas Joy Enjoy your holiday season with Arthur and the Northside Baptist Celebration Choir, singing a selection of favorite Christmas songs. Prepare to clap and sing along as Arthur and the Sarasota Baptist Church Choir sing their special rendition of “I Have Seen the Light” and “Go Tell It On The Mountain.” Reminisce on Christmases past while listening to medleys of popular Christmas classics, which include \"Chestnuts Roasting On An Open Fire.” Christmas Joy is a CD that you’ll want to listen to all year round! \n\n','15','Albumcovers/christmasjoy.jpg','Thumbnails/christmasjoy_thumb.jpg','no','http://www.aitsafe.com/cf/add.cfm?userid=3351260_\"uct=Christian Joy CD&price=15.00&units=1&return=isaiahrecords.com');
/*
Table structure for albumkey
*/
drop table if exists `albumkey`;
CREATE TABLE `albumkey` (
`albumkeyID` int(11) NOT NULL auto_increment,
`albumID` int(11) default NULL,
`songsID` int(11) default NULL,
PRIMARY KEY (`albumkeyID`)
) TYPE=MyISAM;
/*
Table data for isaiahrecords.albumkey
*/
INSERT INTO `albumkey` VALUES
(1,1,1),
(2,1,2),
(3,2,3),
(4,2,4),
(5,3,5),
(6,3,6),
(7,4,7),
(8,4,
,(9,5,9),
(10,5,10),
(11,6,11),
(12,6,12);
/*
Table structure for songs
*/
drop table if exists `songs`;
CREATE TABLE `songs` (
`songsID` int(11) NOT NULL auto_increment,
`song_name` varchar(50) default NULL,
`song_file` varchar(100) default NULL,
`song_time` varchar(10) default NULL,
PRIMARY KEY (`songsID`)
) TYPE=MyISAM;
/*
Table data for isaiahrecords.songs
*/
INSERT INTO `songs` VALUES
(1,'Ask','http://isaiahrecords.com/Music/Ask/Ask.ram','3'),
(2,'Are you sure','http://isaiahrecords.com/Music/Ask/Are you sure.ram','3'),
(3,'In The Beginning','http://iasishrecords/Music/Jass_Project/IN_THE_BEGINNING.RAM','3'),
(4,'Moomba','http://isaiahrecords/Music/Jass_Project/MOOMBA.RAM','3'),
(5,'Frog','http://isaiahrecords/Music/One_More_Night_With_The_Frogs/Frog.ram','3'),
(6,'Good Fruit','http://isaiahrecords/Music/One_More_Night_With_The_Frogs/Good_Fruit.ram','3'),
(7,'You Bring Me Up','http://isaiahrecords/Music/MMV1/Bring me up.ram','3'),
(8,'Jesus Loves Me','http://isaiahrecords/Music/MMV1/Jesus Loves me.ram','3'),
(9,'O Happy Day','http://isaiahrecords/Music/MMV2/O Happy day.ram','3'),
(10,'People Get Ready','http://isaiahrecords/Music/MMV2/People get ready.ram','3'),
(11,'A King Is Born','http://isaiahrecords/Music/Christmas_Joy/KING IS BORN.RAM','3'),
(12,'Amen','http://isaiahrecords/Music/Music/Christmas_Joy/AMEN.RAM','3');
The pages are album.php and album_detail.php. The album.php feeds the album_detail.php with the albumID.
The recordset rs_album_detail is as follows:
SELECT album.albumID,album.album_cover,album. album_name, album.album_description, album.album_price, album.album_buy, songs.song_name, songs. song_time, songs.song_file
FROM album, albumkey, songs
WHERE album.albumID = albumkey.albumID AND songs.songsID = albumkey.songsID AND album.albumID = colname
The variables box I have :
Name =Colname Value =1, and runtime=$HTTP_GET_VARS['albumID']
Code: <?php
$colname_rs_album_detail = "1";
if (isset($HTTP_GET_VARS['albumID'])) {
$colname_rs_album_detail = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['albumID'] : addslashes($HTTP_GET_VARS['albumID']);
}
mysql_select_db($database_cn_isaiahrecords, $cn_isaiahrecords);
$query_rs_album_detail = sprintf("SELECT album.albumID,album.album_cover,album. album_name, album.album_description, album.album_price, album.album_buy, songs.song_name, songs. song_time, songs.song_file FROM album, albumkey, songs WHERE album.albumID = albumkey.albumID AND songs.songsID = albumkey.songsID AND album.albumID = %s", $colname_rs_album_detail);
$rs_album_detail = mysql_query($query_rs_album_detail, $cn_isaiahrecords) or die(mysql_error());
$row_rs_album_detail = mysql_fetch_assoc($rs_album_detail);
$totalRows_rs_album_detail = mysql_num_rows($rs_album_detail);
?>
I am trying to play a audio stream from the songs table: I dragged The {rs_album_detail.song_name} from the recordset and went to the link box in properties, clicked on datasource and selected song_file from the record set. It is not selecting the proper song when going from ablum.php to album_detail.php Everything else on the page works putting the right songs on the page. That tells me my joins are working properly. It
Just don’t know how to get the songs file to go with the correct album and steam the file. The song file is in the database in the songs.song_file.
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="43%" align="right"><div align="left"><a href="<?php echo $row_rs_album_detail['song_file']; ?>?albumID=<?php echo $row_rs_album_detail['albumID']; ?>"><?php echo $row_rs_album_detail['song_name']; ?></a></div></td>
<td width="57%" align="left"><?php echo $row_rs_album_detail['song_time']; ?></td>
</tr>
<tr>
<td colspan="2"><img src="images/Line.gif" width="542" height="8"></td>
</tr>
</table>
<?php } while ($row_rs_album_detail = mysql_fetch_assoc($rs_album_detail)); ?>
I can't see how you are streaming an audio file of any kind. Is it mp3? WMA?
The easiest way is to generate an .m3u file that points to and streams an mp3.
What media are you trying to play?
Comparison script before creating table?
in MySQL Help
Posted
I have data dumps that are uploaded via a 3rd party. They upload the .psv file into a folder a few times daily similar to this:
>>/usr/home/master/usr/home/somefolder/somedatadump.psv<<
I have a crontab that runs a few times daily to open mysql and run a command .sql file similar to this:
>>* * * * /usr/home/master/usr/local/bin/mysql -u uname -p pword < /usr/home/master/command/command.sql 1> /dev/null<<
The command.sql file is basic like this:
>>use somedatabase;
drop table if exists sometable;
CREATE TABLE sometable (
numb int(10) unsigned NOT NULL default '0',
ai varchar(15) default NULL,
etc char(3) default NULL,
and_so_on char(3) default NULL,
PRIMARY KEY (numb)
);
load data infile "/usr/home/master/usr/home/somefolder/somedatadump.psv" into table sometable fields terminated by "|";<<
Okay. This works fine. The problem is, @ twice a year the 3rd party "file system" gets full; when this happens it uploads blank "somedatadump.psv" files. This obviously drops the old table and creates it anew with no data.
I would like to be able to check the "somedatadump.psv" file to be sure it has data before dropping and recreating the table.
I don't know if I can do a comparison in the beginning of the "command.sql" file, something like this:
>>
if "/usr/home/master/usr/home/somefolder/somedatadump.psv" NOT NULL ;
use somedatabase;
drop table if exists sometable;
CREATE TABLE sometable (
numb int(10) unsigned NOT NULL default '0',
ai varchar(15) default NULL,
etc char(3) default NULL,
and_so_on char(3) default NULL,
PRIMARY KEY (numb)
);
load data infile "/usr/home/master/usr/home/somefolder/somedatadump.psv" into table sometable fields terminated by "|";<<
Not sure what syntax applies or if "else" is required.
Thanks,
Dave