Jump to content
Stef's Coding Community
  • Member Statistics

    36,618
    Total Members
    3,995
    Most Online
    North34
    Newest Member
    North34
    Joined
  1. Community Lounge and FAQ

    1. Forum News

      General news about what we are doing around here.

      156
      posts
    2. Open Forum

      The place to talk about your cat, favorite coffee ... anything really!?It's the OPEN forum after all!?:D

      3.7k
      posts
    3. New Members Forum - Start Here!

      New Member Help Forum - Read this First!!

      353
      posts
  2. StudioWeb

    1. StudioWeb

      StudioWeb is the most advanced code training platform out there today. Since 2011, StudioWeb has taught well over 1 million students real-world coding and programming. We currently offer?career oriented courses in the following in demand languages:

      • HTML5
      • CSS3
      • JavaScript
      • Python 3
      • PHP 7
      • SQL
      232
      posts
    2. 3
      posts
    3. StudioWeb Projects

      Updates and discussions about the StudioWeb project tutorials.

      9
      posts
  3. Programming

    1. Python

      Talk about the Python programming language.

      109
      posts
    2. Javascript

      Javascript, Ajax and jQuery

      1.6k
      posts
    3. 6.1k
      posts
  4. Entrepreneurship, Business and Marketing

    1. Social Media Marketing & Web Marketing

      Talk about promoting on the Web using social media sites like Facebook, twitter, Pinterest and good old email.

      92
      posts
    2. Entrepreneurship

      This forum is about entrepreneurship -?the process of designing, launching and running a new business.?

      46
      posts
    3. Career Questions - Asked and Answered

      I get career questions, every so often, so if you have coding, programming or business related career and freelancing questions, this is the forum!

      32
      posts
  5. Web Design

    1. Beginners Web Design

      No web design question is too simple - for total beginners!?:D

      8.7k
      posts
    2. HTML/XHTML

      Post questions on: HTML and HTML5. Modern web designers don't use XHTML in 2017 ... XHTML retired to Florida in 2012.?;)

      1.4k
      posts
    3. 833
      posts
    4. CSS

      Post questions on: CSS, CSS3, CSS layouts ... anything CSS!?:D

      4.7k
      posts
    5. 1.8k
      posts
    6. 730
      posts
    7. 272
      posts
  6. Miscellaneous

    1. Cybersecurity

      Cyber security, also referred to as information technology security, focuses on protecting computers, networks, programs, and data from unintended or unauthorized access, change, or destruction.

      296
      posts
    2. 285
      posts
    3. Blogs and CMS

      Wordpress, Drupal, CMS Made Simple and others.

      1.1k
      posts
    4. 69
      posts
    5. 1.2k
      posts
    6. 42
      posts
    7. Web Design Jobs

      A place to post full time jobs, contract work or any specific web design and web programming projects where you need to hire a web professional.

      66
      posts
  7. Archives

    1. 167
      posts
    2. 22
      posts
    3. 97
      posts
    4. 466
      posts
    5. CSS

      8
      posts
    6. 7
      posts
    7. 360
      posts
    8. ASP

      91
      posts
    9. General Programming

      This is the place to ask about:

      • FaceBook API
      • Twitter API
      • PayPal API
      • Stripe API

      ... Or whatever else.

      324
      posts
    10. 12
      posts
    11. 195
      posts
    12. Beginners Ruby

      If you are new to Ruby, this is the forum for you. If you are an old Ruby master, then please help!! :)

      9
      posts
    13. 21
      posts
  • Who's Online   0 Members, 0 Anonymous, 38 Guests (See full list)

    There are no registered users currently online

  • Posts

    • Hmm I see But when I try to change the columns to varchar(should it be something else?), then it is not possible to change the primary column. Because then I get an error-box that says: #1063 - Incorrect column specifier for column 'name'. I can only change the other column it seems. So after I changed this column to varchar I now get another type of error. Which says: "Static analysis: 1 errors were found during analysis. Ending quote ' was expected. (near "" at position 44) ? ? SQL query: Copy INSERT INTO people (name) VALUES ('Stefan’); ? ? ? ? MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Stefan’)' at line 1" ?I then tried to change 'Stefan' to "Stefan" since that sometimes works in PHP. But then I got the old message again: ? SQL query: Copy INSERT INTO people (name) VALUES ("Stefan") MySQL said: http://localhost:8080/phpmyadmin/themes/dot.gif #1366 - Incorrect integer value: 'Stefan' for column `DATABAS2`.`people`.`name` at row 1 How do I change the primary column so that it is not Int anymore, since I get an error when I try to do that? And what should it be instead? ? ? ?
    • Hello im getting this error: Fatal error: Uncaught Error: Call to a member function prepare() on null in D:\wamp\www\shop\app\models\m_categories.php on line 35 here is my code for m_categories.php <?php /* Categories Handles all tasks related to retrieving and displaying categories */ class Categories { private $Database; private $db_table='categories'; function __construct() { global $Database; $this->Database=$Database; } /* Settting/Getting categories from database */ /** * Return an array with category information * * @access public * @param int(optional) * @return array */ public function get_categories($id=NULL) { $data=array(); if($id != NULL) { // get specific category if($stmt=$this->Database->prepare("SELECT id, name FROM" . $this->db_table . " WHERE id=? LIMIT 1")) { $stmt->bind_param("i", $id); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($cat_id,$cat_name); $stmt->fetch(); if($stmt->num_rows > 0) { $data=array('id'=>$cat_id, 'name'=>$cat_name); } $stmt->close(); } } else { // get all categories if($result=$this->Database->query("SELECT * FROM" . $this->db_table . "ORDER BY name")) { if($result->num_rows>0) { while($row=$result->fetch_array()) { $data[]=array('id'=>$row['id'], 'name'=>$row['name']); } } } } return $data; } } ?> and init.php <?php /* INIT Basic configuration settings */ // connect to database $server='localhost'; $user='root'; $pass=''; $db='shop'; $database=new mysqli($server,$user,$pass,$db); // error reporting mysqli_report(MYSQLI_REPORT_ERROR); ini_set('display_errors', 1); // setup constants define('SITE_NAME', 'Online Store'); define('SITE_PATH','http://shop/'); define('IMAGE_PATH','http://shop/resources/images/'); // include objects include('app/models/m_template.php'); include('app/models/m_categories.php'); // create objects $template= new Template(); $categories= new Categories(); session_start(); and index.php: <?php include('app/init.php'); echo "<pre>"; print_r($categories->get_categories(3)); echo "</pre>"; /*$template->set_data('header','hello'); $template->set_alert('alert!'); $template->load('app/views/v_public_home.php', 'Welcome!');*/ ?> Thank you in advance.
    • Sounds like you set that field to be of the datatype INT, so when you try to insert a string datatype, you will get that error. Makes sense? Stef
    • It's good you asked as there had been something I couldn't quite put my finger on. I like the overall style and the footer is fine, but after a bright clear start with "Hi there, I'm Ryan Van Dyke" it's black all the way to the footer. It's too much darkness.?I think keeping an eye on the times we live in is a good idea, and there's a lot of darkness and uncertainty in the air right now, and a lighter tone without being in your face?might help to lift the mood. And you've almost got that. Context is important.? I remember the old wild west days of the internet when black websites were in vogue?and in hindsight?they didn't really work,?their message was lost in the gloom and they were unpleasant to read. Perhaps after "About me" in black you can alternate back to the colour scheme you use in the "Hi there..." introduction page for "Services" and "Projects". "About me" in black works well enough because you do want to highlight yourself to sell yourself, but?"Services" and "Projects" feel a bit lost in the black. I'd switch back to the lighter introduction colour scheme to make what you're offering stand out more, oddly having the?continuous black feels like you're only whispering about them. Not that you want to be shouting at people either. So after "About me" move to the light coloured background until the footer but keep your subject boxes in "Services" dark and maybe fill in the "Project" boxes?and?have a lighter shade of what you want the mouseover to reveal to avoid the anonymous empty boxes.?? Hope it helps, Jim. Edit:?On reflection why not be kind to yourself and make the projects one row of 3 instead of 2 rows of 3, you won't feel under so much pressure to fill them all in and you can add more as they come.? ?
    • Hi :) ? So I am doing the PHP and MySQL-course in the studioweb-course. And I am using Xampp on a Mac, so the fields in my SQL version does not look exactly like they do in the video. I am currently at the video "PHPMyAdmin and Basic MySQL: part 2". When I write in the value of " INSERT INTO people (name) VALUES ('Stefan’); " around 2.55 into the video, I get the message: " INSERT INTO people (name) VALUES ('Stefan’); #1366 - Incorrect integer value: 'Stefan' for column `DATABAS2`.`people`.`name` at row 1 ". Any idea on what that means and how to solve it? And why is it showing up in my video and not in the lesson? ? Best regards ?
  • Recent Status Updates

×
×
  • Create New...
国产在线精品亚洲第1页,国产在线精品亚洲二区,九九线精品视频在线观看视频