Untitled Document

{"draftJsState":{"blocks":[{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"3p62d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"8res1"},{"data":{},"depth":0,"entityRanges":[{"key":0,"length":5,"offset":17}],"inlineStyleRanges":[],"text":" Был хороший сайт Анны Котельниковой .Были там замечательные статьи","type":"unstyled","key":"2k03c"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"о том как создавать базу данных , как добавлять информацию в базу , как изменить информацию через свой сайт итд. ","type":"unstyled","key":"f5o56"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"К сожалению что-то там изменилось и теперь ссылки ведут на какой-то другой сайт. ","type":"unstyled","key":"3jllt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"У меня сохранились эти программы адаптированные на Mysqli.","type":"unstyled","key":"93obc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":6,"offset":61,"style":"BOLD"}],"text":"В первую очередь создаём базу данных на phpMyadmin и назовём new_db.","type":"unstyled","key":"br9gt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":5,"offset":44,"style":"BOLD"}],"text":"Там создаём таблицу из 5 столбцов и назовём users .","type":"unstyled","key":"4vsl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Столбцы назовём : ","type":"unstyled","key":"6ujsv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":2,"offset":3,"style":"BOLD"}],"text":"1) id,(int ,auto increment)","type":"unstyled","key":"a16i9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":11,"offset":2,"style":"BOLD"}],"text":"2)first_name,","type":"unstyled","key":"32hgn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":9,"offset":2,"style":"BOLD"}],"text":"3)last_name,","type":"unstyled","key":"5bb9l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":5,"offset":2,"style":"BOLD"}],"text":"4)email,","type":"unstyled","key":"agbi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":8,"offset":2,"style":"BOLD"}],"text":"5)facebook","type":"unstyled","key":"1kjc9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":5,"offset":31,"style":"BOLD"}],"text":"Задаём пароль (в данном случае 12345). Вносим данные первого пользователя с правами администратора (в данном примере Anna Kotelnikova).","type":"unstyled","key":"ba67r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":6,"offset":8,"style":"BOLD"},{"length":3,"offset":36,"style":"BOLD"}],"text":"В папке htdocs(xampp) создаём папку db1. В этой папке создаём ещё одну папку ","type":"unstyled","key":"604gp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":7,"offset":10,"style":"BOLD"},{"length":14,"offset":42,"style":"ITALIC"}],"text":"и назовём scripts , туда помещаем файлы : connect.php , form.php, update.php .","type":"unstyled","key":"6uapv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":4,"offset":27,"style":"BOLD"}],"text":"Остальные файлы все в папке db1 .","type":"unstyled","key":"82t93"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вот работающие на XAMPP коды . ","type":"unstyled","key":"496j4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":11,"offset":0,"style":"ITALIC"}],"text":"connect.php :","type":"header-three","key":"3l5t8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":190,"offset":0,"style":"ITALIC"}],"text":"","type":"unstyled","key":"80e7g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"form.php:","type":"header-three","key":"ec0pf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":966,"offset":0,"style":"ITALIC"}],"text":"\n\n\n\nUntitled Document\n\n\nНовая запись вставлена в базу!

\";\n?>\n\n\n","type":"ordered-list-item","key":"8tui9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":16,"offset":0,"style":"ITALIC"}],"text":"select_user.php\n","type":"header-three","key":"2kg4q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":1099,"offset":0,"style":"ITALIC"}],"text":"\n\n\n\n\n\nSelected User\n\n\n\n\nПользователь: \" .$row['first_name'] . \" \" .$row['last_name'] .\"

Контактные данные :

E-mail: \" .$row['email'] . \"

Facebook: \" .$row['facebook'] . \"

-------------------------------------------------------
\"\n );\n}\nelse{echo (\"Пользователя с таким именем в базе нет

\");}\n ?>\n\n\nВернуться к поиску

\nДобавить пользователя
\nРедактировать запись базы данных
\n\n","type":"unstyled","key":"624cu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":8,"offset":0,"style":"ITALIC"}],"text":"edit.php","type":"header-three","key":"2g37n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":1411,"offset":0,"style":"ITALIC"}],"text":"\n\n\n\n\nВносим изменеиния\n\n\n\n

\n
\nИмя:
\n
\nФамилия:
\n
\nEmail:
\n
\nFacebook
\n\n

\n
\n

\n\",$row['id'], $row['first_name'], $row['last_name'], $row['email'], $row['facebook']);\n?>\n\nДобавить пользователя

\nВернуться к поиску

\nВернуться к выбору записей для редактирования

\n\n","type":"unstyled","key":"74dcr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":13,"offset":0,"style":"ITALIC"}],"text":"all-users.php","type":"header-three","key":"du7qs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\n\n\n\n\nSelected User\n\n\nПользователь: \" .$row['first_name'] . \" \" .$row['last_name'] .\"

\n\t

Контактные данные

E-mail: \" .$row['email'] . \"

Facebook: \" .$row['facebook'] . \"

---------
\"\n\t);\n}\nwhile($row = mysqli_fetch_array($result));\n ?>\nВернуться к поиску

