Week 10

Notes 10

  • mysqli
  • connect
  • close
  • query
  • fetch_row, fetch_assoc, fetch_array(____) [MYSQLI_NUM,MYSQLI_ASSOC,MYSQLI_BOTH]
  • SQL Injection part 1
  • prepared statements
  • prepare
  • bind_param
  • execute
  • get_result
  • bind_result
  • store_result

Useful DB Stuff

  • unix$ mysqldump -p db_name > db_backup.sql database backup
  • unix$ mysqldump -p db_name tb_name > table_backup.sql table backup
  • unix$ mysql -p -Ddb_name < SQLtoExec.sql run sql outside of client
  • unix$ mysql -p -Ddb_name < table_backup.sqlrestore table/data

  • MariaDB>source ./SQLtoExec.sql exec sql from file
  • MariaDB>describe Table\G   (\G) vertical output
  • MariaDB>SELECT * FROM Table\G   (\G) vertical output