Welcome to Hosting

The Mysql Database Hosting Page

Welcome to our site where we have collected recent news and resources for Mysql Database Hosting.

Latest Mysql Database Hosting News

Mysql Database Hosting

- The Planet, the global leader in IT hosting, today announced the addition of the popular Red Hat Enterprise Linux operating system to its Planet Northstar Managed Hosting line of business. Customers with Linux, Microsoft or blended environments can ...

The Planet Adds Red Hat Enterprise Linux to Managed Hosting Platform - PR Inside

Remember Trip Chowdhry, the analyst with Global Equities Research? He's the guy who said that Red Hat is rubbish, and that the entire LAMP stack is potty, too . He said this a year ago, and Red Hat has delivered three solid quarters of growth and ...

The Open Road - CNET News

Meebo for Google Android is not a terrible instant-messaging application. But it isn't a very good representation of what IM clients for the Android platform can do, or even a good representation of what Meebo itself can do. In this first release ...

Read all '"Android apps"' posts in Webware - CNET News

November 11, 2008 -- (WEB HOST INDUSTRY REVIEW) -- Dedicated managed hosting provider The Planet ( www.theplanet.com ) announced on Tuesday it has added the Red Hat Enterprise Linux operating system to its Planet Northstar Managed Hosting line of ...

The Planet Adds Linux to Northstar - WHIR

SANTA CLARA, Calif. - (Business Wire) Sun Microsystems, Inc. (NASDAQ:JAVA) today announced the immediate availability and support of the Sun GlassFish(TM) Enterprise Server version 3 Prelude, a lightweight Web application server that is based on a ...

Sun Introduces GlassFish(TM) Enterprise Server V3 Prelude; Offers ... - Earthtimes

The Express Group and Sun Microsystems held an event revolving around e-Governance in Bangalore. BL Sridhar, Principal Secretary, e-Governance, Govt. of Karnataka was the Chief Guest and he spoke about the various initiatives taken up by the ...

Governance @ IT - Express Computer India

The division between proprietary software vendors and open-source providers is not as clear as some industry players perceive it to be. As more enterprises consider adopting open source technologies, even traditional software vendors such as ...

Microsoft 'Not Against' Open Source - PC World

Alentus Corporation (Pink Sheets:ALNS), a leading provider of Web Solutions including SharePoint Services, web hosting and Microsoft Exchange hosting, today announced that Company CEO William King will present a strategic investment overview at the ...

Alentus to Present at FSX Investment Conference: CEO William King to ... - Forbes

SYRACUSE, N.Y., Oct. 2 /PRNewswire/ -- Many MySQL(R) DBAs are frustrated by their inability to account for high server usage. The engineers at Software Workshop had similar feelings when trying to find 'usage hogs' among web hosting clients. Current ...

New MySQL Distribution: ExtSQL Provides Usage Accounting - PR Newswire