\nДобавить пользователя\n\n","type":"unstyled","key":"k4qi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"select_change.php","type":"header-three","key":"ah45k"},{"data":{},"depth":0,"entityRanges":[{"key":1,"length":1,"offset":0}],"inlineStyleRanges":[{"length":892,"offset":1,"style":"ITALIC"}],"text":" \n\n\n\n\nВыбор пользователя для редактирования.\n\n\n\nДобавить пользователя

\nВернуться к поиску

\n\n","type":"unstyled","key":"dvb3d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":14,"offset":0,"style":"ITALIC"}],"text":"info_form.html","type":"header-three","key":"8ur2j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"8ggie"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"9p8f7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"6vmp7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"bqn9t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"akah2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Untitled Document","type":"unstyled","key":"dii57"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"fqhor"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"f0dfo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"

","type":"unstyled","key":"evpo0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"

","type":"unstyled","key":"2kv8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Имя:
","type":"unstyled","key":"bhqte"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"
","type":"unstyled","key":"4mbhk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Фамилия:
","type":"unstyled","key":"4hub8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"
","type":"unstyled","key":"8cdcp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Email:
","type":"unstyled","key":"cjjos"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"
","type":"unstyled","key":"8n1f5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Facebook
","type":"unstyled","key":"8l3in"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"vr5t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"

","type":"unstyled","key":"3prde"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"
","type":"unstyled","key":"5k6in"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"

","type":"unstyled","key":"ekfeh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"
","type":"unstyled","key":"ifbd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"

","type":"unstyled","key":"dpon4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"

","type":"unstyled","key":"f1ruo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вернуться к поиску

","type":"unstyled","key":"dl5r8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Добавить пользователя
","type":"unstyled","key":"dvcpi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Редактировать запись базы данных
","type":"unstyled","key":"78sqg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"e6ooj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"search_user.html","type":"header-three","key":"6gi0t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"a4si8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"1t67h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"dn2uh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"7nnic"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"найти пользователя","type":"unstyled","key":"6ki0i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"9l283"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"d92gv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"f050b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"

","type":"unstyled","key":"ejap8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"

","type":"unstyled","key":"bq3q0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"7dccd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"все пользователи
","type":"unstyled","key":"8nuhc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Редактировать запись базы данных
","type":"unstyled","key":"4mjie"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"4opnj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"update.php","type":"unstyled","key":"e3efi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"8o064"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"3e3to"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"an429"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"update ","type":"unstyled","key":"86bd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"eamih"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"epr22"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"5uauo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"79l4m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"a5epi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"6dope"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"style.css","type":"header-three","key":"ccll9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"body{width:400px; margin:0 auto; background:#F8F4B6;}","type":"unstyled","key":"5uhf1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"label{display: block; float: left; width: 150px;","type":"unstyled","key":"8br2j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"padding: 0 10px; margin: 18px 0 0; text-align: right;}","type":"unstyled","key":"a02do"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"submit{float:right; margin:5px 50px 10px 0;}","type":"unstyled","key":"bhmsg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"7rf2u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":8,"offset":39,"style":"BOLD"}],"text":" Здесь только коды которые работают на xampp .","type":"unstyled","key":"b2daq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"При работе с базами данных MySql возникает проблема с кодировками , ","type":"unstyled","key":"f7ds6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"вместо кириллицы появляются какие то непонятные символы , как говорят кракозябры . Я это исправил таким образом : во первых везде в программах проставил кодировку utf-8 , когда создавал базу данных и таблицы -utf8_general_ci (как все рекомендуют). Но на этом ещё не всё , при просмотре таблиц через phpMyAdmin чтобы кириллица правильно отображалась включил строку на config .my.ini (убрал символ решётки ) как на этих скриншотах ","type":"unstyled","key":"1j51u"},{"data":{"image":{"id":"6161c793f6ca423b251e9506"}},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"atomic:image","key":"cdps7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"На панели управления xampp нажимаем кнопку Config затем my.ini , находим раздел UTF 8 settings и убираем решётки как на скриншоте ниже . ","type":"unstyled","key":"4mt9h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"мне кажется другие одинарные тоже можно убрать , но пока не проверял . ","type":"unstyled","key":"935tl"},{"data":{"image":{"id":"6161c995f6ca423b252136af"}},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"atomic:image","key":"bnk3e"},{"data":{},"depth":0,"entityRanges":[{"key":2,"length":21,"offset":31}],"inlineStyleRanges":[],"text":"Продолжение можете найти здесь https://zen.me/1tyZIu .","type":"unstyled","key":"ams4s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Удачи !","type":"unstyled","key":"9tiv8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"7jnf0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"e0pk2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"7t6l2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"f0r2j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"marker","key":"7EfJTQ2dFwjLjHL3uQQ9"}],"entityMap":{"0":{"data":{"url":"https://t100.ucoz.com/vnosim_polzovatelskie_dannye_v_bazu_dannykh_mysql.html#"},"mutability":"MUTABLE","type":"LINK"},"1":{"data":{"url":"https://gmukhamatr.000webhostapp.com/MySqlconnect/Mysql%20codes"},"mutability":"MUTABLE","type":"LINK"},"2":{"data":{"url":"https://zen.me/1tyZIu"},"mutability":"MUTABLE","type":"LINK"}}},"mentions":[]}