Jump to content

Recommended Posts

Okay first off...

 

This is what I already have done:

HTML Document with all of my data

 

What I need help doing:

I would like to create a check box for each row in my table. That check box will be assigned an ID number in accordance to the row it is in. The id number will be inserted into a table in the database. These ids can later be called on to display in a user profile or to just view the page or to select different check boxes.

 

I want this to be per user via their vBulletin account. I am not looking for someone familiar with vBulletin...

 

The end user will be able to edit this and select more later on. A public display of these pages I want also accessible from the user profile via vBulletin.

 

I know this is quite vague but please feel free to message me about this for any details you would like to know.

 

I am available to show you exactly what I am trying to achieve via the materials I already have complete.

 

I want this to feel more like a web application later on but would like to keep it simple just to get it working to start.

I am only searching for examples or some simple help but I am more than willing to pick up 1 or 2 people to help out on this that will get credit they deserve for this.

I am almost positive that this is a VERY simple project that wont require much at all.

If anyone is capable and would like to join me in this project and possibly make this into a vBulletin Product that would be awesome.

Link to comment
https://forums.phpfreaks.com/topic/205763-very-simple-php-project/
Share on other sites

I see I am getting views here but I would like to know peoples thoughts if any at all. If you come here just to see what its about then please give some type of input. Even if it is just some constructive criticism. I am desperate for help on this and appreciate any input.

Alright.. ill give this one last try to get some help... I will post the exact HTML I am using so you can see what I am trying to achieve.

The entire purpose of this is to allow my members to select which titles they have earned in Call of Duty Modern Warfare 2. They select which ones they have and it will write an ID per selection to the database. This is also per user. I would like for there to be a "private" section where only the user logged in can edit his/her own but also a public one so others can see which titles other users have already earned. I want the login for this to use vBulletin's database information.

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
   <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
   <title>CoD: MW2 Titles and Emblems</title>
   <style TYPE="text/css">
   <!--
      @page { margin: 0.79in }
      P { margin-bottom: 0.08in }
      TD P { margin-bottom: 0in }
      TH P { margin-bottom: 0in }
      H2 { margin-bottom: 0.08in }
      H2.ctl { font-family: "Verdana" }
      A:link { so-language: zxx }
      a { text-decoration:none }
   -->
   </style>
</head>
<body background="images/cloudy.jpeg" LANG="en-US" DIR="LTR">
<p STYLE="margin-bottom: 0in"><A NAME="toc"></A><TABLE DIR="LTR" ALIGN=LEFT WIDTH=100% CELLPADDING=0 CELLSPACING=0>
<table>
<tr>
   <th width="135"><b></b></th>
   <th width="250"><A HREF="titles1.html">1</a><b>|</b><A HREF="titles2.html">2</a><b>|</b><A HREF="titles3.html">3</a><b>|</b><A HREF="titles4.html">4</a><b>|</b><A HREF="titles5.html">5</a><b>|</b><A HREF="titles6.html">6</a><b>|</b><A HREF="titles7.html">7</a><b>|</b><A HREF="titles8.html">8</a><b>|</b><A HREF="titles9.html">9</a><b>|</b><A HREF="titles10.html">10</a><b>|</b><A HREF="titles11.html">11</a><b>|</b><A HREF="titles12.html">12</a><b>|</b><A HREF="titles13.html">13</a><b>|</b><A HREF="titles14.html">14</a><b>|</b><A HREF="titles15.html">15</a><b>|</b><A HREF="titles16.html">16</a><b>|</b><A HREF="titles17.html">17</a><b>|</b><A HREF="titles18.html">18</a><b>|</b><A HREF="titles19.html">19</a><b>|</b><A HREF="titles20.html">20</a><b>|</b><A HREF="titles21.html">21</a><b>|</b><A HREF="titles22.html">22</a>
</tr>
</table>
<table width="100%" cellspacing="0" cellpadding="0" align="center" style="font-size: 85%; table-layout: fixed;">
<tr>
   <th width="225"><b>Needs a spacer here</b></th>
   <th width="225"><b>Needs a spacer here</b></th>
   <th width="225"><b>Needs a spacer here</b></th>
