Database Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers Forums > Other Technologies > Database Help
Reload this Page

SQL/PHP integration NOOB QUESTION

Discuss SQL/PHP integration NOOB QUESTION in the Database Help forum on Codewalkers.
SQL/PHP integration NOOB QUESTION General SQL help. Help with MySQL, MSSQL, Oracle, mSQL, PostgreSQL, etc.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
Dell PowerEdge Servers
  #1  
Old December 30th, 2007, 10:46 AM
WiscoLinks WiscoLinks is offline
Registered User
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Dec 2007
Posts: 18 WiscoLinks User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 h 27 m 20 sec
Reputation Power: 0
SQL/PHP integration NOOB QUESTION
so I now know SQL database manipulation code, and I know PHP.

how do i establish connection to a SQL database from a PHP script, so i can manipulate the database from the PHP page/script?

surprisingly could not find on W3. but maybe i missed something.

thanks in advance
Reply With Quote
  #2  
Old December 30th, 2007, 11:46 AM
tkarkkainen's Avatar
tkarkkainen tkarkkainen is offline
Moderator
Click here for more information
 
Join Date: Apr 2007
Location: Finland
Posts: 2,310 tkarkkainen User rank is Lance Corporal (50 - 100 Reputation Level)tkarkkainen User rank is Lance Corporal (50 - 100 Reputation Level)tkarkkainen User rank is Lance Corporal (50 - 100 Reputation Level)  Folding Points: 7832 Folding Title: Novice Folder
Time spent in forums: 6 Days 4 h 58 m 15 sec
Reputation Power: 4
mysql_connect(), mysql_select_db(), mysql_query(), mysql_fetch_array(), mysql_num_rows(). Those should get you started. See the manual for details.

And I'm sure there's a lot of info on the subject in the WWW. There should be a basic database tutorial here at Codewalkers, too.
__________________
Fight Internet censorship!

Code:
()  ascii ribbon campaign - against html e-mail 
/\  www.asciiribbon.org   - against proprietary attachments
Reply With Quote
  #3  
Old January 3rd, 2008, 12:04 PM
WiscoLinks WiscoLinks is offline
Registered User
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Dec 2007
Posts: 18 WiscoLinks User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 h 27 m 20 sec
Reputation Power: 0
AH, looking at PHP manual mysql_query allows usage of SQL code. such as insert and select statements; is this correct?
Last edited by WiscoLinks : January 3rd, 2008 at 12:16 PM.
Reply With Quote
  #4  
Old January 3rd, 2008, 01:22 PM
icandothat's Avatar
icandothat icandothat is offline
Moderator
Click here for more information.
  
Join Date: Apr 2007
Location: San Diego, CA
Posts: 1,526 icandothat User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 23 h 14 m 36 sec
Reputation Power: 3
That is correct.
__________________
There is no spoon.
Reply With Quote
  #5  
Old January 6th, 2008, 09:36 PM
WiscoLinks WiscoLinks is offline
Registered User
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Dec 2007
Posts: 18 WiscoLinks User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 h 27 m 20 sec
Reputation Power: 0
if that is correct, then what is wrong with this SQL code used in the PHP function mysql_query:
PHP Code:
 mysql_query("INSERT INTO Members 
VALUES (".$username.",".$password.",".$nickname.","
.$emailusername.",".$emailpassword.","
.$facebookusername.",".$facebookpassword.","
.$zipcode.",".")"); 

the mysql_error returned by the false value of this query was
PHP Code:
 Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@www.com,lol,43523,)' at line 2 


I changed the comma at the end but that wasn't it; there is something else. I get the same exact error after removing the errant comma at the end of teh string concatenation for the query parameter
Last edited by WiscoLinks : January 6th, 2008 at 09:41 PM. Reason: troubleshooting update
Reply With Quote
  #6  
Old January 7th, 2008, 01:40 AM
tkarkkainen's Avatar
tkarkkainen tkarkkainen is offline
Moderator
Click here for more information
 
