Posts
 
Reputation
Joined
Last Seen
Ranked #3K
Strength to Increase Rep
+4
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
2
Posts with Upvotes
1
Upvoting Members
2
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
2 Commented Posts
~20.7K People Reached
Favorite Tags
Member Avatar for jrotunda85

I have created a table in a mySQL DB where users are going to a form and entering ratings on 6 Categories (5 Specific and 1 Overall) for a particular item_id. On the item table, I have a column that calculates the total number of ratings this particular item_id has …

Member Avatar for Vishwajeet_2
0
3K
Member Avatar for jrotunda85

I'm not sure if this should be in this forum but I figured it was a good starting place. I am creating a database that, among other things, allows users to input a store's location (e.g. name, address, etc). Once a store has been added, there is an ability to …

Member Avatar for Yong woon
0
573
Member Avatar for jrotunda85

So I'm getting this error message from MYSQL when I load this page. The first message is what's it displaying on the PHP code, the 2nd message is the result of mysql_error(). [ICODE](1) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [I][redacted][/I] on line 19 (2) You …

Member Avatar for Gears.of.Codes
0
365
Member Avatar for jrotunda85

I am trying to secure a folder within my site by forcing an HTTPS connection when anything in this folder is run (the folder contains a series of scripts that process registrations, password resets, etc). What's the easiest way to accomplish this?

Member Avatar for pixelsoul
0
179
Member Avatar for jrotunda85

I have a javascript login box on my site ([url]www.cigardig.com[/url]) that a user can click on and login on any page. The way I would like it to work is that once a user hits submit, they are redirected back to the page they logged in on. So, for example, …

Member Avatar for bakhtn
0
2K
Member Avatar for jrotunda85

I'm trying to figure out the best way to accomplish the computation of weighted averages for my site. Here's the PHP that pulls down the results -- [CODE]$SQL = "SELECT a.*, b.CName, c.Description FROM humidor a LEFT JOIN cigar b on a.CigarID = b.CigarID LEFT JOIN cd_manufacturer c on b.Manufacturer …

Member Avatar for jrotunda85
0
114
Member Avatar for mgt

I'm trying to create a simple members only section. With the following code, I'm able to log in and get redirected to a page (that simply says: "hello") if the login is correct. If I then copy the URL from the page to which I was redirected, open up IE, …

Member Avatar for Stefano Mtangoo
0
555
Member Avatar for feedz87

Hi, I have a site with a login form for users and administrators to enter their details. Anyone can show me simple code how to separate between admin login and user login because i'm new in php.I uses PHP object oriented.Anyone can show me simple tutorial and easy to understand …

Member Avatar for mgt
0
2K
Member Avatar for jrotunda85

I am trying to figure out the best way to figure out "age" of a particular item. I currently have fields in a mySQL databases that are stored as datetime formats and I need to display (in PHP) the relative age of those dates in terms of years, months, and …

Member Avatar for karthik_ppts
0
150
Member Avatar for jrotunda85

So I am in the process of putting some finishing touches on a new section of my website which allows users to keep track of their cigars in an online inventory (or humidor) type system. I'm kind of stuck; however, on what the best way to capture and process data …

Member Avatar for vibhaJ
0
154
Member Avatar for geekme

Is it necessary to install mysql workbench in order to run database based php web apps?

Member Avatar for jrotunda85
0
101
Member Avatar for jrotunda85

I'm trying to figure out the best way to replace apostrophes in various user input which is all formatted first using [B]mysql_real_escape_string[/B]. Of course this replacement should take place after all input has been sanitized and anything funny removed. :) Any help would be awesome!

Member Avatar for jrotunda85
0
247
Member Avatar for jrotunda85

For my new code that I'm developing, I have a text box where a user will type in a date as follows: [B]MM/DD/YYYY (e.g. 05/19/2011)[/B] This date then needs to be converted and inserted into a date/time field on a mySQL database. I've been trying to play around with this …

Member Avatar for divyakrishnan
0
877
Member Avatar for pantera989

Hi, I need help with PHP/javascript/mysql I am fairly new to this so excuse me for my bad programming skills. I have PHP page which has to update mysql table and HTML table onclick. It updates HTML table ok but as soon as I refresh page it updates all data …

Member Avatar for vibhaJ
0
1K
Member Avatar for jrotunda85

I am in the process of trying to customize my site's URLs and I'm running into an issue with my htaccess file, specifically the newest one I am trying to add. Here's the file -- [CODE]RewriteEngine On RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.*)$ $1.php [L,QSA] RewriteRule ^/retail/(.*)$ retail.php?id=$1[/CODE] …

