Programming Forums > Web Development and Design > PHP

chriswhite · Apr 5th, 2005, 3:49 AM

Ok I have these scripts installed, but have a problem when customizing them.

The Employment script (employment.chalang.com) does not have a full list of states, and cities. What file would I input the information to? The program operates off of phpEmployment that was found at hotscripts.

I also have 2 other programs, Real Estate (realestate.chalang.com, openrealty) and Email (mail.chalang.com, Project Zen Web Mail) these programs work great, but there's a problem in the template. The template does not fill the page. It stops at a certain point, but the php program is still going. For a good idea of what I mean try to search/browse the listings in the real estate. The same problem is at the WebMail.

codetaino · Apr 8th, 2005, 1:09 AM

I would not mind to take a look at the code if you post it here

tempest · Apr 8th, 2005, 1:46 AM

A few seconds scanning a zip archinve of phpEmployment showed a .sql file with tables like pE_city... etc. You'll probably need to take the files you have and parse them to the database...

chriswhite · Apr 8th, 2005, 2:36 AM

I took a look at the .sql file that was contained in the phpEmployment file and found:

INSERT INTO `pE_state` VALUES (2704, 237, 'Abyan');
INSERT INTO `pE_state` VALUES (2719, 240, 'Central');
INSERT INTO `pE_state` VALUES (3743, 241, 'Bulawayo');

I imagine I can add:

INSERT INTO `pE_state` VALUES ( 'Florida');
INSERT INTO `pE_state` VALUES ( 'New York');

However, they have some numbers. What these mean I have no idea, as to what to place in that area. I guess after I find a value for those attributes I should just be able to reinstall the sql file only.

"I would not mind to take a look at the code if you post it here" which code are you referring to? I can post the code, but there are several files, and I'm sure this would create alot of code to sort.

tempest · Apr 8th, 2005, 3:12 AM

(Toggle Plain Text)

CREATE TABLE `pE_state` (
  `id` int(8) NOT NULL auto_increment,
  `country` int(3) NOT NULL default '0',
  `name` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6001 ;

The US country code is 224. Thus the input statements for all US cities would be...

(Toggle Plain Text)

insert into pE_state values("", 224, "Florida");
insert into pE_state values("", 224, "New York");

tempest · Apr 8th, 2005, 3:19 AM

If you want to do cities later...

(Toggle Plain Text)

CREATE TABLE `pE_city` (
  `id` int(11) NOT NULL auto_increment,
  `zip` int(5) NOT NULL default '0',
  `country` int(4) NOT NULL default '0',
  `state` int(11) NOT NULL default '0',
  `areacode` int(3) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=48298 ;

Example:

Houston, TX 77002. Area code: 832.

(Toggle Plain Text)

insert into pe_City values("", 77002, 224, <insert_state_code_for_tx>, 832, "Houston");

Apr 5th, 2005, 3:49 AM	#1
chriswhite Newbie Join Date: Apr 2005 Posts: 5 Rep Power: 0	Few notes Ok I have these scripts installed, but have a problem when customizing them. The Employment script (employment.chalang.com) does not have a full list of states, and cities. What file would I input the information to? The program operates off of phpEmployment that was found at hotscripts. I also have 2 other programs, Real Estate (realestate.chalang.com, openrealty) and Email (mail.chalang.com, Project Zen Web Mail) these programs work great, but there's a problem in the template. The template does not fill the page. It stops at a certain point, but the php program is still going. For a good idea of what I mean try to search/browse the listings in the real estate. The same problem is at the WebMail.

Apr 8th, 2005, 1:09 AM	#2
codetaino Programmer Join Date: Jan 2005 Location: Bayamon, Puerto Rico Posts: 71 Rep Power: 4	I would not mind to take a look at the code if you post it here __________________ "God bless u all" :)

Apr 8th, 2005, 1:46 AM	#3
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 6	A few seconds scanning a zip archinve of phpEmployment showed a .sql file with tables like pE_city... etc. You'll probably need to take the files you have and parse them to the database... __________________

Apr 8th, 2005, 2:36 AM	#4
chriswhite Newbie Join Date: Apr 2005 Posts: 5 Rep Power: 0	few notes about the code I took a look at the .sql file that was contained in the phpEmployment file and found: INSERT INTO `pE_state` VALUES (2704, 237, 'Abyan'); INSERT INTO `pE_state` VALUES (2719, 240, 'Central'); INSERT INTO `pE_state` VALUES (3743, 241, 'Bulawayo'); I imagine I can add: INSERT INTO `pE_state` VALUES ( 'Florida'); INSERT INTO `pE_state` VALUES ( 'New York'); However, they have some numbers. What these mean I have no idea, as to what to place in that area. I guess after I find a value for those attributes I should just be able to reinstall the sql file only. "I would not mind to take a look at the code if you post it here" which code are you referring to? I can post the code, but there are several files, and I'm sure this would create alot of code to sort.

Apr 8th, 2005, 3:12 AM	#5
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 6	(Toggle Plain Text) CREATE TABLE `pE_state` ( `id` int(8) NOT NULL auto_increment, `country` int(3) NOT NULL default '0', `name` varchar(150) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=6001 ; CREATE TABLE `pE_state` ( `id` int(8) NOT NULL auto_increment, `country` int(3) NOT NULL default '0', `name` varchar(150) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=6001 ; The US country code is 224. Thus the input statements for all US cities would be... (Toggle Plain Text) insert into pE_state values("", 224, "Florida"); insert into pE_state values("", 224, "New York"); insert into pE_state values("", 224, "Florida"); insert into pE_state values("", 224, "New York"); __________________

Apr 8th, 2005, 3:19 AM	#6
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 6	If you want to do cities later... (Toggle Plain Text) CREATE TABLE `pE_city` ( `id` int(11) NOT NULL auto_increment, `zip` int(5) NOT NULL default '0', `country` int(4) NOT NULL default '0', `state` int(11) NOT NULL default '0', `areacode` int(3) NOT NULL default '0', `name` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=48298 ; CREATE TABLE `pE_city` ( `id` int(11) NOT NULL auto_increment, `zip` int(5) NOT NULL default '0', `country` int(4) NOT NULL default '0', `state` int(11) NOT NULL default '0', `areacode` int(3) NOT NULL default '0', `name` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=48298 ; Example: Houston, TX 77002. Area code: 832. (Toggle Plain Text) insert into pe_City values("", 77002, 224, <insert_state_code_for_tx>, 832, "Houston"); insert into pe_City values("", 77002, 224, <insert_state_code_for_tx>, 832, "Houston"); __________________

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Programming Forums > Web Development and Design > PHP

Few notes