Join Date: Apr 2007
Location: Finland
Posts: 2,310 tkarkkainen User rank is Lance Corporal (50 - 100 Reputation Level)tkarkkainen User rank is Lance Corporal (50 - 100 Reputation Level)tkarkkainen User rank is Lance Corporal (50 - 100 Reputation Level)  Folding Points: 7832 Folding Title: Novice Folder
Time spent in forums: 6 Days 4 h 58 m 15 sec
Reputation Power: 4
Try adding single quote marks around the values:

PHP Code:
 mysql_query("INSERT INTO Members  
VALUES ('".$username."','".$password."','".$nickname."','" 
.$emailusername."','".$emailpassword."','" 
.$facebookusername."','".$facebookpassword."','" 
.$zipcode."')"); 


Or, with simplified syntax:

PHP Code:
 mysql_query("INSERT INTO Members  VALUES ('$username', '$password', '$nickname', '$emailusername', '$emailpassword', '$facebookusername', '$facebookpassword', '$zipcode')"); 
Reply With Quote
  #7  
Old January 7th, 2008, 11:09 AM
WiscoLinks WiscoLinks is offline
Registered User
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Dec 2007
Posts: 18 WiscoLinks User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 h 27 m 20 sec
Reputation Power: 0
tkark is my hero
the first solution worked, i needed those single quotes;
i kick myself
Quote:
Originally Posted by tkarkkainen
Try adding single quote marks around the values:

PHP Code:
 mysql_query("INSERT INTO Members  
VALUES ('".$username."','".$password."','".$nickname."','" 
.$emailusername."','".$emailpassword."','" 
.$facebookusername."','".$facebookpassword."','" 
.$zipcode."')"); 


Or, with simplified syntax:

PHP Code:
 mysql_query("INSERT INTO Members  VALUES ('$username', '$password', '$nickname', '$emailusername', '$emailpassword', '$facebookusername', '$facebookpassword', '$zipcode')"); 
Reply With Quote
  #8  
Old January 9th, 2008, 06:34 AM
lig's Avatar
lig lig is offline
"Forum Nazi"
Codewalkers Demi-God (4500 - 4999 posts)
  
Join Date: Apr 2007
Location: Jacksonville, Fl
Posts: 4,719 lig User rank is Private First Class (20 - 50 Reputation Level)lig User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 4 Days 4 m 29 sec
Reputation Power: 6
echo is a wonderful thing - sometimes just echoing out the SQL command that is being sent to the DB can help you pin point what may be wrong with it. Especially for a Syntax error - least in my opinion.
__________________
life is a game.... Have fun
-----------------------------
http://www.phpwomen.org
strength in unity

PHPCommunity IRC
#phpc on freenode
Reply With Quote
Reply

Viewing: Codewalkers Forums > Other Technologies > Database Help > SQL/PHP integration NOOB QUESTION

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

 Free IT White Papers!
 
Accelerating Trading Partner Performance
One in five. That's how many partner transactions have at least one error. That is an amazing statistic, particularly given the extraordinary leaps in innovation across the global supply chain during the past two decades. Download this white paper to learn more.
 
Competing on Analytics
This Tech Analysis is designed to help identify characteristics shared by analytics competitors, and includes information about 32 organizations that have made a commitment to quantitative, fact-based analysis.
 
Cost Effective Scaling with Virtualization and Coyote Point Systems
An overview of the industry trend toward virtualization, how server consolidation has increased the importance of application uptime and the steps being taken to integrate load balancing technology with virtualized servers.
 
Five Checkpoints to Implementing IP Telephony
Implementation planning for IP PBX software and IP telephony has become vital as businesses replace discontinued legacy PBX phone systems. This informative whitepaper outlines five "checkpoints" for any implementation plan that will help make IP communications a successful proposition.
 
Hosted Email Security: Staying Ahead of New Threats
In the last two years, email has become a fierce battleground between the nefarious forces of spam and malware, and the heroes of messaging protection. The spam volumes increased alarmingly every month, bringing clever new forms of phishing and virus propagation attacks.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway.