mrlankee

ah =] thanks! I appreciate all the help!

this is hurting my brain lol where i cannot figure it out?

I switched up the code still getting the error Parse error: syntax error, unexpected '{' in /home/xxxxxxxxxxxxxxx/xxxxx/account.php on line 100 I did add a ?> to close out the PHP after the image was taken.

still shooting the error. Parse error: syntax error, unexpected '{' in ......."removed".../account.php on line 96

Parse error: syntax error, unexpected '{' in ......."removed".../account.php on line 96 Which is the first { after "if"

how do i fix it? :\ lol

www.rpproject.net/useraccount.php As you can see.. no matter what you enter.. the "else" does not show up as "Sorry, that username does not exist in our database.";" I cannot figure out whats going on.. exact code. <form action="account.php" method="GET"> In-Game Name:<br> <input type="text" name="username" value="Username"> <br> <input type="submit" value="Submit"> </form> <?php $username = $_POST['username']; $pdo = new PDO('mysql:host=xxxxx;dbname=xxxx', 'xxxx', 'xxxx'); if ($pdo->query("SELECT * from TABLENAME where username='".$username."'")->fetchColumn() > 0){ foreach($pdo->query("SELECT * from TABLENAME where username='".$username."'") as $row) { echo $row['Player_Name'] . $row['Time_Online']; } $pdo = null; } else{ echo "Sorry, that username does not exist in our database."; } ?> Any ideas?

Sorry what i ment is .. If i enter username Alpha instead of Bravo.. it'll show Alpha's row's... it's basically drawing data from a game MySql

Hi, I'm trying to figure this out.. I am creating a user search on my website thats connected to mysql. What I have does not work :\ <form action="useraccount.php" method="post"> <input type="text" name="username"/> <input type="submit" value="submit"/> </form> <?php $username = $_POST['nome']; $pdo = new PDO('mysql:host=myhost;dbname=mydb', 'user', 'pw'); if ($pdo->query("SELECT * from TABLENAME where username='".$username."'")->fetchColumn() > 0){ foreach($pdo->query("SELECT * from TABLENAME where username='".$username."'") as $row) { echo $row['Player_Name'] . $row['Time_Online']; } $pdo = null; } else{ echo "Sorry, that username does not exist in our database."; } ?>

Looking for someone to create a client side script to meet the following requirements: Client side Login to multiple affiliate accounts of mine (around 30) Gather information required log out Display results client side in a nice and organized fashion Please PM me or e-mail me with approximate price given the requirements above along with your experience. Payment will be through paypal. e-mail a3lankee@gmail.com

Is it possible and how difficult is a script to go into my login accounts on multiple websites .. collect the data in my account and show it all on my own page for easy moderation and to save time from login into 20 + websites every day?

Exactly I REALLY appreicate that, made the process make so much sense. I'm new to the whole SQL db, How would one call from a search form results from the whole table in a nice chart?

Essentially yes.

I say different tables because (Game servers, ded servers, vps, and VOIP servers) my question is how do I go about code a sorting process to only insert the pricing, hardware, and other pertinent information into the DB of the HTML source?

Hi What is the best recommended way to "sort through" and "place certain data" into a sql table? For example, I create a input form.php Company Name: The Blah Company Product/Industry Dedicated Servers HTML Source Code <div class="allservers"> <div class="serverType" id="server1"> <div class="myFeaturesBox"> <ul class="tabination"> <li><a href="#" class="activeTab" data-tab='feature'>FEATURED</a></li> <li><a href="#" data-tab='single'>SINGLE PROCESSOR</a></li> <li><a href="#" data-tab='dual'>DUAL PROCESSOR</a></li> <div class="clear"></div> </ul> <div class="feature myTab activeTabs"> <table class="table"> <tr> <th></th> <th>Processor</th> <th>RAM</th> <th>Hard Drive</th> <th>Price/Mo</th> <th></th> <th></th> </tr> <tr> <td><img src='img/server.png' alt='Server' width="20" height="20" /></td> <td>Intel Xeon E3-1230 (4x3.2GHz)</td> <td>8 GB DDR3</td> <td>1x500 GB SATA</td> <td>$98.00</td> <td><a href="https://portal.securedservers.com/wap-jpost3/UP011013E31230" target="_self"><img src='img/deploy.png' alt='Deploy Now' width="86" height="18" /></a></td> <td class="wB"></td> </tr> <tr> <td><img src='img/server.png' alt='Server' width="20" height="20" /></td> <td><div style="position:relative;">Intel Xeon E3-1240 v3 (4x3.4GHz)</div></td> <td>8GB DDR3</td> <td>1x1 TB SATA</td> <td>$128.00</td> <td><a href="https://portal.securedservers.com/wap-jpost3/UP031013E31240" target="_self"><img src='img/deploy.png' alt='Deploy Now' width="86" height="18" /></a></td> <td class="wB"></td> </tr> <tr> <td><img src='img/server.png' alt='Server' width="20" height="20" /></td> <td><div style="position:relative;">Intel Xeon E3-1240 v3 4-bay (4x3.4GHz)</div></td> <td>8GB DDR3</td> <td>4x500 GB SATA</td> <td>$148.00</td> <td><a href="https://portal.securedservers.com/wap-jpost3/UP431013E31240" target="_self"><img src='img/deploy.png' alt='Deploy Now' width="86" height="18" /></a></td> <td class="wB"></td> </tr> <tr> </table> Submit Button --> sends to the "sorting process?" than into proper DB tables for search query. Ultimately, there I require to be able to pull from my DB upon query, pricing, hardware, processor, etc.. Any recommendation for me to try? I'm new to PHP but I want to learn and do it myself (better after effect feeling than paying someone)

sent e-mail

sent e-mail

sent e-mail

I am in the process of making a promising company that is the first of it's kind in it's respective market and require an in-house programmer. PM me for further details. Mr. Lankee

Hit a bump, i understand the fetch and return to output the data. What I don't get is how the submit form tells the DB to do the fetch process and return with the values in the submitted form? If that makes sense lol.

Thank you for your guidance, I give er the old collage try and report back.

Hello everybody! Mr Lankee here,web designer for years now HTML, CSS and java.. Been recently dabbing into the back end, looking forward to becoming a Jedi master of the art of php!

There are open-sourced programs that record streams. Why do you want to use PHP?

from what I am getting, I add the following into my process.php? <?php $dbhost = 'localhost'; $dbuser = 'myuser'; $dbpass = 'mypw'; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysql_error()); } $sql = "SELECT `company`, `price`, `reviews`, `locations`, `date` FROM `MYDBNAME`.`gameservers`"; mysql_select_db('MYDBNAME'); $retval = mysql_query( $sql, $conn ); if(! $retval ) { die('Could not get data: ' . mysql_error()); } while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) { echo "Company :{$row['company']} <br> ". "Price : {$row['price']} <br> ". "Locations : {$row['location']} <br> ". "Reviews : {$row['reviews']} <br> ". "--------------------------------<br>"; } echo "Fetched data successfully\n"; mysql_close($conn); ?> wondering how I would send this information to my servercompare.html

