Need some help stopping multiple signups.. php/mssql


HOME ยป Databases

It's been a couple years now since I've worked on website on a daily basic.. I thought you could never really forget how to program, but I am running a small project now and I am moreless confused on how to fix an issue..
I have a simple signup page requesting a username, password, password2 and email. I currently check only to see if the username exists and show an error if it does.
What I need to do is to also added new hidden fields for IP, calling $_SERVER['REMOTE_ADDR'] which I can do. I basically need a way to check to make sure accounts can not be made from the same user. I know people can change their IP with software and still, in some cases the ip can be dynam

Related to : Need some help stopping multiple signups.. php/mssql
MSSQL with Multiple Key
Databases

Hello All
Its me again, I don`t know if I can explain this right but how can I do this in MSSQL.
Example I have this Employee Log Table with the following columns.
ID Name Log Count
1 Mark 1
2 Adrew 1
3 Mark 2
Now when I will insert again the Name Mark with Log Count 1 database should not allow because it will be duplicate.
Please help me.
Thanks in advance.
RedHat 5.5 PHP Version 5.2.10 can't load php-mssql and php-p
Databases
php -v gives:
PHP Warning: PHP Startup: mssql: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
PHP Warning: PHP Startup: pdo_dblib: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
PHP 5.2.10 (cli) (built: Aug 10 2009 05:20:34)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend T
Need some help stopping multiple signups.. php/mssql
Databases
It's been a couple years now since I've worked on website on a daily basic.. I thought you could never really forget how to program, but I am running a small project now and I am moreless confused on how to fix an issue..
I have a simple signup page requesting a username, password, password2 and email. I currently check only to see if the username exists and show an error if it does.
What I need to do is to also added new hidden fields for IP, calling $_SERVER['REMOTE_ADDR'] which I can do. I basically need a way to check to make sure accounts can not be made from the same user. I know people can change their IP with software and still, in some cases the ip can be dynam
MSSQL: JOIN multiple tables
Databases

I having 3 tables:

This table is used to store customer's infos

Customers
ID          Name
1           'Company A'
2           'Company B'
3           'Company C'

This table save the order log

Orders
ID          CustomerID         Quantity      Date
1           1                  200           01/01/2001
2           1                  150           01/02/2001
3           2                  500           01/02/2001
4           3                  200           01/03/2001
5           2                  400           01/03/2001
6           3                  200           01/04/2001

This table to save the price, let's assume that I sell only 1 product, and each Customer have a seperate price for their own and the total quantity like this

example: for customer ID 1, the total quantity between FROM 0 TO 100 THEN the PRICE for each one is 200

Price
CustomerID           From           To          Price
1                    0              100         200
1                    101            500         190
1                    501            ?           180
2                    0              150         195
2                    151            800         180
2                    801            ?           170
3                    0              400         180
3                    401            ?           180

I want my output look like this:

Name          TotalQuantity            Price
Company A     350                      190
Company B     900                      170
Company C     400                      180

I know that I need to SUM the Quantity first then compare with Price table below but how can I do that? and what should I put in "?" erm... for example more than 501, 801, 401 in that Price table?


(PHP) How to zip multiple files stored in VARBINARY (mssql)?
Databases

How to zip multiple files stored in VARBINARY and allow the user to download on-the-fly?

I've tried ZipArchive::addFile() however the first parameter it is a real "filename" :(


how to remove php "--without-mssql" "--without-pdo-mssql" parameters?
Databases

i want connect to mssql server with php. i have installed "Microsoft Drivers for PHP for SQL Server" and added some lines in extension part of php.ini. but in phpinfo there wasn't any mssql info. only "--without-mssql" "--without-pdo-mssql" parameters in Configure Command.



Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .