从获取数据库记录并显示它们作为不同的值 [英] Fetching records from database and displaying them as different values

问题描述

我一直在练习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();

这篇关于从获取数据库记录并显示它们作为不同的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！