Host Color (http://www.hostcolor.com), a global provider of quality web hosting services announced today that it added community software "Simple Machines Forum" (SMF) to its web hosting plans. SMF is now a part of the company's PowerTools software ...

Open Question: New to php and sql. Want to store a value in a session, how do I do that?

This is a check login info page, and I have it so it checks the login info and creates a session, but I can only add the variables from the login to the session...how do I add other info from the specific record to the session? I have this so far: <?php $host="localhost"; // Host name $username="username"; // Mysql username $password="password"; // Mysql password $db_name="db"; // Database name $tbl_name="tablename"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; $status=2; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE email='$myusername' and password='$mypassword' and status='$status'"; $result=mysql_query($sql); $count=mysql_num_rows($result); if($count==1){ $row=mysql_fetch_array($result); $_SESSION['lname']=$row['lname']; $_SESSION['myusername']=$row['myuserna... header("location:login_success.php"); } else { echo "Wrong Username or Password"; } ?> In this row "$_SESSION['lname']=$row['lname'];" I am trying to pull the users last name from the db, not from the submitted form, but it doesnt work at all, because its not part of the session yet?....any ideas?? more

Resolved Question: I need help with PHP Login script?

Okay I have the script working I have the database working and everything to do with it All I WANT NOW IS HOW DO I RESTRICT ACCESS TO NON-MEMBERS. I've seen something some where that says something like $user='true' yeah don't know how that works but I have these scripts so far Connect.php (this works great) <?php // MySQL connect information. $c_username = "xth_********"; $c_password = "******"; $c_host = "sql***.xtreemhost.com"; $c_database = "xth_********_login"; // Connect. $connection = mysql_connect($c_host, $c_username, $c_password) or die ("It seems this site's database isn't responding."); mysql_select_db($c_database) or die ("It seems this site's database isn't responding."); ?> Register.php <?php // Check if he wants to register: if (!empty($_POST[username])) { // Check if passwords match. if ($_POST[password] != $_POST[password2]) exit("Error - Passwords don't match. Please go back and try again."); // Assign some variables. $date = mktime("d - m - Y"); $ip = $_SERVER[REMOTE_ADDR]; require_once("connect.php"); // Register him. $query = mysql_query("INSERT INTO members (username, firstname, lastname, password, date, ip) VALUES('$_POST[username]','$_POST[firstname]','$_POST[lastname]','$_POST[password]','$date','$ip')") or die ("Error - Couldn't register user."); echo "Welcome $_POST[username]! You've been successfully reigstered!<br /><br /> exit(); } ?> <html> <head> <title>Register</title> </head> <body> <form action="register.php" method="post"> <table width="75%" border="1" align="center" cellpadding="3" cellspacing="1"> <tr> <td width="100%"><h3>Registration</h3></td> </tr> <tr> <td width="100%"><label>Desired Username: <input type="text" name="username" size="25" value="<? echo $_POST[username]; ?>"></label></td> </tr> <tr> <td width="100%"><label>First Name: <input type="text" name="firstname" size="25" value="<? echo $_POST[firstname]; ?>"></label></td> </tr> <tr> <td width="100%"><label>Last Name: <input type="text" name="lastname" size="25" value="<? echo $_POST[lastname]; ?>"></label></td> </tr> <tr> <td width="100%"><label>Password: <input type="password" name="password" size="25" value="<? echo $_POST[password]; ?>"></label></td> </tr> <tr> <td width="100%"><label>Verify Password: <input type="password" name="password2" size="25" value=""></label></td> </tr> <tr> <td width="100%"><input type="submit" value="Register!"></td> </tr> </table> </form> </body> </html> Members.php <?php session_start(); require_once("connect.php"); // Check his status. if (!empty($_SESSION[username])) // he got it. { echo "You are currently logged in, <b>$_SESSION[username]</b>."; } else // bad info. { echo "You are currently <b>NOT</b> logged in."; } ?> Login.php <?php session_start(); // Check if he wants to login: if (!empty($_POST[username])) { require_once("connect.php"); // Check if he has the right info. $query = mysql_query("SELECT * FROM members WHERE username = '$_POST[username]' AND password = '$_POST[password]'") or die ("Error - Couldn't login user."); $row = mysql_fetch_array($query) or die ("Error - Couldn't login user."); if (!empty($row[username])) // he got it. { $_SESSION[username] = $row[username]; echo "Welcome $_POST[username]! You've been successfully logged in."; exit(); } else // bad info. { echo "Error - Couldn't login user.<br /><br /> Please try again."; exit(); } } ?> <form action="login.php" method="post"> <table width="75%" border="1" align="center" cellpadding="3" cellspacing="1"> <tr> <td width="100%"><h3>Login</h3></td> </tr> <tr> <td width="100%"><label>Username: <input type="text" name="username" size="25" value="<? echo $_POST[username]; ?>"></label></td> </tr> <tr> <td width="100%"><label>Password: <input type="password" name="password" size="25" value=""></label></td> </tr> <tr> <td width="100%"><input type="submit" value="Login!"></td> </tr> </table> </form> </body> </html> Okay if you see anything that I could change tell me and if this was kind of useless info then just tell me is there just a simple variable that I can put in or whatever just please help me more

Voting Question: New to php and sql. We create a session when the user logs in, can we store their info in that session?

When the user logs in we have this code to create a session and see if the login info is correct: <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="members"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { echo "Wrong Username or Password"; } ?> But this code just forwards them to a generic page, we need on that page to be able to pull the users ID so we can display their specific information. Should we store it in the session? Can you even do something like that? If so, how? more

Voting Question: please tell how to make connection in php with sql remort server?

server name: spike.scu.edu.au username: shop pass: shop db name: shop I am doing it like this <?php $host ="spike.scu.edu.au"; $user ="shop"; $pass = "shop"; $db = "shop"; mysql_connect($host,$user,$pass) or die("failed to connect database"); mysql_select_db($db, mysql_connect) or die("no database selected"); ?> more

Resolved Question: What is the best/easiest way to backup a MYSQL database to sourcecontrol?

Its a hosted account with PHP and phpMyAdmin. The source control is local subversion. The idea is to easily see relevant differences, and I suspect that for example SQL code backup is not the best way to do that. How is this better than PHPMyAdmin? Was thinking of something like XML, or perhaps having just one item pr line. more

Voting Question: Problem with PEAR::DB?

i followed a tutorial for php login script. Instead of them using mysql_connect they made a database config file. Inside it they put require db.php. Throughout the whole tutorial they didn't say to make a db.php. Also when reading up on PEAR::DB i found this line: Imports all the PEAR::DB classes, static methods, etc... but when i load it on my host it says it can't be found! How can I sort this out? more

Resolved Question: I need to convert a POSTGRESQL database over to MYSQL due to hosting restrictions... recommendations?

OK. I run a drupal site, and just for fun I set it up to use postgresql, because my hosting provider provided it. Now I'm moving to another provider that does not provide postgresql, and I need to convert databases. Recommendations? Preferably a process that doesn't require "write a sql script by hand (or a database parser) to replace the other database" :D more

Resolved Question: Free Web Hosting With MYSQL/PHP and cpanel?

I'm looking for a trusted web hosted company that offers free webhosting with FTP support, MYSQL, PHP. cpanel would be nice but not entirely necessary. I know of heliohost, but there are errors right now.. I have an account with x10hosting but they lied to me about the MYSQL database. I don't care if they put ads on my webpages, either. As long as they are not pop-ups. I've been to the freewebhosting review site, but I don't really like it. more

Voting Question: Database help…..accessing/displaying data?

Here is the code i have for entering the items into the database <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Our List of Jokes</title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> </head> <body> <?php // Connect to the database server ?> <?php $usr = "***********"; $pwd = "***********"; $db = "**********"; $host = "***********"; $cid = mysql_connect($host,$usr,$pwd); if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); } ?> <?php if ($_SERVER['REQUEST_METHOD'] == "POST") { // the following 4 lines are needed if your server has register_globals set to Off $name = $_POST['name']; $price = $_POST['price']; $SQL = " INSERT INTO guitars "; $SQL = $SQL . " (name, price) VALUES "; $SQL = $SQL . " ('$name', '$price') "; $result = mysql_db_query($db,"$SQL",$cid); if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); } echo ("New Link Added\n"); } mysql_close($cid); ?> Now i need to be able to access this database and display it in an HTML file for the users that come to the site to be able to read what text i have in the database more

Resolved Question: Specific web hosting needed?

I'm currently using Ipower as my web hosting service. But they don't support what i need for my current websites. Below are the requirements i need for a hoster. The Program i am trying to use is PHPmotion, below are its requirements: - PHP 4.3 and above (including support of CLI) - MySQL database server - LAME MP3 Encoder - Libogg + Libvorbis - Mencoder and also Mplayer - FFMpeg-PHP - GD Library 2 or higher - CGI-BIN - Be able to run background processes If you could tell me a web hoster who has those requirements and has phpshield. And is cheap!!! please post it here Thanks more

Resolved Question: Connect to MySql Database on another hosting company?

It would be much less work to change all that info I have the database w/godaddy but I'm trying to get to it with a web page on Awardspace - it didn't work Can it work? more

Resolved Question: database Error HELP PLZ ?

When i try to creat a database i get this error Error SQL query: CREATE TABLE `donavons_Testdatabase`.`Kelly` ( `price` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL , `dis` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL , INDEX ( `price` , `dis` ) ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin MySQL said: #1170 - BLOB/TEXT column 'price' used in key specification without a key length Can you help me fix it. Or give me step by step setup on the host monster mysql database. PS if someone that knows what they are doing could IM ME that would be asome! THANK YOU SO MUCH FOR ALL YOUR HELP more

Voting Question: ive set up the database but keep getting this error...?

Ok heres the error i receive: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/usgaming.co.uk/public_html/include_web/checklogin.php on line 26 Wrong Username or Password and heres my code: <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="members"; // Table name mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); $count=mysql_num_rows($result); if($count==1){ session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { echo "Wrong Username or Password"; } ?> Could someone kindly help me with what is going wrong here? more

Resolved Question: Help setting up phpMyAdmin?

I just started a database in a new host and set up and the database, but I have problem connecting to it. This is the error displayed in my php file: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/chibuki/public_html/connect.php on line 9 Could not connect to the database: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 This is what my connect file looks like: <?php //Set Up database Info $db_host = 'chibuki.x10hosting.com'; $db_database = 'chibuki_chibs'; $db_username = 'myusername'; $db_password = 'mypassword'; // Make connection $connection = mysql_connect($db_host,$db_username,$db_password); if(!$connection) { die("Could not connect to the database:<br />". mysql_error()); } // Select database $db_select = mysql_select_db($db_database); ?> I'm basically not sure what that error means. And where to get the $db_host info in my new host provider. Where should I look for it? Is everything set up the way it should be? OK the title is probably misleading. This is more of a mySQL error. more

Resolved Question: I want to start a web host!?

Hey Yahoo techies, I want to start a hosting company and I need to know where and what to buy for a server that has similar quality as server on BlueHost, GoDaddy, and 1and1. To help you organize an answer, here's a list. 1 Server Parts a. CPU b. RAM and amount 2. Server Rack 3. Storage Databases 4. Host Control Panel 5. XAMPPS to install MySQL, PHP, Mercury, etc. 6. High Speed ISP (Which ones? I live in Irvine, CA) I have no idea what brands and hardware specifications I need. Please tell em what parts I would need and which ones are best or adequate for a Host. Is XAMPPS and a CPanel License all I need to install?? So is that all I need? Let me know if I need anything else to run a web host company! Software, Hardware, or anything at all. I do plan on having a office location to run the Host, it's not from home. Wamr Regards, Jason I'm not blindly leaping. I am just uncertain about everything I need, and I am taking classes. I also have quite a few acquaintances who will help manage it for a cut. I am just here to get the rundown on equipment mainly. Anyone give me a list please? I do have stock actually, Stocks and Bonds Net worth plummeted from $460k to $138k recently. I also do architectural design and have had some fun doing a few car designs. I also own a few businesses. Just trying to learn what I need to know so I can hire people who know what they're doing to manage everything. I don't want to blindly hire people and appoint people to buy random parts that end up DoA or low performing. more

Resolved Question: Simple PHP/MySQL Question?

I'm learning PHP and trying to connect to the MySQL database for the first time. I'm not sure if I have the information for the host and user correct, because when I try and connect to the "connectdb.php" file, it sends me to a white screen. No error screen comes up at all, the progress bar at the bottom left says "done." I have test info that I've added to the tables, and the database itself only has two tables? Am I connecting correctly? Shouldn't I see the tables that I've created once I go to the connectdb.php file? more

Resolved Question: php and cookies error please help/?

i keep geting this error: Warning: Cannot modify header information - headers already sent by (output started at /home/www/pixelpig/signin.php:2) in /home/www/pixelpig/signin.php on line 21 Warning: Cannot modify header information - headers already sent by (output started at /home/www/pixelpig/signin.php:2) in /home/www/pixelpig/signin.php on line 22 this is my code: (begin)<html><body><div id="mainbody" style="text-align: center; position:absolute; left:80px; right:79px; top:300px; z-index: 4"> <?php if(isset($_POST['submit'])) { // form submitted // set server access variables $host = "*************"; $user = "*******************"; $pass = "*************"; $db = "*********************"; // get form input // check to make sure it's all there // escape input values for greater safety $username = empty($_POST['username']) ? die ("ERROR: Enter a username. <a href=". $_SERVER['PHP_SELF'] ."> Please click here to go back to the form.</a>") : mysql_escape_string($_POST['username']); $password = empty($_POST['password']) ? die ("ERROR: Enter an password. <a href=". $_SERVER['PHP_SELF'] ."> Please click here to go back to the form.</a>") : mysql_escape_string($_POST['password']); // open connection $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); // select database mysql_select_db($db) or die ("Unable to select database!"); $query = "SELECT * FROM users WHERE username = '" . $_POST['username'] . "' AND password = SHA1('" . $_POST['password'] . "')"; $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()) .""; if (mysql_num_rows($result) == 1) { setcookie(username, $username, time()+(84600*30)); setcookie(password, SHA1($password), time()+(84600*30)); if (isset($target)) { echo "Welcome back $username. <a href=$target>Go back!</a>"; } else { echo "Welcome back $username. <a href=index.php>Go to the homepage!</a>"; } } else { echo "Your login information is incorrect.<a href=". $_SERVER['PHP_SELF'] ."> Please click here to go back to the form.</a><br>"; } // close connection mysql_close($connection); // form not submitted } else { ?> <form action="<?=$_SERVER['PHP_SELF']?>" method="post"> username: <input type="text" name="username"> password: <input type="password" name="password"> <input type="submit" name="submit" value="login!"> </form> <?php } ?></div> </body> <head> <title>Pixelpig|</title></head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script language="JavaScript">  </script> </head> <body bgcolor="#FFFFFF" onLoad="MM_preloadImages('images/Home2.gif','images/Games2.gif','images/scores2.gif')"> <div id="layout"> <div id="title" style="position:absolute; height:240px; z-index:2; left: 16px; right:16px; top: 16px"><img src="images/title.gif" width="100%" height="240" border="0" align="left"> </div> <div id="leftbar" style="position:absolute; min-height:400px; z-index:3; left: 0px; top: 0px; height: 100%; width: 57px"><img src="images/l.gif" width="32" border="0" align="left" height="100%"> </div> <div id="rightbar" style="position:absolute; min-height:400px; z-index:3; right: 0px; top: 0px; height:100%; width: 47px"><img src="images/r.gif" width="36" border="0" align="right" height="100%"></div> <div id="topbar" style="position:absolute; height:33px; z-index:2; left: 0px; top: 0px; right: 0px"><img src="images/t.gif" width="95%" height="32" border="0" align="right"></div> <div id="topleftcorner" style="position:absolute; height:115px; z-index:3; left: 0px; top: 0px; right:0px" ><img src="images/tl.gif" width="64" height="64" border="0" align="left"></div> <div id="toprightcorner" style="position:absolute; height:115px; z-index:3; right: 0px; top: 0px; right:0px" ><img src="images/tr.gif" width="64" more

Voting Question: I changed the password of my website's database. Now I can't even access the website... why?

I originally gave my designer the password info for the MYSQL database for my website so he could do what he needed to do to set it up when he also installed the files on my GoDaddy hosted site. Now that my designer is off the job, I changed the password. Now when I try to launch the site (the standard way, by typing the URL into a browser), I get the following error message. "Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'MYUSERNAMEWASHERE'@'72.000.131.98' (using password: YES) in /home/content/w/h/i/myusernamewashere/html/admin/includes/openconn.php on line 15 Unable 2 Connect 2 Database Server" When I wrote to GoDaddy, they replied: "If you have updated the database password you will need to go in and update your code and connection strings to the database to reflect the new password." MY QUESTION IS did they understand my question in the first place? Do I really need to do this? I've never done this before and I'm not even sure how. Can someone who knows please clarify all this for me? I'm lost. HA! Thanks! more

Voting Question: Does anyone know how to change the password on a database for a site hosted on GoDaddy?

I don't mean the main PW to get into the GoDaddy site... and not the PW for the hosting manager... but the PW for the MYSQL database. I don't see the option. Thank you! P.S. It's the Starfield Technologies phpMyAdmin more

Resolved Question: Any good FREE web hosts with php5, sql databases and ftp?

Are there any good, free, web hosts which offer PHP5, MySQL databases and FTP account(s)... besides X10Hosting and 000Webhost. Oh and, I don't like VistaPanel. :( more

Resolved Question: I am running a private W.O.W. Server - How do I get it so my freinds can use it from their comp?

I am running Mangos 2.4.3. i alredy made 2 dns ip's(w.e its called ) one on no-ip.com and the other one on dysdns.com (w.e) ones arra.servegame.com/ the other arra.servegame.org I have put all databases in the config files to arra.servegame.org and the reamlist in mysql querry to arra.servegame.org. but when other people connect all they get is connecting... unable to connect.> only i can play cause when whent to c://windows/system32/drivers/etc/host i put in 127.0.0.1 arra.servegame.org / 127.0.0.1 arra.servegame.com / internal ip arra.servegame.com / internal ip arrra.servegame.org / external ip arra.servegame.org/arra.servegame.com < what is my problem please help << thnx I run a DIR-655 Router, and I believe i port forwarded the necessary ports, but i don't know what name i should put? if you ahve MSN Mesanger, plz contact me at "time_is-ticking@hotmail.com". Any and all help is greatly appreciated. more

Voting Question: update multiple rows mysql?

code below actually works just fine in terms of pulling the data and showinf them on the table, but when you update a field and click on the submit button, it doesn't change anything. I think my issue is with $id but I am not so sure. What has been defined for $id ihave defined as "personID" in my table. If you have a comment make sure it's working before you actually post it. Thanks, ==================================== <strong>Update multiple rows in mysql</strong><br> <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); // Count table rows $count=mysql_num_rows($result); ?> <table width="500" border="0" cellspacing="1" cellpadding="0"> <form name="form1" method="post" action=""> <tr> <td> <table width="500" border="0" cellspacing="1" cellpadding="0"> <tr> <td align="center"><strong>Id</strong></td> <td align="center"><strong>Name</strong></td> <td align="center"><strong>Lastname</strong></td> <td align="center"><strong>Email</strong></td> </tr> <?php while($rows=mysql_fetch_array($result)){ ?> <tr> <td align="center"><? $id[]=$rows['id']; ?><? echo $rows['id']; ?></td> <td align="center"><input name="name[]" type="text" id="name" value="<? echo $rows['name']; ?>"></td> <td align="center"><input name="lastname[]" type="text" id="lastname" value="<? echo $rows['lastname']; ?>"></td> <td align="center"><input name="email[]" type="text" id="email" value="<? echo $rows['email']; ?>"></td> </tr> <?php } ?> <tr> <td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td> </tr> </table> </td> </tr> </form> </table> <?php // Check if button name "Submit" is active, do this if($Submit){ for($i=0;$i<$count;$i++){ $sql1="UPDATE $tbl_name SET name='$name[$i]', lastname='$lastname[$i]', email='$email[$i]' WHERE id='$id[$i]'"; $result1=mysql_query($sql1); } } if($result1){ header("location:update_multiple.php"); } mysql_close(); ?> more

Voting Question: What is wrong with this PHP code ?

It makes the connection to the table and it actually shows the data, but when I click on delete it doesn't delete the line. <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); $count=mysql_num_rows($result); ?> <table width="400" border="0" cellspacing="1" cellpadding="0"> <tr> <td><form name="form1" method="post" action=""> <table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC"> <tr> <td bgcolor="#FFFFFF">�</td> <td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td> </tr> <tr> <td align="center" bgcolor="#FFFFFF">#</td> <td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td> <td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td> <td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td> <td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td> </tr> <?php while($rows=mysql_fetch_array($result)){ ?> <tr> <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td> <td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td> <td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td> <td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td> <td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td> </tr> <?php } ?> <tr> <td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td> </tr> <? // Check if delete button active, start this if($delete){ for($i=0;$i<$count;$i++){ $del_id = $checkbox[$i]; $sql = "DELETE FROM $tbl_name WHERE id='$del_id'"; $result = mysql_query($sql); } // if successful redirect to delete_multiple.php if($result){ echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">"; } } mysql_close(); ?> </table> </form> </td> </tr> </table> more

Resolved Question: whats wrond with my php code???? help me please????

I cant handle this error because i'am new in php.,., Parse error: syntax error, unexpected T_STRING in C:\wamp\www\cssonline\confirm.php on line 28 <?php $host = "localhost"; $user = "root"; $passwd = ""; $database = "cssonlinedb"; $connect_db = mysql_connect("$host","$user","$passwd"); if (!$connect_db) { die ('Could not Connect: ' . mysql_error() ); } mysql_select_db("$database", $connect_db) or die ('Cant connect the database: ' . mysql_error() ); $id = $_POST['stud_id']; $passwd = $_POST['password']; $lname = $_POST['last_name']; $fname = $_POST['first_name']; $mname = $_POST['middle_name']; $mail = $_POST['email']; $gender = $_POST['gender']; $yrlevel = $_POST['level']; $country = $_POST['country']; //line 28 $sql = INSERT INTO registration ( stud_id, password, last_name, first_name, middle_name, email_ad, gender, year_level, country ) VALUES ( '$id', '$passwd', '$lname', '$fname', '$mname', '$mail', '$gender', '$yrlevel', '$country' ); $test = mysql_query($sql); if (!$test) { die ('Error: ' . mysql_error() ); } mysql_close(); ?> more

Resolved Question: Which is the best webhost?

I need to know which is the best webhost in terms of reliability and uptime, I need a webhost that has: at least 50 GB of space, Unlimited Domains, at least 100 GB of bandwidth. I also need one that has multiple plans so if i use up all the space or use up too much bandwidth i can upgrade it. I need one with a option of dedicated hosting when the site gets to busy, and one more thing i need at least 10 MySQL databases Also it has to be a paid host. And nothing that is unlimited everything because that is serious overselling, it can have like unlimited bandwidth or MySQL databases, but not everything unlimited because there is no such thing as unlimited they have to stop me somewhere. Also i was looking at hostgator, has anyone tried that one, and if so is it good. more

Resolved Question: MySQL_Connect Error on Line 61?

Hi: I have godaddy and uploaded my website on their hosting service. When I typed in my URL, I got this error: Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/m/y/p/mypetpeeves/html/framework/class.database.php on line 61 Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) Anyone have any idea what this is? Thanks so much. Godaddy told me to "google" this issue. They said that they cannot help with scripting issues. I went to so many forums with no luck. Where should I go to check that Line 61 for you? more

Resolved Question: I keep getting this messge. Can somene help me?

Warning: mysql_connect() [function.mysql-connect]: Host 'www.shirtcity.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' in /srv/www/htdocs/shirtcity.com/shirtcity/index.php on line 20 no connection to database server: Host 'www.shirtcity.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' more

Resolved Question: Mysql full dump question?

Hi I need to transfer my website to another host and I am wondering if I perform a create a full dump of the database, will it delete the existing database or just copy it, can I dump it more than once in other words? Thanks in advance more

Voting Question: Can you make a mysql database on one host and use it for a site on a different host, and if so how?

My friend needs a mysql database, and her host hasn't been online to set her up (long story) and so I'd like to make a database with my server, and let her use it. Is this possible, and if so how? more

Resolved Question: who is the best (or just your favorite) database (mysql) hosting company?

Currently using Godaddy, heard out about certain limitations on their database accounts and wondering who has a good mysql service with no limitations and at a decent price. more

Resolved Question: How can I install php scripts on my site?

I'm installing a script called "Simple Member" on my subdomain on awardspace.com, I don't know how to do the MYSQL things. Here's the config part: <? ######################################################### # Simple Member # ######################################################### # # # Created by: Doni Ronquillo # # # # This script and all included functions, images, # # and documentation are copyright 2003 # # free-php.net (http://free-php.net) unless # # otherwise stated in the module. # # # # Any copying, distribution, modification with # # intent to distribute as new code will result # # in immediate loss of your rights to use this # # program as well as possible legal action. # # # ######################################################### define("SCRIPTNAME","Simple Member"); define("BASEHREF","http://www.free-php.net/demo/SimpleMember"); define("DOMAIN","localhost"); define("FROMEMAIL","drunkenmenace@gmail.com"); define("SITENAME","Free-Php.net"); define("INC_DIR","/home/www/codemunkyx/www/www.free-php.net/htdocs/demo/SimpleMember/inc/"); define("PAG_DIR",INC_DIR."pages/"); define("INC_DB",INC_DIR."db.php"); define("MYSQLUSER",""); // mysql username define("MYSQLPASS",""); // mysql password define("MYSQLDB",""); // mysql database name require(INC_DB); ?> My host is awardspace.com, my username is annryll6696, my MYSQL username and DB is annryll6696_4ev Can you show me how the script is supposed to look with all my info in it? Email me for more info or to tell me: annryll@aol.com [edit] Yahoo messes up the code, plz email me! annryll@aol.com [/edit] more

Resolved Question: Finding MySQL Host please help!!!?

Hello When i try to install my website Its Asking me for MySQL Host: MySQL Database Name: MySQL Username: How do i find these please???? Im using cpanel x if that helps, also its showing me my Username: and the name of the database but not showing me MySQL Host: So do i go about finding this, when i click on mysql databases it shows database name and username but not the 1 last thing i need which is MySQL Host, When i click on myphpadmin its shows: User: example@localhost would this be it???? Any help and maybe a guide on where to find mysql host would be apreciated cheers more

Resolved Question: MySQL Query Results Question?

Why is this working only in Firefox but not IE? Please help. Trying to get the database results to appear in 2 rows. In IE it just displays across but does not break after two tables in order to present two rows. Here is the code... <?php $con = mysql_connect(DB_HOST, DB_USER, DB_PASS); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db(DB_NAME, $con); $result = mysql_query("SELECT * FROM signatures WHERE id='1' ORDER BY first_name"); while($row = mysql_fetch_array($result)) { $i++; echo "<font face='Segoe Script'>"; echo "<table width='250' align='left' border='0' cellpadding='0' cellspacing='0'>"; echo "<tr>"; echo "<Td width='176'>" . $row['first_name'] . " " . $row['last_name'] . "</Td>"; echo "<Td width='74'><font face='Arial'>" . $row['state'] . "</font></Td>"; echo "</tr>"; echo "</table>"; echo "</font>"; if($i==2){ echo "<br>"; $i=0;} } mysql_close($con); ?> more

Resolved Question: I'm designing a website...how much $$ is it worth? What's the going rate?

I'm designing a website for a medium-sized company in Las Vegas. The site uses html, as well as PHP/MySQL, flash, and java. Approximately 90% of the business administration is done on the website. Thus far, I have written 25,000 lines of code, and the MySQL database has about 50 tables, the largest table has about 120,000 records. I've done all of the website design from scratch, both the art on the front end and the database in the back. I also physically host their web and db server. I also host and manage their E-mail server. Future plans are to integrate some of their administration with Medicaid. I've been doing the work for a little over a year. A year ago, I laid out a basic site, and asked for a (VERY small) price, and got it. But the project is getting very large, and I need to start getting paid! The trouble is, I have no idea what to ask. Hourly rate? Per line of code? Re-quote the entire project to the company? Does anyone have any ideas about a baseline salary or guide to estimating the cost of the work I'm doing? Thanks! Thanks for all the feedback so far. A few other points: I can't show you the site, since it deals with the inner workings of a health-related company, and there are lots of strict security requirements (HIPAA). I also work for the company in another capacity. As they started to grow and expand onto the web, I offered to do their site. The price I quoted was for very specific things. As the company grew, so did the site, and there are lots of things I'm doing now that aren't in the original quote. I am extremely good friends with the owner of the company, and there is absolutly no animosity at all. I'm certain that the owner simply has no clue what a job of this size would cost him (as don't I), and I'm sure that anything reasonable, he will pay. It's my bad for not approaching him much earlier on about all of the extra work. I get a very good salary from the company in my other job, and this extra work really wasn't an issue until now. Thanks for the help so far! more

Voting Question: Does anyone know a good free web host?

I am looking for a free web host that can: -Handle lots of traffic. -Has a FTP server option -Provide me with a CPanel -Provide me with Linux OS systems -Provide me with PHP -Provide me with unlimited MySQL Database's -Provide me atleast 100MB of web space more

Resolved Question: Need help with starting a web hosting!?

I have little knowledge about web hosting but would like to start one as soon as possible. At the moment, I need it for school projects, self-practice, and personal use and I'm also thinking about small business later. There are plenty to choose from but I'm looking for these ideals: - domain name - cheap web hosting servers (with FTP upload, and all that stuff) - PHP MySQL database - reliable customer support I'm in the middle of learning PHP and MySQL, but not sure if these providers offer it too. GoDaddy seems to the best choice at the moment but I want to ensure if they have everything I need. Or maybe someone here know a better provider. Thanks. more

Resolved Question: I have a website that someone else developed for me. I want to download the MySQL database from the server?

There isn't an option with my hosting to take a backup, or export. Are there any tools out there or tricks that will enable me to download my database and tables? Thank you very much more

Resolved Question: With my GoDaddy hosting account, should I choose Linux or Windows?

My operating system is Windows XP but when I sent a help request to Go Daddy regarding webforms and databases, ie php and mysql, they told me I had to switch my hosting account from Windows to Linux. I've done this, but can't get my forms working. I'm not sure if I've simply botched the script or whether it's because I have a Linux hosting account when I operate on Windows!!! Can anyone help please? When I click "Submit", it tries to go to www.mydomain.info/processform.php and then I get an error message: HTTP 404 Not Found This is the code I am using for the form (with the guts of the form fields cut out): <form action="/webformmailer.php" method="post"> <?php <input type="hidden" name="subject" value="WebForm" /> <input type="hidden" name="redirect" value="thankyou.html" /> ?> <label><span class="style1">First name: <input name="name" type="text" id="name" size="50" /> </span></label> <p class="style1"> <label>Surname: <input name="Surname" type="text" id="Surname" size="50" /> </label> </p> <p class="style1"> <label> <input type="submit" name="button" id="button" value="Submit" /> <?php <input type="hidden" name="email" value="mailto:me@myemail.com" /> <input type="hidden" name="form_format" value="default" /> <input type="hidden" name="form_order" value="default" /> <input type="hidden" name="form_delivery" value="default"/> ?> </label> </p> <p class="style1">�</p> <p class="style1">�</p> <p>�</p> </form>Contact_Form <?php //Connect To Database $hostname="pXXmysqlXXX.secureserver.net"; $username="Contact_Form"; $password="mypassword"; $dbname="Contact_Form"; $usertable="your_tablename"; $yourfield = "your_field"; mysql_connect($hostname,$username, $password); mysql_select_db($dbname); # Check If Record Exists $query = "SELECT * FROM $usertable"; $result = mysql_query($query); if($result) { while($row = mysql_fetch_array($result)) { $name = $row["$yourfield"]; echo "Name: ".$name." "; } } ?> more

Resolved Question: What is a good application for designing a MySQL-driven website on Mac OS X?

I am developing a web site that allows users to search for information stored in a MySQL database on a Mac. I am looking for an application to assist in the design of the web site, allowing me to create search forms to retrieve the data from a MySQL database on a Mac OS X computer. I do not want to outsource this task or to have another company host it. Any suggestions and/or advice will be appreciated. Thanks. more

Voting Question: How do I create a mailing list from my domain name (i.e. group@website.com)?

I am trying to create a mailing list for my college organization (we'll call it alpha beta) so members can simply send an email to members@alphabeta.com if our website is alphabeta.com and all of the members on that list will receive an email. I know other groups do this, I'm just trying to figure out how! My website host has provided and a mysql database feature if this helps. Thanks! more

Resolved Question: Web Hosting at Office live ?

I own a domain at office live and I am ready to host a web page there. My plan is to create a web page with user directory where users information will be stored and for that purpose a database is needed. I found that microsoft officelive does not support MySQL database. Can anyone tell how can I use database in officelive? I can not change my hosting service to other company. Can anyone tell me how can I use database at officelive? Actually I want to know what kind of database facilty does officelive support so that I can store user information more

Resolved Question: how can i fill the details in mysql db program with the host name :localhost?

i had an account on x10hosting and they gave me a database with host name : localhost and i can't use my db prog. (navicat mysql) to connect to my database more

Resolved Question: How do you use, Install and maintain an Apache Server?

Hi. I am going to make a website with News and Articles and I need a Content Management System. I decided to go and get Joomla. The problem is that I need an Apache Server, but don't know what to do with one. Do I install the software on the hosting site or my PC? If the second one, if my PC turns off does my website completely crash (because my entire site will be dependent on Joomla)? How much space does it take up? Also, how do I maintain it? I don't want to spend £1000 for a server in that popular E1 Datacenter in Texas. It is just a fansite for a game I play. If I have to spend thousands I'll just get Cute News because I know that works without a MySQL database. more

Voting Question: How do I used a backed up SQL database to restore my SMF 1.1.5 forum?

My friends SMF 1.1.5 forum was hacked and he had a backed up .sql database. I'm trying to reopen it for him. I'm using 000webhost and the sql database is too long to just paste on phpmyadmin, is there anyway I can post the entire database at once? Should I download MySQL and try with that? It's pretty big, 24mb as a .txt... I can use Wamp if it would be easier for me. I don't have any paid hosts. Please help.. I'm not very experienced with this. more

Resolved Question: Can I share or import data from another (Drupal) site to my current site and then export back?

I would like to know whether it is possible to import customer profiles from an external MYSQL database (ie, from another drupal site hosted on a different server) to my current drupal site to be used for running my applications and then export them back with some profile modifications? I would like to keep the main database site separate from my application site and run it with only necessary data fetched from the main database. Will this system work? Is it something complicated to administer? Is there any other way of doing it? I think ,using a sub domain to host my application site might solve this issue ... But practically I prefer to have two separate sites in different servers to keep atleast one site unaffected by any possible server problems. Can someone answer me? I am not a technical guy.... Thanks. Binu more

Resolved Question: how can I VIEW what I have made with WYGIWYS so far??

Hi, how can I preview it to browser, is there a way? I dont have hosting yet...and can I use this to make a database driven ecommerce website? I mean, can I use this combo with mysql..and then how do I connect the pages ? Thanks so much!! more

Resolved Question: How to connect MySql server to my local machine?

I just want to connect Mysql server to my local machine. I'm using third party software name is MagneticOne Store Manager for osCommerce. Its asking database user name, password and protocol (mysql-4.1...etc). My database is in server via Web host manager. I want to connect it through this software. How to do it? Thanks more

Resolved Question: How do i install Apache, PHP and MySQL?

I have downloaded all three but need some help (few questions): Am i right in thinking with Apache i can host my own site's? When i try to install Apache, it asks for network domain and server name what does that mean is it a domain name as i don't have one yet? PHP installation instructions say to run the MSI installer, i can't even find that in the PHP folder, what's gone wrong and there are so many files its confusing me? As for MySQL, i thought i followed the instructions correctly, but when it loaded up it was for some command codes or something, i thought it was for databases? This is getting to confusing, and all i want to do it start learning PHP, is there an easier way? Please help, desperate and confused wannabe web-designer Thanks in advance PS: If you think i am too thick to be studying this stuff, keep your comments to yourself (as i am sick of idiots thinking i should be an A* pupil to study this stuff) I am and always be thick, so my achievements will always be greater than yours !!! more

Resolved Question: What does it take to make a dynamic database driven ecoomerce site?

hi, can you please list everything I need? Do I need mysql, cart, wysiwyg ? Im not sure of all the tools I need to create this myself, can you please help me and explian in steps what I need to do First? Thanks so much :) PS: Im having a hard time understing what I should do first and when do I get hosting , After I build my site? Thanks more

Resolved Question: Please help, please programmers?

hello, I have been trying to find a solution to my site. I need a new database driven ecommerce site w/custom features. What is the best way to do this? I dont know how to create it myself since it needs to be created php & mysql . Do I need to BUY a cart to customize it? Or hire a coder? or...get a template? OR, get a hosting company with the cart & mysql with it? PLEASE help, I really appreciate all your help. thanks so much :) more