Linux, Apache, MySQL, PHP

1-Jun-09 3:50

I think the problem is you are trying to create the same row in the table twice.

Create an "id" field set to auto_increment as your primary key. Then you can pass it a NULL value.

Also, I'm not sure about your post code in the SQL. Try:

$password = $_POST['password'];
$userlevel = $_POST['userlevel'];

$sql="INSERT INTO users (id, password, userlevel)
VALUES
(NULL, '$password','$userlevel')";

Re: PHP Admin Control Panel

Java John10-Jun-09 0:22

Java John

10-Jun-09 0:22

Hi neex1223,

With regard to the second problem, you need to use the MySQL set command. Something along the lines of (not syntatically correct) where id = thisId, set password = new password.

I emphasise - that's not MySQL code, but it's the right structure.

Re: PHP Admin Control Panel

Syed M Hussain17-Jun-09 5:45

Syed M Hussain

17-Jun-09 5:45

UPDATE USERS SET USERNAME ='John', PASSWORD='newpass' WHERE ID= '1'

www.cy2online.net

how to prodece pop up alerts

nahelna28-May-09 9:54

nahelna

28-May-09 9:54

i am developing a help desk software using php and oracle, when an expert posts a solution to the user who asked it, an alert should pop up at the user's machine to alert them that a solution has been sent end then it should dissappear,i have already produced code to post the solution but i have no idea on how to go with the alerts, please help, thanx

Re: how to prodece pop up alerts

Marc Firth28-May-09 21:39

28-May-09 21:39

either use javascript & php and the web browser - or you'll have to get them to install something and use java/C# etc to interact with the desktop.

Or you could just send them an email. easier. more user (machine) friendly.

nahelna29-May-09 0:41

nahelna

29-May-09 0:41

am doing it for some company and one of the requirements is produce the alert(so i guess i just have to do it),
1.for the use of javascript, php and the web browser how do i do this?
2.for the use of java/c# you sed i will have to get them install something, which is?

thanx a lot for the reply

Marc Firth29-May-09 1:13

29-May-09 1:13

1.
- use php to store to the oracle db.
- use ajax (google "jquery") to display a pop up in the browser or

2.
Depends what you make.

If you make a java program then they will need to install it plus the java runtime (JRE).

If I was in your position I would build the pages & db for adding questions and responses with a boolean "answered" - default to "0".

And then use java to test ask the database at intervals for that user's questions if "answered = 1". if it returns any rows the display a popup for that item using the system tray (if this is for windows environment).

nahelna29-May-09 4:46

nahelna

29-May-09 4:46

thanx so much i will go for the java approach, let me try first and i will let u knw,, much thanx

Security Softwate interface

Java John10-Jun-09 0:30

Java John

10-Jun-09 0:30

"am doing it for some company and one of the requirements is produce the alert(so i guess i just have to do it),"

- Suggest the email. Lusers never know what they want if they come out with stupid like that. It's better than a popup box.

Click here for Javascript Alert info

Do you have much previous experience of web development? If not, I am available for hire...

WebMaster28-May-09 0:52

WebMaster

28-May-09 0:52

I want to design a security software of a small company. the company has 3 books which are:
Visitors book
Occurrence book
tools book
the guard will be able to input to visitors book visitors name, time in, time out and so on...
even in the occurrence book the guard should be able to input some thing.

I am having some difficulties in coming up with the interface of this software. especially in the visitors book (time out column). the manager of the company should be able to view those how visited and any thing else every day.the software will use an intranet. Please help...

Re: Security Softwate interface

Marc Firth28-May-09 1:50

28-May-09 1:50

php.net
(dynamic server side code - can store data using mysql and retrieve and render it etc)

w3schools.com
(learn web design)

google.com
(use this first before posting questions on here - if you can't find what you are looking for then ask away)

Or alternatively you can pay someone to do it for you.

Re: Security Softwate interface

cry197828-Apr-11 15:36

cry1978

28-Apr-11 15:36

I have an ebook protection website, users come to protect there ebooks by your website through a software, you can see how many users opened the book by IPs, also they can only open your ebook with a key that they buy from you, or from your clients that pay you a month to month fee to protect there ebooks too.

the website needs fixing, and so does the software that protects the ebooks?

So you can have a website design that has these features but you have to fix it, I will give you the copy if you want? I bought this the way it is, but it was a waste of money Sigh | :sigh:

If anyone can fix this for me, or help me out, please do, this would be a very great website to run if it can be fixed Rose | [Rose]

here is the problems wrong with it

help fixing phoenix piracy shield script

key fields that need fixing:

1. Admin and users can't login and users can't signup, users signup and it says successful, but I dont see users that signed up in myphpadmin but I see the admin details for signing up?

2. users don't get emails that they have signed up?

3. I get a run time error when opening the ebook software LockFileGeneratorSetup.exe this is what users download to protect there ebooks.

4. when I goto http://www.webotrain.com/myadmin/ and try to login it goes to this page

http://www.webotrain.com/myadmin/member_list.php

I get this error

Parse error: syntax error, unexpected ';' in /home/webotrai/public_html/myadmin/member_list.php on line 235

here is line 235

<?=//$cl_res[$i][hostname];?>

when I take out the // I am able to goto where admin can login but it does not login and keeps refreshing to the same page to login again but when I put in a wrong password it displays the correct error with wrong pass?

5. the installer script only goes to step 8, where I need to setup domain, database info, but I already did this step when they said to do that before doing the installer file? in the connectdb.php

the installer file did setup the sql file in the database, I see tables in phpmyadmin and my site is connecting to database ok, so I dont know why emails, admin login, user login and signups, and also the ebook software which protects users ebooks dont work and when click on to open that software gets a run time error?

I need to fix my Phoenix Piracy Shield Script on my webhost server. I did the installation as suggested, but it does not allow to login as administrator and users can't login but it says they have signed up, users also don't get emails when the have signed up?

when I open the

LockFileGeneratorSetup.exe

This is the downloaded file to protect my ebooks or products, I get a run time error message?

Application_1

run-time error '5':

invalid procedure call or argument

Attaching installation instructions file. At step 8, it prompts for

Host Name :
User Name :
Password :
Database Name :
Site Url :
Application Heading :

After entering correct information and Host Name as localhost, it refreshes the screen and prompts for information again. I am assuming it worked.

Than I am doing step 09. Login as Admin.

If I enter correct admin login and password it does not display any error message and remains on the same screen but it do not allow to enter into any admin area. But when I enter wrong password it displays error.

I only see where you need to fix the admin and user logins to where they need to login, and fix the main ebook software script that locks and protects the ebooks, it has a run time error message.

I have all the source codes...

this is a membership site for my members to get membership to protect there ebooks and products, they paid to protect there ebooks to have license keys for there products..

I would also like an addon too, this is not in the script, I want members who want to run this kind of website, have it to where they can run it through mine by have a reselling link, they can sell it for my cost and then increase there profit.

They can provide there members to protect there ebooks on there website but each of there members that they charge I get paid too, they get it for cost and have to increase the sell to make a profit? sort of like what drop shipping companies do.

setup insttructions given

Sub:
How to integrate the application with the site on new server ?

Steps:

1.Copy(upload) PhoenixPiracyShield.exe in /dw folder.

2.Copy(upload) index.php from this folder into the /setup folder

3. run the setup for site after following all instructions in the install instructions document!

While entering the data in setup
Application Heading :
Indicates the caption to be given to VB application.
Currently set as ‘Protected Products…’

After following above steps the application will be ready.

How the newly made changes will facilitate you?

You needn’t to change the PhoenixPiracyShield.exe file at all.
Before running the setup the PhoenixPiracyShield.exe won’t run.
We have made some changes that will change the application heading and website address you select while running setup.

and the install setup is here

To Install Phoenix Piracy Shield You Must Follow These Instructions Exactly Or It Will Not Work!

Step 1:

1. Pick which template you want to use either 1 or 2 and upload that folder and files to your webserver

Step 2: CHOMD The Following Files And Folders To 777

*dw
*dw/PhoenixPiracyShield.exe

*include
*include/connectdb.php

*myadmin/banners

Step 3: Now login to your webhosting service and create a database

Step 4: Create A Database User

Step 5: Create A Database Password

Step 6: Grant ALL PERMISSIONS for this database/user

Step 7: Goto include folder and set up include/connectdb.php with the proper database info. DB Username Pasword and database name. Database host will be needed too.

Step 8: (VERY IMPORTANT)
Run from your web browser http://www.yourdomain.com/setup/

Enter all the data required by the database installation process, you must fill all the requested fields and click on the “Create Database and Continue” Button after this process finish and you see the message confirming it you must follow the link that will guide you to the next configuration page.

Enter the requested details this will create the PhoenixPiracyShield.exe file which works in conjunction with your website and database

Step 09: login to your admin area at: http://www.yoursite.com/myadmin/
default username: admin
password: admin
If you enter a new one on the database creation process you must enter those.

step 10: In the folder includes there is a file called PicSql.inc.php you need to modify that to reflect your site name

To edit the sales page simply edit salesletter.html or salesletter.htm

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx OTHER TALK SIMPLE AND NOT TO HARD HERE

I need help installing a website

setup insttructions given

Sub:
How to integrate the application with the site on new server ?

Steps:

1.Copy(upload) PhoenixPiracyShield.exe in /dw folder.

2.Copy(upload) index.php from this folder into the /setup folder

3. run the setup for site after following all instructions in the install instructions document!

While entering the data in setup
Application Heading :
Indicates the caption to be given to VB application.
Currently set as ‘Protected Products…’

After following above steps the application will be ready.

How the newly made changes will facilitate you?

You needn’t to change the PhoenixPiracyShield.exe file at all.
Before running the setup the PhoenixPiracyShield.exe won’t run.
We have made some changes that will change the application heading and website address you select while running setup.

and the install setup is here

To Install Phoenix Piracy Shield You Must Follow These Instructions Exactly Or It Will Not Work!

Step 1:

1. Pick which template you want to use either 1 or 2 and upload that folder and files to your webserver

Step 2: CHOMD The Following Files And Folders To 777

*dw
*dw/PhoenixPiracyShield.exe

*include
*include/connectdb.php

*myadmin/banners

Step 3: Now login to your webhosting service and create a database

Step 4: Create A Database User

Step 5: Create A Database Password

Step 6: Grant ALL PERMISSIONS for this database/user

Step 7: Goto include folder and set up include/connectdb.php with the proper database info. DB Username Pasword and database name. Database host will be needed too.

Step 8: (VERY IMPORTANT)
Run from your web browser http://www.yourdomain.com/setup/

Enter all the data required by the database installation process, you must fill all the requested fields and click on the “Create Database and Continue” Button after this process finish and you see the message confirming it you must follow the link that will guide you to the next configuration page.

Enter the requested details this will create the PhoenixPiracyShield.exe file which works in conjunction with your website and database

Step 09: login to your admin area at: http://www.yoursite.com/myadmin/
default username: admin
password: admin
If you enter a new one on the database creation process you must enter those.

step 10: In the folder includes there is a file called PicSql.inc.php you need to modify that to reflect your site name

To edit the sales page simply edit salesletter.html or salesletter.htm

step10 PicSql.inc.php fields to edit are

var $siteinitial="protectmyebook.com/ebooklocker/";
var $siteinitialcap="protectmyebook.com/ebooklocker/";
var $siteurl="www.protectmyebook.com/ebooklocker/";
var $siteurlnowww="protectmyebook.com/ebooklocker/";
// the constructor
function PicSQL($DBName = "")

what is pcsql? what do I put for $DBName = ""

Advice needed

jharker198727-May-09 13:20

jharker1987

27-May-09 13:20

Hi,

I need some general advice. I've developed a simple application in c# that generates various statistics. What i want to do now is feed that information to my web server (php, mysql) do display that data in a simple, graphical way.

I've had a look on google and theres lots of talk about SOAP, XML, web services etc, but no clear cut tutorial on how to do what I want (that ive been able to find)

can you point me in the right direction?

Jonathan Harker

Marc Firth27-May-09 22:00

27-May-09 22:00

how/where is the data stored in the first place? if it isn't then I suggest storing it using c# to the mysql database. then you can retrieve it from the db using php webpages.

jharker198728-May-09 0:34

jharker1987

28-May-09 0:34

its just stored in RAM at the moment. i have a mysql database on the server, so should i use the MYSQL connector to connect to it and send the data that way?

Jonathan Harker

Marc Firth28-May-09 1:45

28-May-09 1:45

yes

large file uploading problem

Blue36528-May-09 1:24

Blue365

28-May-09 1:24

MySQL connector is definately the way forward.

Bluetooth Marketing

Bluetooth Advertising

Bluetooth marketing blog

khushi171026-May-09 0:10

khushi1710

26-May-09 0:10

hi,
I am uploading file and encoded it with ffmpeg and saving three encoded files(flv, mpg, mov) on Red5 server. All the things are going well for videos less than 13MB. but when i am going to upload large files, got an error on mozilla of connection lost. Even i have increased post_max_size=1024M ,execution time=1000000 and upload_max_filesize=1024M.....

Regards
Khushboo

Re: large file uploading problem

Marc Firth26-May-09 21:59

26-May-09 21:59

If I remember rightly 1024M != 1024MB. 102400 = 10MB. I'll let you do the math. if that doesnt work I know I got it working with swfupload.