I've created a test page to show what I want on the front end.. http://thegoodliferpg.com/test/test.html <-- i only set up "game servers" Test html core <form action="process.php" method="post"> Game: <select name="game"> <option>Select a Game</option> <option value="Counter-Strike 1.3">Counter-Strike 1.3</option> <option value="Counter-Striker: Source">Counter-Strike: Source</option> <option value="Counter-Strike: GO">Counter-Strike: GO</option> <option value="ArmA: 3">ArmA: 3</option> <option value="Call of Duty: 4">Call Of Duty: 4</option> </select> Slots <select name="slots"> <option>Desired Slots</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> </select> <input type="submit" /> </form> Process Core <?php $game = $_POST['game']; $slots = $_POST['slots']; echo "You are looking for a ". $game . " server with " . $slots . " slots.<br />"; echo "We are processing your request!"; header( "refresh:2;url=servercompare.php" ); ?> Compare Core <center><TABLE BORDER="5" WIDTH="50%" CELLPADDING="4" CELLSPACING="3"> <TR> <TH COLSPAN="6"><BR><H3>Company Comparison</H3> </TH> </TR> <TR> <TH><font color="red"><b>Company</B></font></TH> <TH><font color="red"><b>Slots</B></font></TH> <TH><font color="red"><b>Monthly</B></font></TH> <TH><font color="red"><b>Quartly</B></font></TH> <TH><font color="red"><b>Semi-Annual</B></font></TH> <TH><font color="red"><b>Choose</B></font></TH> </TR> <TR ALIGN="CENTER"> <TD>Data 1</TD> <TD>Data 2</TD> <TD>Data 3</TD> <TD>Data 2</TD> <TD>Data 3</TD> <td><a href="#">Select</a></td> </TR> what i'm stuck on is what code I put into the process to send to the db.. "here is what individual wants"... and DB to send back .. "here is what I got".. I really appreciate the help!