</tr>
   <tr>
      <td>
      data
      <td>
      data
      </td>
      <td>
      data
      </td>
      <td>
      data
      </td>
   </tr>
   <tr>
      <td>
         <P><A HREF="fng.html"><IMG SRC="images/cod6/FNG.png" NAME="graphics1" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_1" name="check_1" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P></p><A HREF="Dish_the_Rock.html"><IMG SRC="images/cod6/Dish_the_Rock.jpg" NAME="graphics10" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_10" name="check_10" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="NBK.html"><IMG SRC="images/cod6/NBK.jpg" NAME="graphics19" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_19" name="check_19" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
   </tr>
   <tr>
      <td>
         <P><A HREF="SSDD.html"><IMG SRC="images/cod6/SSDD.jpg" NAME="graphics2" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_2" name="check_2" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="TeamPlayer.html"><IMG SRC="images/cod6/TeamPlayer.jpg" NAME="graphics11" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_11" name="check_11" class="element checkbox" type="checkbox" value="1" /></p>
      </td>
      <td>
         <P><A HREF="Ghillie_in_the_Mist.html"><IMG SRC="images/cod6/Ghillie_in_the_Mist.jpg" NAME="graphics20" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_20" name="check_20" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
   </tr>
   <tr>
      <td>
         <P><A HREF="Sergeant.html"><IMG SRC="images/cod6/Sergeant.jpg" NAME="graphics3" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_3" name="check_3" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="Sidekick.html"><IMG SRC="images/cod6/Sidekick.jpg" NAME="graphics12" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_12" name="check_12" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="Art_of_Stealth.html"><IMG SRC="images/cod6/Art_of_Stealth.jpg" NAME="graphics21" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_21" name="check_21" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
   </tr>
   <tr>
      <td>
         <P><A HREF="1stSergeant.html"><IMG SRC="images/cod6/1stSergeant.jpg" NAME="graphics4" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_4" name="check_4" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="LoneWolf.html"><IMG SRC="images/cod6/LoneWolf.jpg" NAME="graphics13" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_13" name="check_13" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="Time_on_Target.html"><IMG SRC="images/cod6/Time_on_Target.jpg" NAME="graphics22" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_22" name="check_22" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
   </tr>
   <tr>
      <td>
         <P><A HREF="1stLieutenant.html"><IMG SRC="images/cod6/1stLieutenant.jpg" NAME="graphics5" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_5" name="check_5" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="HairTrigger.html"><IMG SRC="images/cod6/HairTrigger.jpg" NAME="graphics14" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_14" name="check_14" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="PreemptiveStrike.html"><IMG SRC="images/cod6/PreemptiveStrike.jpg" NAME="graphics23" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_23" name="check_23" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
   </tr>
   <tr>
      <td>
         <P><A HREF="Major.html"><IMG SRC="images/cod6/Major.jpg" NAME="graphics6" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_6" name="check_6" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="Sureshot.html"><IMG SRC="images/cod6/Sureshot.jpg" NAME="graphics15" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_15" name="check_15" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="ClusterBomb.html"><IMG SRC="images/cod6/ClusterBomb.jpg" NAME="graphics24" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_24" name="check_24" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
   </tr>
   <tr>
      <td>
         <P><A HREF="General.html"><IMG SRC="images/cod6/General.jpg" NAME="graphics7" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_7" name="check_7" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="FlySwatter.html"><IMG SRC="images/cod6/FlySwatter.jpg" NAME="graphics16" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_16" name="check_16" class="element checkbox" type="checkbox" value="1" /></p>
      </td>
      <td>
         <P><A HREF="LowProfile.html"><IMG SRC="images/cod6/LowProfile.jpg" NAME="graphics25" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_25" name="check_25" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
   </tr>
   <tr>
      <td>
         <P><A HREF="Commander2.html"><IMG SRC="images/cod6/Commander2.jpg" NAME="graphics8" ALIGN=BOTTOM WIDTH=180 HEIGHT=40 BORDER=0></A><input id="check_8" name="check_8" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="CloseSupport.html"><IMG SRC="images/cod6/CloseSupport.jpg" NAME="graphics17" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_17" name="check_17" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="IronLungs.html"><IMG SRC="images/cod6/IronLungs.jpg" NAME="graphics26" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_26" name="check_26" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
   </tr>
   <tr>
      <td>
         <P><A HREF="MW2.html"><IMG SRC="images/cod6/MW2.jpg" NAME="graphics9" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_9" name="check_9" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="Overwatch.html"><IMG SRC="images/cod6/Overwatch.jpg" NAME="graphics18" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_18" name="check_18" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
      <td>
         <P><A HREF="Rival.html"><IMG SRC="images/cod6/Rival.jpg" NAME="graphics27" ALIGN=BOTTOM WIDTH=188 HEIGHT=40 BORDER=0></A><input id="check_27" name="check_27" class="element checkbox" type="checkbox" value="1" /></P>
      </td>
   </tr>
</table>
<P STYLE="margin-bottom: 0in"><br></P>
<table>
<tr>
   <th width="110"><b></b></th>
   <th width="400"><b>Developed by Michael Wolferstieg</b></th>
   <th width="225"><b></b></th>
</tr>
<tr>
   <th width="110"><b></b></th>
   <th width="400"><b>All images belong to Activision/Infiniti Ward</b></th>
   <th width="225"><b></b></th>
</tr>
</table>
</body>
</html>

Read above... it states that I want to use vBulletin's MySQL database and forum platform to access a page i defined in the bbcode code section. The user may select checkboxes next to each image and those checkboxes will write an id to the database upon submission. These can later be called upon to edit or display. I am unsure on how to do any of it. I was looking to recruit someone to be a part of this project with me and give them full credit for the work they do. I know the basics but when it comes to MySQL and also using vBulletin to not only access the page but allow each user to have their own, edit their own, and view other peoples I am lost.

If you're just trying to use select boxes to save data to the database, it's a simple form really ...

 

for example:

 

<form method=post action=nextpage.php>

<input type="checkbox" name="fruit[]" value="apples">Apples<br>

<input type="checkbox" name="fruit[]" value="oranges">Oranges<br><br>

<input type="submit" value="Continue">

</form>

 

on the next page, you'd call your post variable array  $fruit[]:

$fruit=$_POST['fruit'];

 

and then you can store the array into your database.

 

For displaying all the options chosen by the user somewhere else, you can use something like:

 

for ($i=0; $i<count($fruit); $i++) {

        echo( ($i+1) . ") " . $fruit[$i] . "<br>");

};

 

I'm sure there's more to it than that, but that should get you started hopefully.

 

@Jax2 thank you...

 

only thing i need now is the login stuff. You must be logged in on vbulletin in order to access the page.

 

I think i forgot to link you fellas but here is what I have and what I am trying to do.

www.lssclan.net/cod6/

Login is simple if vbulletin uses sessions, which hopefully it does instead of cookies, just figure out what the login session is and use that ...

 

I.e.

 

if (!$SESSION['loggedIn']) {

echo 'You must be <a href=www.yoursite.com/login.php>logged in</a>';

exit;

}

 

Put that at the top of any page where they have to be logged in and it will show them that message until they're logged in.

 

 

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.