Lienne
-
Posts
11 -
Joined
-
Last visited
Never
Posts posted by Lienne
-
-
I am currently working on a site which has its visitors purchase access to a series of videos. I don't want to handle the payment processing any more than I have to (mostly because I'm scared...lol) and I can't seem to find a storefront which has this sort of thing built in.
The way that I'm seeing this, the user would select the product on my site, and then be redirected to a store page, which will handle the payment processing. The result of a successful payment would then be a change in my DB to reflect the user's new purchase.
Does that sound like a good way to go about it, and how can I do this? I have no idea even where to begin on this, so ANY sort of guidance, however small, would be immensely helpful.
-
-
<removed>
-
I've been working on this script for a few days that's driving me crazy. I finally made some good breakthrough, and discovered another odd problem. I'm trying to read all of the rows in my DB and return the mssql_num_rows. For some reason, however, it will only return 999 of them. Is this normal or did I just do something stupid? ???
-
Oh man, I figured it out. I hadn't noticed it earlier. So thank you, your telling me to echo the sql statement actually helped a lot. The house number was the same on both rows, and it's reproducing the problem now.
-
I tried echoing the SQL statement, and it looks fine. For some reason though, the database still has some problems. For instance, there are two row 8 and no row 7. But the output looks like:
[code]6: UPDATE contacts_temp SET counter=6 WHERE deleted='1' AND id='' AND street_name='ALABAMA' AND prefix_directional=' ' AND street_suffix=' ' AND post_directional=' ' AND house_number='2105'
7: UPDATE contacts_temp SET counter=7 WHERE deleted='1' AND id='' AND street_name='ALABAMA' AND prefix_directional=' ' AND street_suffix=' ' AND post_directional=' ' AND house_number='2109'
8: UPDATE contacts_temp SET counter=8 WHERE deleted='1' AND id='' AND street_name='ALABAMA' AND prefix_directional=' ' AND street_suffix=' ' AND post_directional=' ' AND house_number='2109'[/code]
-
Hi all,
So I'm getting some strange results from one of my scripts. I have an MSSQL DB which has a list of peoples' addresses. I need to do some other processing to the data, so I decided to assign each person a "counter" (basic ID). In comes the troubling script. Bascially, the script iterates through every row in the DB and assigns it a number one higher than the last row. Very simple. But for some reason, it's not working exactly properly. The echo that I put in the script shows everything working perfectly fine. But for some reason, in the DB itself sometimes the numbers are not correct. For instance, one time through it looked like this:
1
2
3
351
5
...
And the crazy thing is that there was no 4. Nowhere. Another time, there were 2 4's. This problem seems to be randomly scattered throughout the rows with various incorrect numbers.
So does anyone know why there would be an inconsistency between the echo output and what is actually put in the DB? I'm quite stumped on this one....help!
[code]<?
include("includes/db.inc.php");
$counter = 0; //init counter
$master_results = mssql_query("SELECT * FROM contacts_temp WHERE deleted='1' AND id=''"); //get resident results
$master_numrows = mssql_num_rows($master_results);
for ($i=0; $i<$master_numrows; $i++) {
$master_row = mssql_fetch_array($master_results);
$street_name = $master_row['street_name'];
$prefix_directional = $master_row['prefix_directional'];
$street_suffix = $master_row['street_suffix'];
$post_directional = $master_row['post_directional'];
$house_number = $master_row['house_number'];
$master_results2 = mssql_query("UPDATE contacts_temp SET counter=$counter WHERE deleted='1' AND id='' AND street_name='$street_name' AND prefix_directional='$prefix_directional' AND street_suffix='$street_suffix' AND post_directional='$post_directional' AND house_number='$house_number'");
echo $counter . "<br>";
$counter++;
}
?>[/code] -
ooh, ingenius. so Instead of using a positive number to move to the right, we us a negative to move to the left (which is the end). Great! Thank you very much!
-
Like the topic says, I have a string of variable lengths, and I want to find out what the last two characters are. Thanks in advance!
-
If I access the scripts through localhost everything works fine, but if I try to run them through the IP (even on the machine the server is installed on) I get it asking me for a username/password/domain and if I click cancel, it tells me I don't have proper priveledges to access that file. It seems to be only happening for php scripts, too.
I first tried installing PHP manually, and that worked ok. I then switched to the installer (cgi).
Any assistance would be ENORMOUSLY appreciated!
[Contract] Seeking dev of (almost) any level for S-T project, L-T relationship
in Archived Job Offerings
Posted
Hello,
The Sentelia Group, LLC is a new firm out of the San Francisco Bay Area. We specialize in helping small businesses get off the ground and onto the Web. We are currently seeking one, or a few, PHP developers to help us get a few projects off the ground. I have ~10 years' experience coding and intend to be very involved in the creation of the sites. We usually hire students who are interested in getting into the Web development field, and assist them while working toward our end goal. All projects with Sentelia are paid.
About this project: We are working to create a very basic eLearning site on which customers purchase access to specific classes. They then watch a series of videos (from YouTube; no it's not a loophole!) and then take a quiz to receive their certification. If they pass, we will generate a PDF file with a custom ID. The site DB is already architected, though we are open to suggestions.
Here is a list of the major features we will need:
* A user login system, and a way to purchase and track the classes (I will help with this part)
* The videos themselves with some associated content on each video's page.
* The quiz creation process (retrieving random questions and answers based on which class the user is taking)
* The certificate generation process
* two or three feedback forms (mailto) with some basic error checking
You will NOT need to do any sort of graphic work for this project. The graphics have already been created, as we have individuals working on that separately. You will be expected to integrate the sliced images for the template and the code, however. No CSS; we rock it old school, using tables. Yes, I said it, we use tables because they're better. At least until CSS3 comes out.
So to wrap up, this is a short-term Web development deal in which you will have access to me periodically to give feedback and guidance. This project is perfect for a student or someone who doesn't have an extensive portfolio. We have a number of projects on the horizon as well that we will be needing assistance on, so the opportunity to work together further is a very real possibility. And dare I say it, if things go well over the next year we may be looking at a full-time employment opportunity as well. But for now, just contracts.
Compensation for this project will be $1,173.00 USD, payable in two installments; about halfway through, and upon final delivery. Also, you have to be able to legally work in the US. Also, there is a $200.00 USD bonus available if all milestones and deadlines are met satisfactorily. This is not part of the salary since it is not guaranteed. It's just a little "incentive" to keep to the schedule!
If you are interested in this project or in being considered for future projects, please send a PDF resume along with whatever you have by way of a portfolio (not necessary,) and a little about yourself and what you hope to gain from working with Sentelia to: akelley at sentelia dot com and we'll get in touch.
Thanks, and happy coding!
Aaron Kelley