Forgot your password?
Posted March 19, 2010
What do you think about my report?
I've been wanting to launch a classifieds website for years. I know it's a pretty flooded market right now. There's classifieds website popping up everywhere. I find the current classifieds website too busy and some are just crap. You can hardly find what you typed in the search.What if I built the site to be simpler than current website kind of like the google search page. The search box would be the main focus. I would also have newest ads displayed and the categories could be browsed on the homepage. I would be using a modified version of the classipress template for wordpress.I'm thinking users should be able to sell anything not just cars, houses, etc.Can this work?
Website Reviewed: http://krom-bg.net/FontsObservations
Search Engine Optimization (SEO)Observations
Currently reviewing http://krom-bg.net/If I get interest, I will design a basic review tool in python.
Posted March 18, 2010
I'm starting a website reviewing business and I'm looking for some experience and feedback regarding the website reports I provide. These reports include all of the following points:
If you would like your website reviewed, go ahead and post your url. I would like you to review my report once I have completed the review of your website. Also, remember I am alone in this so don't expect the reports to be completed within an hour.
Posted January 25, 2010
I'm asking myself if I require Wordpress for the project I have in mind. This website will have about 5 pages and maybe a blog I'm not sure (forget about the blog for now). Here are the questions I am asking myself:
Posted June 29, 2009
Edited June 29, 2009 by vchris
How do I go about implementing caching?I tried putting <cfcache action="cache" /> as the first line on my results.cfm page. The performance doesn't seem to be improved and no .tpm files seems to be created.
Posted June 19, 2009
I haven't yet tried caching but I'm curious to see if putting the query inside a structure instead of looping the query many many times.
Posted June 9, 2009
Edited June 10, 2009 by vchris
Caching right?How would it work if the data displayed is always different? I currently have 4 years available (2004-2007). In total I have about 1500 rows of data. Are you asking me to cache the whole 1500 rows and then only display the required rows depending on the search entries? How would that work? The first time it loads before caching will take ages.
Posted June 8, 2009
I'm redesigning the website and DB at work. Here's how it works.I changed the DB so all the data is in one table, instead of 2-3 previously. I also changed the unique id to a no unique ids. Now the ids are the gid combined with the year field. This will give you 1 row. This way any table can be updated or reloaded from scratch without any unique id issues.The problem is when attempting to generate of the results table. There's 26 different substances. Here's a sample: CO2, N2O, CH4, HFC, PFC, SF6. HFC and PFC make up of many sub-substances.Show Substance:Identify which substance to display (if a selection was made).Convert to CO2:Convert each substance to co2. In my Substances table I have a gwp field which is the multiplier to convert to co2. HFC and PFCI need to add all sub-substances to get PFC and then HFC. There is a field in the Substances table that holds the category in which a pollutant is (pfc, hfc, total).Calculate row total:calculate the total of a row of substance (n2o + co2 + pfc...)Calculate grand total:calculate the total of a column (co2 + co2...)I got most of this done. The way I did it was with a dev array which is a 3 dimension array that holds the substance name, gwp multiplier, raw data, data converted to co2, show sub (true/false). I then create a 2d array that mirrors an excel table. All I need to do at this point is calculate the row and grand total and then display. I got all this done but the load time is pretty high. When attempting to load 350 rows it hangs there for way too long. Less than 20 rows is fine. To display the data I create about 8 arrays, use a cfcomponent, use about 10 functions., many loops.I'm sure there is a better way of building this. I built this system using object oriented programming.Would using a structure instead of 8 array help or maybe 1 huge array?
Posted April 26, 2009
I downloaded flashfxp and that seems to work but I'm curious to see if fireftp can do it.
I've been using fireFTP for years. It's great!At home I have my computer I work on and a server for testing my apps. When on my computer, I would like to be able to FTP from my web dev server to my live server.FireFTP is saying "You do not have the appropriate permissions or directory does not exist". Everyone has access to the server. What is necessary for me to be able to do this?
Posted April 22, 2009
Nice! Actually my work is sending me to school to learn .net so I guess I should be able to get DW as well. Can you get photoshop cs4 also?
Posted April 21, 2009
Download Eclipse then CFEclipse (both open source). I don't know if I would label them simple, but they will do the trick.
I get it but I'm still kinda new to the cfcomponent concept. I find php easier with classes.
I don't see how it would print your query out unless there's more code that you're not showing us. Anything within a cfquery shouldn't be displayed.
Posted April 12, 2009
I was able to fix my white dots problem. It seems like IE has a bug with transparency and colour 02050a. So I replaced that colour with black and it works.
Posted April 11, 2009
I'm looking for an image viewer. I've tried thickbox and lightbox they don't seem to be what I'm looking for. Lightbox is causing white dots to appear on my thumbnails in IE7, fine in Firefox. Thickbox resizes my images when they are too big and it screws up all the text in them. I removed the resize feature but then I can't scroll up and down.Any other option out there?
Posted April 2, 2009
Edited April 3, 2009 by vchris
I'm working on a cfcomponent application. I currently have 2 functions in my cfcomponent. My first function is getData which queries the DB and takes 2 arguments. My second function is buildTable which builds a table out of the query from getData. The problem I have is I get the error "Variable MYTABLE is undefined". myTable is created in my buildTable function.
<cfinvoke component="emissions" method="getData" returnvariable="myTable"><cfinvokeargument name="year" value="2007" /><cfinvokeargument name="location" value="BC" /></cfinvoke><cfdump var="#myTable#" />
EDIT:I got the problem resolved! Instead of my getData function calling buildTable I have buildTable calling getData and that seems to work
Posted March 25, 2009
I've been reading a couple of php login scripts. It seems like it's really easy to create security holes. I found this one (http://www.mtdev.com/2002/07/creating-a-se...hp-login-script) which seems pretty secure. I'm trying to implement it and it's pretty complex. I already have 2 classes in my application and it complicates things. I'm kinda new to classes as well. What kind of script do you use for secure login/session/cookies?
Posted March 17, 2009
That's nice! I already have 4-5 functions for the DB. One for connecting, disconnecting, querying (select), updating, deleting and escaping. What I was referring to is the query itself. The SELECT * FROM [table]. I've heard I should be keeping that outside of the php file and have all these queries in 1 file.EDIT: I just read the last line in your post. I see what you did but then where do you get the query?
SOLVEDThe issue was the session_start(); line. I removed it and it works fine. It was used on another version of my search.
I am working with php, mysql and the smarty template engine. Currently I have 1 template file and 1 php file. My queries are in the php page. I'd like to have all my queries in a separate query file. Basically 1 php file with all my queries for the whole site.I'm trying to understand how it would work. Some of those queries require user entered data to execute the query. Some queries require 3 variables, some require 1... Would I create a class or a function? A function for each of the queries?
How do you remove the form postback popup? If I do a search in a form I get to the results page. If I do a back and then a forward I get the form postback pop up. I've seen some websites that don't have that. How would I go about removing it?
Posted March 16, 2009
I'm trying to count the number of items in a given category or subcategory. MySQL
SELECT `cxs_cat_id`, `cxs_subcat_id`, `cat_name_e`, `subcat_name_e`, COUNT(item_id) AS `total_items`FROM `items`, `cat_x_subcat`, `categories`, `subcategories`WHERE `cxs_cat_id` = `cat_id` AND `cxs_subcat_id` = `subcat_id` AND `item_cxs_id` = `cxs_id`GROUP BY `cxs_cat_id`, `cxs_subcat_id`, `cat_name_e`, `subcat_name_e`ORDER BY `cat_name_e`
Output * General (1) o Electronics (1) * Vehicles (1) o Cars (1) o Trucks (1)I seem to only be getting 1 (in parenthesis) as the count. I have 3 items, 2 categories and 3 subcategories.