从获取数据库记录并显示它们作为不同的值
我一直在练习PHP和放大器; MySQL和此刻的我创建一个简单的数据库管理器。一切工作正常,除了这块code的: http://snipt.org/vCW0
I've been practising php & mysql and at the moment I'm creating a simple database manager. Everything works fine except for this piece of code: http://snipt.org/vCW0
这是什么code是应该做的是让所有从数据库中的结果并显示出来,但同时显示的位置,它应改变位置和球队名称值(这是我插入到数据库的队名使用缩写,例如QB,而不是四分卫,以节省空间)为充分当量(如此GBA应该显示为绿湾包装工队等)(并在最后一个形式添加新条目) 。实际上,它正确地显示他们,但是当我添加一个新的球员数据库,我收到以下错误:
What this code is supposed to do is to get all the results from the database and display them, except while showing the position and the team name it should change position and team name values (which I insert into the database using abbreviations, e.g. 'qb' instead of 'Quarterback' to save the space) into their full equivalents (so 'gba' should display as 'Green Bay Packers', etc.) (and at the end a form for adding new entries). It actually displays them correctly but when I add a new player to the database, I get the following error:
Warning: Illegal string offset 'qb' in C:\web\project2\ranking_nfl.php on line 97
Warning: Illegal string offset 'rb' in C:\web\project2\ranking_nfl.php on line 98
Warning: Illegal string offset 'fb' in C:\web\project2\ranking_nfl.php on line 99
Warning: Illegal string offset 'te' in C:\web\project2\ranking_nfl.php on line 100
Warning: Illegal string offset 'wr' in C:\web\project2\ranking_nfl.php on line 101
Warning: Illegal string offset 'ol' in C:\web\project2\ranking_nfl.php on line 102
Warning: Illegal string offset 'dt' in C:\web\project2\ranking_nfl.php on line 103
Warning: Illegal string offset 'de' in C:\web\project2\ranking_nfl.php on line 104
Warning: Illegal string offset 'mlb' in C:\web\project2\ranking_nfl.php on line 105
Warning: Illegal string offset 'olb' in C:\web\project2\ranking_nfl.php on line 106
Warning: Illegal string offset 'cb' in C:\web\project2\ranking_nfl.php on line 107
Warning: Illegal string offset 's' in C:\web\project2\ranking_nfl.php on line 108
Warning: Illegal string offset 'ret' in C:\web\project2\ranking_nfl.php on line 109
Warning: Illegal string offset 'k' in C:\web\project2\ranking_nfl.php on line 110
Warning: Illegal string offset 'p' in C:\web\project2\ranking_nfl.php on line 111
Warning: Illegal string offset 'ari' in C:\web\project2\ranking_nfl.php on line 116
Warning: Illegal string offset 'atl' in C:\web\project2\ranking_nfl.php on line 117
Warning: Illegal string offset 'bal' in C:\web\project2\ranking_nfl.php on line 118
Warning: Illegal string offset 'buf' in C:\web\project2\ranking_nfl.php on line 119
Warning: Illegal string offset 'car' in C:\web\project2\ranking_nfl.php on line 120
Warning: Illegal string offset 'chi' in C:\web\project2\ranking_nfl.php on line 121
Warning: Illegal string offset 'cin' in C:\web\project2\ranking_nfl.php on line 122
Warning: Illegal string offset 'cle' in C:\web\project2\ranking_nfl.php on line 123
Warning: Illegal string offset 'dal' in C:\web\project2\ranking_nfl.php on line 124
Warning: Illegal string offset 'den' in C:\web\project2\ranking_nfl.php on line 125
Warning: Illegal string offset 'det' in C:\web\project2\ranking_nfl.php on line 126
Warning: Illegal string offset 'gba' in C:\web\project2\ranking_nfl.php on line 127
Warning: Illegal string offset 'hou' in C:\web\project2\ranking_nfl.php on line 128
Warning: Illegal string offset 'ind' in C:\web\project2\ranking_nfl.php on line 129
Warning: Illegal string offset 'jax' in C:\web\project2\ranking_nfl.php on line 130
Warning: Illegal string offset 'kan' in C:\web\project2\ranking_nfl.php on line 131
Warning: Illegal string offset 'mia' in C:\web\project2\ranking_nfl.php on line 132
Warning: Illegal string offset 'min' in C:\web\project2\ranking_nfl.php on line 133
Warning: Illegal string offset 'nen' in C:\web\project2\ranking_nfl.php on line 134
Warning: Illegal string offset 'nor' in C:\web\project2\ranking_nfl.php on line 135
Warning: Illegal string offset 'nyg' in C:\web\project2\ranking_nfl.php on line 136
Warning: Illegal string offset 'nyj' in C:\web\project2\ranking_nfl.php on line 137
Warning: Illegal string offset 'oak' in C:\web\project2\ranking_nfl.php on line 138
Warning: Illegal string offset 'phi' in C:\web\project2\ranking_nfl.php on line 139
Warning: Illegal string offset 'pit' in C:\web\project2\ranking_nfl.php on line 140
Warning: Illegal string offset 'sdg' in C:\web\project2\ranking_nfl.php on line 141
Warning: Illegal string offset 'sfr' in C:\web\project2\ranking_nfl.php on line 142
Warning: Illegal string offset 'sea' in C:\web\project2\ranking_nfl.php on line 143
Warning: Illegal string offset 'stl' in C:\web\project2\ranking_nfl.php on line 144
Warning: Illegal string offset 'tam' in C:\web\project2\ranking_nfl.php on line 145
Warning: Illegal string offset 'ten' in C:\web\project2\ranking_nfl.php on line 146
Warning: Illegal string offset 'was' in C:\web\project2\ranking_nfl.php on line 147
Warning: Illegal string offset 'gba' in C:\web\project2\ranking_nfl.php on line 153
Warning: Illegal string offset 'qb' in C:\web\project2\ranking_nfl.php on line 154
然而,尽管错误的记录添加到数据库中,并在网页上显示。删除记录不显示任何错误。
However, despite the error the record is added to the database and shown on the page. Deleting records doesn't show any errors.
下面是完整的code: http://snipt.org/vCV8
Here is the full code: http://snipt.org/vCV8
感谢。
在谈到您的code 的http:// snipt.org/vCV8
Referring to your code at http://snipt.org/vCV8
尝试前行#加入这一说法97
try adding this statement before line # 97
$position = array();
和前行#添加此语句116
and add this statement before line # 116
$team = array();