Jump to content

dipp02

Members
  • Posts

    32
  • Joined

  • Last visited

    Never

Contact Methods

  • Website URL
    http://www.dbhosts.net

Profile Information

  • Gender
    Male
  • Location
    Philadelphia

dipp02's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I am having problems with the css. should i use floats? or absolute position? i tried both ways and having problems. i cannot get this to even work <div style="background-image: url('bot.png'); background-repeat: repeat;"> nothing shows up unless i give it a width or height but then it repeats only to that width/height. any ideas? thanks in advance.
  2. i can do that. i was trying to think of the easiest way. repeat the left n right?
  3. i was thinking of doing four divs. the sides (left and right). middle and bottom..... any other ideas?
  4. Hello. i have a layout and i am having too many thoughts going through my head on how to make this bg on this layout here: http://classic-threads.com/ to go across the whole page. can someone please help? i have it in a PSD format so i can get to the layers. this is driving me crazyyy.
  5. Hello, I am helping out a client and for some odd reason in Firefox the CSS renders fine. when i test the site in IE8 the CSS renders and then quickly disappears. the CSS is crashing. is it the CMS or template the client is using? The client is using a framework. here is the dev link. http://canals-dev.mics.me/home The home page is rendering fine, the contact us seems to work fine. other pages the CSS is crashing. Any ideas? Thanks in advance
  6. How can i do this so on every computer the company thats next in line comes up on every computer not just on the computer i am on? using sessions will only happen to that one computer. so if company 1 is up and i refresh the page company 2 comes up. but on a totally different computer company 1 shows up and not company 3 which is next in line. should i just use a simple for loop? any ideas? i was going to make a field in the database under the company table called 'position' and add/minus the position number everything the page refreshes. Any help on this would be great! Thanks in advance!
  7. Thank you very much for the reply! this should help me get it going. Thanks!
  8. Hello. I am creating a function for a site to show a list of companies with phone, addy, email, website, etc.. with about 10 listings that will show up on the page so some listings will be "off the screen". what the client would like to have the list do so each company will have a turn at the top of the page. is when the page refreshes the company at the bottom of the list will go to the top of the list and so on. or if anyone has any other idea on how to have each company have a turn at the top of the page... i am using framework codeigniter and mysql database for the site. if i wasn't clear please let me know so i can explain better. Thanks in advance.
  9. hello, i have mod rewrite working great but i just noticed about the trailing slash... i then put this code in at the top of my .htaccess file RewriteEngine on RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_URI} !(.*)/$ RewriteRule ^(.*)$ http://phillyedm.com/$1/ [L,R=301] now when i goto "phillyedm.com/about" it redirects me to "phillyedm.com/about/" which is what i want... but now when i try and goto my blog system which is "phillyedm.com/blog/1" i get a 404 error.... here is my full .htaccess file. RewriteEngine on RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_URI} !(.*)/$ RewriteRule ^(.*)$ http://phillyedm.com/$1/ [L,R=301] RewriteRule ^blog/([^/]*)$ /blog.php?page=$1 [L] RewriteRule ^blog/([^/]*)/([^/]*)/([^/]*)$ /blog.php?page=$1&catid=$2&list=$3 [L] RewriteRule ^article/([^/]*)$ /comments.php?article=$1 [L] RewriteRule ^article/([^/]*)/editCmmt/([^/]*)$ /comments.php?article=$1&editCmmt=$2 [L] RewriteRule ^article/([^/]*)/edit/([^/]*)$ /comments.php?article=$1&edit=$2 [L] RewriteRule ^article/([^/]*)/del/([^/]*)$ /comments.php?article=$1&del=$2 [L] RewriteRule ^article/([^/]*)/del/([^/]*)/yes/([^/]*)$ /comments.php?article=$1&del=$2&yes=$3 [L] RewriteRule ^article/([^/]*)/delCmmt/([^/]*)$ /comments.php?article=$1&delCmmt=$2 [L] RewriteRule ^article/([^/]*)/editCmmt/([^/]*)$ /comments.php?article=$1&editCmmt=$2 [L] RewriteRule ^article/([^/]*)/done/([^/]*)$ /comments.php?article=$1&done=$2 [L] RewriteRule ^article/([^/]*)/delCmmt/([^/]*)/yes/([^/]*)$ /comments.php?article=$1&delCmmt=$2&yes=$3 [L] any ideas on how to get the "blog/1" to work? and also redirect me to "blog/1/" ? i also have some urls with 3 vars like so -> "article/20/edit/20" and would like it to redirect to ... "article/20/edit/20/" any ideas? i have tried this: RewriteEngine on RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_URI} !([^/].*)/$ RewriteRule ^([^/].*)$ http://phillyedm.com/$1/$2/$3 [L,R=301] but it then does this -> "phillyedm.com/blog/1//" adds two slashes at the end. thanks a bunch.
  10. can anyone help me? am i setting up the databases correctly in post #5 ?
  11. Intro Ok i spent pretty much all day reading up on MySQL and database realtionships and normalzation. I even went out and bought two books to read up on. 1. How to do everything with PHP and MySQL- Vikram Vaswani 2. Beginning PHP and MySQL E-Commerce from novice to professional 2nd edition - Danrie and Balanescu Ok so since my first post is totally wrong i would like to start fresh and give as much detail as possible. First off, Thise is the current site my client has up now. www resumeref.com - You can see for yourself to see kinda what i am trying to do. login with my test account and see how the resume builder works. but my goal is to make it look alot cleaner, and flow nicer. Login info: UN:bob@dbhosts.net PW:qwertyui Also i just i just put that current header up as a temp. because the client is changeing the site over to downloadmyresume domain name since he doesnt like the ref concept. But anyways the site is in ASP and i do not know much of ASP so i am recoding the whole site from top to bottom. i made a new design and everything in PHP MySQL and CSS. here is my current test site for the new design www dbhosts.net/resume/login/ What i am trying to do: I am creating a resume builder wizard but the user must be signed up to start using it. once the user has a login the wizard will go through about 5-6 steps to create the full resume. After the user goes through all the forms and has previewed the resume they will be prompt to select a membership type and then pay through paypal. Once the payment is sent the wizard is going to e-mail the user their resume in either .doc format or .pdf format and also host thier resume on the downloadmyresume server for 90-days. (Any Suggestions with how i will convert the data from mysql into a .doc template or pdf, then host it for 90days?), There will be different user levels to determine the users membership. There will be four kinds of memberships: Regular User - just signed up for a login. never bought a resume. Subscribed - for around 12 bucks- you get 1 executive resume emailed to you and it will be hosted for 90days. Lifetime - for around 50 bucks - the user will be able to come back edit, add new resumes at anytime and every resume will be hoste for 90days. Admin - has control over the Admin center which will be able to view the clients and memberships etc. Right now i am creating the database. and this is what i came up with so far. one table for the users and then i am going to have 6 tables for the wizard. one called wizard that holds the reusmeid username userid and userlevel. the others will be called wizard_contact, wizard_profile, wizard_edu, wizard_exp, wizard_custom. each table will be a different step for the user to enter info into on the site. ( Please, any advice, suggestions with the following? it will be very helpful) note: i only posted the first three tables of the wizard and the users table. i need to know if i am doing this right. # # Table structure for users table # DROP TABLE IF EXISTS users; CREATE TABLE users ( userid int(11) NOT NULL auto_increment, username varchar(30), password varchar(32), userlevel tinyint(1) unsigned not null, email varchar(50), timestamp int(11) unsigned not null, Primary Key (userid, username) type=INNODB ); /* # # Table structure for wizard table # */ DROP TABLE IF EXISTS wizard; CREATE TABLE wizard ( resumeid int(11) not null auto_increment, users_userid int(11) unsigned not null, username varchar(30), userlevel tinyint(1) unsigned not null, timestamp int(11) unsigned not null, Primary Key (resumeid), Foreign Key (users_userid) references users(userid), type=INNODB ); /* # # Table structure for wizard contact table # */ DROP TABLE IF EXISTS wizard_contact; CREATE TABLE wizard_contact ( contact_resumeid int(11) not null, fname varchar(30) not null, lname varchar(30) not null, street varchar(80) not null, city varchar(30) not null, state char(2) not null, zip mediumint(5) unsigned not null, phone varchar(14) unsigned not null, cell varchar(14) null, Foreign Key (contact_resumeid) references wizard(resumeid), type=INNODB ); # # Table structure for wizard profile table # DROP TABLE IF EXISTS wizard_profile; CREATE TABLE wizard_profile ( profile_resumeid int(11) not null, profile text not null, keystrength1 varchar(30) not null, keystrength2 varchar(30) not null, keystrength3 varchar(30) not null, keystrength4 varchar(30) not null, Foreign Key (profile_resumeid) references wizard_contact(contact_resumeid), type=INNODB ); Am i headed towards the right track now with the database? was i clear enough in what i need to do? please let me know, anything will be helpful. Thanks in advance.
  12. OK thanks i just needed to know if i was doing it right before i start actually doing it. I will look up normalization and post back. Thanks for your input.
  13. Any Advice? am i setting these tables up correctly? Thanks
  14. Hello i need a little advice and help. I am coding a resume builder website. Right now i have the login system coded with different access levels. and i am starting to create the actual resume builder itself and need some help on creating the wizard database. For the login system there are 4 tables. (users, active_users, active_guests, banned_users) In the users, active_users, banned_users table there is a primary key for the field username. Here is the SQL code for the login system: # # Table structure for users table # DROP TABLE IF EXISTS users; CREATE TABLE users ( username varchar(30) primary key, password varchar(32), userid varchar(32), userlevel tinyint(1) unsigned not null, email varchar(50), timestamp int(11) unsigned not null ); # # Table structure for active users table # DROP TABLE IF EXISTS active_users; CREATE TABLE active_users ( username varchar(30) primary key, timestamp int(11) unsigned not null ); # # Table structure for active guests table # DROP TABLE IF EXISTS active_guests; CREATE TABLE active_guests ( ip varchar(15) primary key, timestamp int(11) unsigned not null ); # # Table structure for banned users table # DROP TABLE IF EXISTS banned_users; CREATE TABLE banned_users ( username varchar(30) primary key, timestamp int(11) unsigned not null ); Now once the user logins they will be able to view the page wizard.php and be able to start the resume builder wizard. Once the user is in the wizard.php i want the contact info form to show up and once the next button is hit the profile form shows up and so on... (this i have down pretty good). After the resume info is collected the info will be put into wither a .doc or .pdf into a resume template format. (may need help when i get to this part) I just want to make sure i am headed towards the right direction in creating the database for the wizard. So far, I have created 4 tables for the resume builder - (wizard_contact, wizard_profile, wizard_edu, wizard_custom) I made separate tables because each table will be associated with a different form. (ex. contact info form will store into wizard_contact, profile form will store into wizard_profile, etc..) here is the code i have down for the SQL database for the wizard so far- /* # Resume Builder Database # wizard_contact # wizard_profile # wizard_edu # wizard_custom # */ # # Table structure for wizard contact table # DROP TABLE IF EXISTS wizard_contact; CREATE TABLE wizard_contact ( resumeid mediumint(9) primary key not null auto_increment, username varchar(30) foreign key, fname varchar(30) not null, lname varchar(30) not null, street varchar(80) not null, city varchar(30) not null, state char(2) not null, zip mediumint(5) unsigned not null, phone varchar(14) unsigned not null, cell varchar(14) null ); # # Table structure for wizard profile table # DROP TABLE IF EXISTS wizard_profile; CREATE TABLE wizard_profile ( resumeid mediumint(9) foreign key, profile text not null, keystrength1 varchar(30) not null, keystrength2 varchar(80) not null, keystrength3 varchar(30) not null, keystrength4 varchar(30) not null, ); I stopped there because i just want to make sure i am setting up the database correctly. Here is where i need some advice/help. there is a resumeid that is going to be the primary key and an automatic number for that certain resume. i did this so the user can create more than one resume. (am i right here?) Also i brought in the username as a foreign key because i dont want everyone to be able to view each others resumes. and also to make sure that certain resumeid is assocated with that username. (am i right here?) for the wizard_profile i brought in the resumeid as the foreign key so it can be associated with the correct info in wizard_contact. (am i right here?) now this is what i would do for the next table wizard_edu... # # Table structure for wizard edu table # DROP TABLE IF EXISTS wizard_edu; CREATE TABLE wizard_edu ( resumeid mediumint(9) foreign key, school varchar(30) not null, startdate date not null, enddate date not null, degree varchar(30) not null, major varchar(30) not null, minor varchar(30) unsigned not null, educity varchar(30) unsigned not null, edustate char(2) null ); Was i clear on what i am trying to do? Please let me know if i am doing this correctly. or if i am semi correct. or if i am just totally wrong. i will take all the advice i can get. Thanks in advance.
×
×
  • 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.