0
139
Member Avatar for jrotunda85

Any chance the wonderful people here on daniweb could help me again with a loop? My apologies, loops are not my thing :| Basically what I'm trying to do is add a condition where on the last tweet (that is where the loop = $nooftweets), that tweet gets a different …

Member Avatar for jrotunda85
0
110
Member Avatar for jrotunda85

So I'm trying to create one central file for my navigation which is used across my site; however, some of the pages are in different directories. So, for example , let's say I have the following directories -- domain.com/ domain.com/dir1/ domain.com/dir2/ If I wanted to use the same include between …

Member Avatar for jrotunda85
0
123
Member Avatar for jrotunda85

I've been having a reoccurring issue with my VPS since I moved to a new company and I'm trying to figure out what the issue is. There are a few different things going on (I believe they are all connected) -- [LIST=1] [*]When you visit a page that doesn't exist, …

Member Avatar for jrotunda85
0
281
Member Avatar for jrotunda85

So I'm trying to figure out the best way (if possible) to combine these two stored procedures. Basically these are the same, the only difference is one is looking at a 'Spot' table, the other is looking at the 'Retail' table. However, in both cases the column count is the …

0
96
Member Avatar for jrotunda85

So I've developed some code to pull the latest 8 images from my flickr feed; however, I'm having trouble with figuring out how to do what I'm trying to do. Essentially, I need each 4th image to have a different <div> class (this helps with margins and what not). Any …

Member Avatar for jrotunda85
0
144
Member Avatar for jrotunda85

I am having a problem with the Google Maps API because of conflicting names in my site's CSS. From what I've been able to find, Google Maps uses the name "container" in their code as does my site, so when the map loads it has this nasty white shadow behind …

Member Avatar for jrotunda85
0
210
Member Avatar for jrotunda85

I’ve created a dynamic page ([I]page.php[/I]) who’s content changes based on the incoming link, specifically by calling a GET on the ID in the URL. So, for example, someone visits [I][url]www.domain.com/page.php?id=310[/url][/I] and the content on the page changes queries the database and returns results for item 310. I’m in the …

Member Avatar for matricol
0
134
Member Avatar for jrotunda85

I recently moved a script I created for Google Maps over from my development site and I changed the information in the mysqli line and now I'm recieving an error mesage -- any idea what's going on here? Here's the error message: [CODE]Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user …

Member Avatar for diafol
0
366
Member Avatar for PinoyDev

Good day! I just to ask why require_once function display the content of the whole page in the second page? I have two pages index.php and mem_accnt.php. I have session in index.php. Now i need to get the session in index.php and display it in mem_accnt.php. In order to get …

Member Avatar for PinoyDev
0
178
Member Avatar for jrotunda85

I want to add something to the script below that, prior to insert, check to see if the $CigarID already exists for the $UserID. If so, I want it to do an update and increase the $Quantity by whatever the user inputs. If the value doesn't exist, then insert the …

Member Avatar for jrotunda85
0
123
Member Avatar for jrotunda85

Let's say I have the majority of my site in the 'root' WWW directory on the server, such as: [url]www.domain.com/index.php[/url] My current header & footer files are set to respect this configuration and work beautifully. I am now in the process however of creating a new directory which will be …

Member Avatar for almostbob
0
470
Member Avatar for jrotunda85

So I'm trying to figure out the best way to go about setting up an image upload system for my site. Basically we have, let's say, 2,000 stores in our database currently (that number expands by the day). I want users to be able to upload images for each store …

Member Avatar for diafol
0
134
Member Avatar for jrotunda85

So this may be a bit of a stupid question but I'm not sure I'm understanding this completely. Currently, my site uses sessions to store username and a UserID across the site; however, the session lacks the ability to remember a user should they close the browser. I want to …

Member Avatar for Wraithmanilian
0
111
Member Avatar for jrotunda85

I am trying to write a script for my site that will check if a user has submitted a review for a particular cigar in the past [B]30 days[/B] and if they have, prevent them from creating a new review. I am trying to figure out the code but I'm …

Member Avatar for mschroeder
0
155
Member Avatar for jrotunda85

I keep getting the following error whenever I try to run this query on my "spot" table: [CODE]#1054 - Unknown column 'a.Longitude' in 'field list'[/CODE] The weird thing is though that the column DOES in fact exist, is spelled the same way, and has thousands of rows of data. Even …

Member Avatar for jrotunda85
0
112