obey-robots.txt
View Thread
pHp-Fusion.Org | Open Source PHP + MySQL Powered Website » PHP-Fusion v7 Modifications » Modifications to forum index.php
Post your improvements and modifications to forum index.php here.
 Print Thread
php help
afoster
Top  #1 Print Post
Posted on 21-03-2018 17:51
I did not see a forum category that would allow me to post this so I am adding it here. First of all...this is not php-fusion related and just looking for some help. I am trying to pull information from a file and have it displayed in two columns except that I want the first piece of data in the first column, then the next one in the second column and the next one in the first column again, etc. I have looked everywhere and can't find any sample code that will allow me to do this and hope that you can help. I've got it displaying in one column already but want it in two columns. This data is being updated dynamically and the display would also be displayed dynamically.

Any help would be much appreciated.
 
Fusioneer
Top  #2 Print Post
Posted on 21-03-2018 20:59
Can you post your php code?
How is the data in the file separated?
Warning about ParkingCrew.com! Case: ParkingCrew.com acquires NameDrive.com but earnings are not transferred despite assurances and promises. Inquiries about this are ignored! It's just a con compagny. Don't do business with them!
 
afoster
Top  #3 Print Post
Posted on 21-03-2018 21:29
Here is the code I am using:

Download source  GeSHi: PHP
  1. <?php
  2. $team[0] = "Kansas St";
  3. $team[4] = "Kentucky";
  4. $team[8] = "Loyola, Chi";
  5. $team[12] = "Nevada";
  6. $team[16] = "Florida St";
  7. $team[20] = "Gonzaga";
  8. $team[24] = "Michigan";
  9. $team[28] = "Texas AM";
  10. $team[32] = "Villanova";
  11. $team[36] = "W. Virginia";
  12. $team[40] = "Texas Tech";
  13. $team[44] = "Purdue";
  14. $team[48] = "Kansas";
  15. $team[52] = "Clemson";
  16. $team[56] = "ASU/Syr";
  17. $team[60] = "Duke";
  18. // Change this file to match your tournament picks file
  19. $file = "playerpicks18_sw16.ttw";
  20. echo "<body bgcolor=#e3e3e3>";
  21. echo "<center>";
  22. //echo "<font size=4 color=#ff0000 face=tahoma><b>Tournament Tracker 2018 - Sweet 16  " ;
  23. //echo "";
  24. if (file_exists($file)) {
  25.    $data = file_get_contents($file);
  26.    $num = preg_match_all("/PLAYERID=(.*),PLAYERINFO1=(.*),PLAYERINFO2=(.*),PLAYERINFO3=(.*),PLAYERINFO4=(.*),PLAYERINFO5=(.*),G1=.*,G15=(.*),TIEBREAKER=(.*),PLAYERCOMMENT=(.*),SUBMITTED=(.*),TIMESTAMP=(.*)/i", $data, $matches);
  27.    echo "<font size=2 color=#000000><b>Total Number Of Submitted Player Picks: $num</b> ";
  28.    //echo $num, "";
  29.    echo "<div align=center>";
  30.    echo "<center>";
  31.    echo "<table border=0 cellpadding=0 cellspacing=0><tr><td valign=top>";
  32.    echo "<table border=1 cellpadding=2 cellspacing=1 bgcolor=#ffffff><tr>";
  33.    echo "<td align=center><b>Player</b></td>";
  34.    echo "<td align=center><b>Champion</b></td>";
  35.    echo "<td align=center><b>Tiebreaker</b></td>";
  36.    echo "<td align=center><b>Submitted&nbsp</b></td></tr>";
  37.    for ($i=0; $i<$num /2; $i++) {
  38.       echo "<tr>";
  39.       echo "<td align=left>" . $matches[1][$i] . "</td>";
  40.       echo "<td align=left>" . $team[$matches[7][$i]] . "</td>";
  41.       echo "<td align=center>" . $matches[8][$i] . "</td>";
  42.       echo "<td align=left>" . $matches[11][$i] . "</td>";
  43.       echo "</tr>";
  44. }
  45.       echo "</table>";
  46.       echo "</td><td valign=top align=center width=15></td><td valign=top>";
  47.       echo "<table border=1 cellpadding=2 cellspacing=1 bgcolor=#ffffff><tr>";
  48.    echo "<td align=center><b>Player</b></td>";
  49.    echo "<td align=center><b>Champion</b></td>";
  50.    echo "<td align=center><b>Tiebreaker</b></td>";
  51.    echo "<td align=center><b>Submitted&nbsp</b></td></tr>";
  52.    for ($i=6; $i<$num; $i++) {
  53.       echo "<tr>";
  54.       echo "<td align=left>" . $matches[1][$i] . "</td>";
  55.       echo "<td align=left>" . $team[$matches[7][$i]] . "</td>";
  56.       echo "<td align=center>" . $matches[8][$i] . "</td>";
  57.       echo "<td align=left>" . $matches[11][$i] . "</td>";
  58.    }
  59.    echo "</tr></table>";
  60.    echo "</td></tr></table>";
  61.    echo "</center>";
  62.    echo "</div>";
  63. }else{
  64.    echo "<h3><font size=4>There are no entries at this time : (</h3></center>";
  65. }
  66. ?>
