Одну функцию - mysql_escape_string(), не удалось сконвертировать, т.к. она не поддерживается конвертером. Я попытался вникнуть в тонкости этой функции в мануале PHP, и пролистал интернет, чтобы найти способ ее замены, но, без специального образования, мне, по большей части, не удалось понять прочитанное. Я понимаю, что для многих знатоков языка PHP решение этого вопроса заняло бы несколько минут, но для меня это тупик.
Ниже я прикрепляю скрипт одной из страниц где присутствуют несколько функций mysql, включая mysql_escape_string(). Имея корректный заменяющий код, я смог бы сделать замену устаревших функций и на других страницах. Пожалуйста помогите! Спасибо!
PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?PHP
- //if a session does not yet exist for this user, start one
- //if there is no username or password entered and the user has not already been validated, send user back to login page.
- {
- }
- include ("../body_edit.php");
- include ("../config.php");
- include ("../functions.php");
- //make sure user has been logged in.
- {
- // User not logged in, check database
- //Check to see that the username and Password entered have admin access.
- $sqlaccess = "SELECT username, passtext
- FROM admin
- LIMIT 1
- ";
- if ($numaccess == 0) {
- BodyHeader("Access Not Allowed!");
- ?>
- <style type="text/css">
- <!--
- .style1 {color: #FF0000}
- .style2 {
- font-family: Arial, Helvetica, sans-serif;
- font-size: 12px;
- }
- .style3 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; }
- -->
- </style>
- <P>To access the Administration area you need to have approved access. The username and Password (<?PHP echo "$admin_username and $admin_passtext"; ?>) you entered are not approved!<br>
- <a href="index.php">Please try again</a>
- <?PHP
- BodyFooter();
- exit;
- }// if numaccess
- //if the user/pass were valid create a session for the user.
- $_SESSION['admin_passtext'] = $_POST['admin_passtext'];
- $_SESSION['admin_username'] = $_POST['admin_username'];
- //since user has been verified, set a session for checking on admin pages.
- $_SESSION['valid_user'] = $_POST['admin_username'];
- //set cookie so admin can save login info if logout link is not clicked.
- }//if cookie
- }//if session
- BodyHeader("$sitename Administration Menu");
- //Get the number of reviews that are not approved.
- AND
- review_item_id != '0'")
- $total = $rows["total"];
- //Get the total number of reviews that are approved.
- $totaly = $rows["totaly"];
- //Get the total number of user submitted items that need to be approved.
- $totalitemuser = $rows["totalitemuser"];
- ?>
- <table width="90%" align="center" cellpadding=5 cellspacing=5>
- <TR>
- <TD><div align="center" class="style3">Welcome to the Admin Area <?PHP echo $_SESSION['valid_user']; ?></div>
- <span class="style2"><br>
- <?PHP if ($total >=1) { ?>
- Reviews Awaiting Approval:<span class="style1"><B> <a href=admin_approve1.php?<?PHP echo SID?>><?PHP echo "$total" ?></a></B></span></span> <span class="style2"><br>
- <?PHP } ?>
- <?PHP if ($totalitemuser >=1) { ?>
- Number of User Submitted Items: <span class="style1"><B><a href=admin_approve_item_user.php?<?PHP echo SID?>><?PHP echo "$totalitemuser"; ?></a></B></span><br>
- <?PHP } ?>
- <?PHP if ($totaly >=1) { ?>
- Total Number of Reviews: <span class="style1"><B><?PHP echo "$totaly"; ?></B></span></span>
- <span class="style2">
- <?PHP } ?>
- <BR>
- </span>
- <p class="style2"><strong>Reviews </strong> </p>
- <ul class="style2">
- <li><a href="admin_approve1.php?<?PHP echo SID?>">Approve a Review</a>
- <li><a href="admin_del1.php?<?PHP echo SID?>">Delete a Review</a>
- <li><a href="admin_edit1.php?<?PHP echo SID?>">Edit a Review </a>
- <li><a href="admin_sort.php?<?PHP echo SID?>">Select Display Order within Categories</a> <br>
- <br>
- <li><a href="admin_del_unapp1.php?<?PHP echo SID?>">Delete all Unapproved Reviews<br>
- <br>
- </a><strong>Items</strong>
- <li><a href="admin_add1.php?<?PHP echo SID?>">Add Item for Review</a>
- <li><a href="admin_del_item1.php?<?PHP echo SID?>">Delete Item for Review</a>
- <li><a href="admin_edit_item1.php?<?PHP echo SID?>">Edit Item for Review</a>
- <li><a href="admin_approve_item_user.php?<?PHP echo SID?>">Approve User Submitted Item</a>
- <li><a href="admin_delete_item_user.php?<?PHP echo SID?>">Delete User Submitted Item</a> <br>
- <br>
- <strong>Categories</strong>
- <li> <a href="admin_add_cat.php?<?PHP echo SID?>">Add a Category </a>
- <li><a href="admin_del_cat.php?<?PHP echo SID?>">Delete a Category</a>
- <li><a href="admin_edit_cat1.php?<?PHP echo SID?>">Edit a Category </a>
- <li><a href="admin_sort_cat.php?<?PHP echo SID?>">Set Display Order for Categories </a><br>
- <BR>
- <strong>Miscellaneous</strong>
- <li><a href="../demo.php?<?PHP echo SID?>">View Reviews</a>
- <li><a href="admin_view_recommendations.php?<?PHP echo SID?>">View Recommendations</a>
- <li><a href="admin_pic.php?<?PHP echo SID?>">Submit a picture</a>
- <li><a href="admin_bad_words.php?<?PHP echo SID?>">Bad Word Filter</a>
- <li><a href="admin_change_p.php?<?PHP echo SID?>">Change Admin Password</a>
- <li><a href="../layouts.php?<?PHP echo SID?>">Display Optional Layouts</a><br>
- <br>
- <li><a href="logout.php?<?PHP echo SID?>">Logout</a>
- </ul>
- <span class="style2"><BR>
- <br>
- </span></TD>
- </TR>
- </table>
- <?PHP
- BodyFooter();
- exit;
- ?>