Parsed in 0.100 seconds, using GeSHi 1.0.8.10


The file that it is pulling from is the attachethis. (It would not let me attach the file.

Code Download source  

SECTION=HEADER

TITLE=TURBO TOURNEY PRO WEB WIZARD

VERSION=2005

POOLSIZE=16

POOLTYPE=3

TEAMSIZE=16

QUADRANT1=South

QUADRANT2=West

QUADRANT3=East

QUADRANT4=Midwest

INCLUDETIES=Y

PLAYERIDLAB=Name First, L

PLAYERINFO1LAB=Phone Number

PLAYERINFO1INC=N

PLAYERINFO1REQ=N

PLAYERINFO2LAB=Fax Number

PLAYERINFO2INC=N

PLAYERINFO2REQ=N

PLAYERINFO3LAB=E-Mail Address

PLAYERINFO3INC=Y

PLAYERINFO3REQ=Y

PLAYERINFO4LAB=Hamby

PLAYERINFO4INC=N

PLAYERINFO4REQ=N

PLAYERINFO5LAB=Hilton

PLAYERINFO5INC=N

PLAYERINFO5REQ=N

SECTION=DATA

PLAYERID=Bobby D,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@msn.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=12,G3=20,G4=28,G5=32,G6=40,G7=48,G8=60,G9=4,G10=20,G11=32,G12=48,G13=4,G14=48,G15=48,TIEBREAKER=105,PLAYERCOMMENT=,SUBMITTED=3/19/2018 11:51:39,TIMESTAMP=Mon Mar 19 11:51:39 2018

PLAYERID=Shary W,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@sbcglobal.net,PLAYERINFO4=D,PLAYERINFO5=D,G1=0,G2=12,G3=16,G4=24,G5=32,G6=44,G7=52,G8=60,G9=0,G10=24,G11=44,G12=60,G13=0,G14=44,G15=44,TIEBREAKER=201,PLAYERCOMMENT=,SUBMITTED=3/19/2018 12:34:14,TIMESTAMP=Mon Mar 19 12:34:14 2018

PLAYERID=Tom O,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@gmail.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=12,G3=20,G4=24,G5=32,G6=44,G7=52,G8=60,G9=12,G10=20,G11=32,G12=60,G13=20,G14=60,G15=60,TIEBREAKER=144,PLAYERCOMMENT=,SUBMITTED=3/19/2018 13:36:38,TIMESTAMP=Mon Mar 19 13:36:38 2018

PLAYERID=Marty B,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@aol.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=12,G3=20,G4=24,G5=32,G6=40,G7=48,G8=60,G9=4,G10=20,G11=32,G12=48,G13=20,G14=32,G15=32,TIEBREAKER=145,PLAYERCOMMENT=,SUBMITTED=3/19/2018 15:26:1,TIMESTAMP=Mon Mar 19 15:26:01 2018

PLAYERID=Alan B,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@gmail.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=12,G3=16,G4=24,G5=32,G6=40,G7=48,G8=60,G9=4,G10=24,G11=32,G12=60,G13=4,G14=60,G15=60,TIEBREAKER=137,PLAYERCOMMENT=,SUBMITTED=3/19/2018 20:15:36,TIMESTAMP=Mon Mar 19 20:15:36 2018

PLAYERID=Sara B,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1_1@yahoo.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=12,G3=20,G4=24,G5=32,G6=44,G7=48,G8=60,G9=4,G10=20,G11=32,G12=60,G13=4,G14=32,G15=32,TIEBREAKER=163,PLAYERCOMMENT=,SUBMITTED=3/20/2018 0:14:51,TIMESTAMP=Tue Mar 20 00:14:51 2018

PLAYERID=Rick T,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@comcast.net,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=8,G3=20,G4=24,G5=32,G6=40,G7=48,G8=60,G9=4,G10=20,G11=32,G12=48,G13=20,G14=32,G15=20,TIEBREAKER=172,PLAYERCOMMENT=,SUBMITTED=3/20/2018 1:40:40,TIMESTAMP=Tue Mar 20 01:40:40 2018

PLAYERID=Ger-Shine,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@pacbell.net,PLAYERINFO4=D,PLAYERINFO5=D,G1=0,G2=12,G3=20,G4=24,G5=32,G6=44,G7=48,G8=60,G9=0,G10=20,G11=32,G12=48,G13=20,G14=32,G15=32,TIEBREAKER=159,PLAYERCOMMENT=,SUBMITTED=3/20/2018 9:17:21,TIMESTAMP=Tue Mar 20 09:17:21 2018

PLAYERID=Jayce D,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@gmail.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=8,G3=20,G4=28,G5=32,G6=40,G7=48,G8=60,G9=4,G10=20,G11=40,G12=60,G13=20,G14=60,G15=20,TIEBREAKER=135,PLAYERCOMMENT=,SUBMITTED=3/20/2018 10:13:30,TIMESTAMP=Tue Mar 20 10:13:30 2018

PLAYERID=Brian B,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@yahoo.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=8,G3=20,G4=24,G5=32,G6=44,G7=48,G8=60,G9=4,G10=20,G11=32,G12=60,G13=20,G14=32,G15=32,TIEBREAKER=156,PLAYERCOMMENT=,SUBMITTED=3/20/2018 14:30:26,TIMESTAMP=Tue Mar 20 14:30:26 2018

PLAYERID=Mike D,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@yahoo.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=12,G3=20,G4=28,G5=32,G6=40,G7=48,G8=60,G9=4,G10=20,G11=32,G12=60,G13=4,G14=32,G15=32,TIEBREAKER=141,PLAYERCOMMENT=,SUBMITTED=3/20/2018 16:9:28,TIMESTAMP=Tue Mar 20 16:09:28 2018

PLAYERID=Chris R,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@yahoo.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=12,G3=20,G4=24,G5=32,G6=44,G7=48,G8=60,G9=4,G10=24,G11=32,G12=60,G13=4,G14=60,G15=60,TIEBREAKER=134,PLAYERCOMMENT=,SUBMITTED=3/20/2018 20:17:37,TIMESTAMP=Tue Mar 20 20:17:37 2018

PLAYERID=Denise C,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@gmail.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=8,G3=20,G4=28,G5=32,G6=44,G7=48,G8=60,G9=4,G10=20,G11=32,G12=48,G13=4,G14=32,G15=32,TIEBREAKER=152,PLAYERCOMMENT=,SUBMITTED=3/20/2018 22:12:55,TIMESTAMP=Tue Mar 20 22:12:55 2018

PLAYERID=Alex M,PLAYERINFO1=,PLAYERINFO2=,PLAYERINFO3=1@aol.com,PLAYERINFO4=D,PLAYERINFO5=D,G1=4,G2=12,G3=16,G4=24,G5=32,G6=44,G7=48,G8=60,G9=4,G10=24,G11=32,G12=60,G13=24,G14=60,G15=60,TIEBREAKER=137,PLAYERCOMMENT=,SUBMITTED=3/20/2018 22:34:8,TIMESTAMP=Tue Mar 20 22:34:08 2018
Edited by Fusioneer on 22-03-2018 21:32
 
afoster
Top  #4 Print Post
Posted on 21-03-2018 21:31
The last post is the one you need to look at...disregard the first two responses.
 
Fusioneer
Top  #5 Print Post
Posted on 22-03-2018 21:36
Cleaned up this thread a bit and removed the email addresses from your data.

I've added your code to a panel and is displayed at the front page at the bottom.

Can you describe what you want?
Warning about ParkingCrew.com! Case: ParkingCrew.com acquires NameDrive.com but earnings are not transferred despite assurances and promises. Inquiries about this are ignored! It's just a con compagny. Don't do business with them!
 
afoster
Top  #6 Print Post
Posted on 22-03-2018 22:36
The panel that you have added is pretty much what I want except that as you can see, it is duplicating some of the information. As an example, the information for Rick T is displayed as the last entry in column one and the first entry in column 2. This information would be dynamically updated as the players submit their information and what I want is for the first player to submit his info to appear in column one, the second player to submit his info displayed in column two, the third player to submit his info back in column one and etc. That is what I have been struggling with.
 
afoster
Top  #7 Print Post
Posted on 23-03-2018 14:58
A friend of mine figured out how to do it dynamically. The change is in the second column code as follows:

for ($x=$i; $x<$num; $x++) { (line 85 of the file)

This line replaces the line that showed:

for ($i=22; $i<$num; $i++) { (line 100 of the file)

Thanks Fusioneer for your help.
 
afoster
Top  #8 Print Post
Posted on 11-02-2019 22:36
Revisiting this post again. I would like to pull data from an mysql table and place it in 3 columns, very similar to the data being pulled from a txt file as noted in this thread. Here is the code I am using and it is working as except it is placing the data into 2 columns instead of three. Any assistance would be much appreciated. This is not a php-fusion related issue although some of the code you see is fusion related.

Code Download source  


$servername = "localhost";

$username = "sfsxatjg_tjb";

$password = "T2*1OH(99.L";

$dbname = "sfsxatjg_test7";



// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);

}

require_once "maincore.php";

$result = dbquery("SELECT user_name, total, paid, Won FROM ".fusion_players." WHERE Won>0 ORDER BY Won DESC");

$rows = dbrows($result);



echo "";

echo "
";

echo "Pool Tracker 2018" ;

echo "

";



   echo "Total Number Of Submitted Player Picks: $rows

";

   echo "
";

   echo "
";

   echo "
";

   echo "";

   echo "";

   echo "";

   echo "";

   echo "";

   $numrows = $rows;

   if($numrows > 0) {

   $numrows % 2  ? $numrows += 1 : $numrows;

   $rows = $numrows / 2;

$result = dbquery("SELECT user_name, total, paid, Won FROM ".fusion_players." WHERE Won>0 ORDER BY Won DESC LIMIT $rows");

while ($data = dbarray($result)) {


   $user = $data['user_name'];

   $total = $data['total'];

   $paid = $data['paid'];

   $won = $data['Won'];


      echo "";

      echo "";

      echo "";

      echo "";

      echo "";

      echo "";

}

      echo "
PlayerTotalPaidWon



" . $user . "" . $total . "" . $paid . "" . $won . "
";

      echo "		";

      echo "";

   echo "";

   echo "";

   echo "";

   echo "";


$result = dbquery("SELECT user_name, total, paid, Won FROM ".fusion_players." WHERE Won>0 ORDER BY Won DESC LIMIT $rows, $rows");

while ($data = dbarray($result)) {


   $user = $data['user_name'];

   $total = $data['total'];

   $paid = $data['paid'];

   $won = $data['Won'];


      echo "";

      echo "";

      echo "";

      echo "";

      echo "";

      echo "";

   }

}

   echo "
PlayerTotalPaidWon




" . $user . "" . $total . "" . $paid . "" . $won . "
";

   echo "
";

   echo "
";

?>
 
afoster
Top  #9 Print Post
Posted on 27-02-2019 18:47
Never mind...I got to work.
 
Thomasoa
Top  #10 Print Post
Posted on 22-04-2024 22:26
Shea Carpenter from Appleton was looking for gdp calculation essay

Akeem Lewis found the answer to a search query gdp calculation essay


ESSAYERUDITE.COM


500x500


gdp calculation essay










comparison contrast essay example topics
current graduate student resume sample
school essay editing website uk
example of cover letter for cleaner job
thesis statement on maslow theory hieararchy
how to write friend in kanji
when writing a paper do you italicize quotes
oedipus essays on suffering
essay about snowboarding
custom scholarship essay proofreading websites for phd
phd writing websites au
exemple introduction dissertation histoire du droit
popular scholarship essay ghostwriters services for phd
quest online homework
help with scholarship essay on hacking
describing restaurants essay
format of a dissertation abstract
rosa lee leon dash essay
apa research paper checklist
sixth grade math problems
graduate students resume examples
narratives essay
cover letter for photographer position
long quotes in essay
essays my mother my role model
fresher resume formats free
sample resume for coffee maker
essay sample for applying job
cheap masters argumentative essay examples
popular university essay ghostwriter service for school
how to write a 16 bar verse
top masters essay ghostwriters sites for phd
best dissertation conclusion writing website for masters
top school bibliography topics
traditional chronological resume sample
database coursework
personality essays psychology
new grad rn resume tips
summer camp experience essay
sample resume for packer job
custom term paper ghostwriting sites au
critical essay horror movies
using unnecessary pronouns homework help free
how to write a erotic letter
best essay proofreading service for phd
white collar employees resume problems
nurse cover letter samples
book thief essay topics
college paper world
buy argumentative essay on founding fathers
esl literature review proofreading services
how to write wedding invitation wording
mba thesis proposal pdf
best paper editor sites
key skills marketing resume
fathers day contest essay
modified resume
b tech ece fresher resume
popular cover letter editor website online
cheap argumentative essay writer sites us
example essay on persuasive writing
nursing school essay
creative writing editing websites us
sample cover letter rn residency program
professional application letter ghostwriting website ca
resume for coaching soccer
best masters essay editor for hire for mba
popular presentation writer websites for masters
pay to get popular argumentative essay online
cheap argumentative essay proofreading site for school
how to write nursing notes examples
custom expository essay ghostwriting site for university

apa format annotated bibliography title page
essay on international relations theories
esl dissertation proposal ghostwriter websites for mba
sample business plan for a bar and restaurant
resume for biotechnology
can\'t do my homework
essay about overprotective parents
popular university essay writing sites uk
do my investments paper
 
https://essayerudite.com
Jump to Forum
New Thread Post Reply
Use BBcode or HTML to refer to; 'php help'
BBcode:
HTML: