MySQL Forums
Forum List  »  PHP

MySql Import Questions
Posted by: Anne Atkinson
Date: June 09, 2016 05:42AM

Greetings,
i have probably been at this way to long and need to take a break but...

my sql community installed as a stand alone,
Xampp apache standalone
PHP standalone.

I have a folder that has a .sql file, file was loaded into workbench and database added..or so i thought!
working through some php in dreamweaver... i keep getting
Notice: Undefined index: cat_id in c:\ etc etc

PHP source;

<?php session_start();
error_reporting(E_ALL); ini_set('display_errors', '1');

$link=mysqli_connect("localhost","root","password") or die("cant connect");
mysqli_select_db($link,"jobscope") or die("cant select db");


$q = "select * from jobs where j_category ='".$_GET['cat']."' and j_active=1";

$res = mysqli_query($link,$q) or die("Wrong Query");



?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">;
<!--
Design by Free CSS Templates
http://www.freecsstemplates.org
Released for free under a Creative Commons Attribution 2.5 License

Name : Flowerily
Description: A two-column, fixed-width design for 1024x768 screen resolutions.
Version : 1.0
Released : 20090906

-->
<html xmlns="http://www.w3.org/1999/xhtml">;
<head>

<?php
include("includes/head.inc.php");
?>
</head>
<body>
<div id="header-wrapper">
<div id="header">
<div id="menu">
<?php
include("includes/menu.inc.php");
?>
</div>
<!-- end #menu -->
<div id="search">
<?php

include("includes/search.inc.php");
?>
</div>
<!-- end #search -->
</div>
</div>
<!-- end #header -->
<!-- end #header-wrapper -->
<div id="logo">
<?php
include("includes/logo.inc.php");
?>
</div>
<div id="wrapper">
<div id="page">
<div id="page-bgtop">
<hr />
<!-- end #logo -->
<div id="content">
<div class="post">

***** <h2 class="title"><?php echo $_GET['cat']; ?></h2> *****error is here
<p class="meta"></p>
<div class="entry">
<ul>
<?php
while($row = mysqli_fetch_assoc($res))
{



so im trying to work out why no matter what i do it keeps giving these errors!

so i look back over the folder, and the database...hmmmm

really ive been here for 4 hours now playing around...

the folder that had the .sql file in it also has a subfolder with another subfolder that has all these .myi .myd .frm and one .opt

1. so was i also supposed to somehow import these other files in the subfolder with the .sql file to populate the tables with data that is contained in these files?

2. was the .sql just the "exoskeleton" of the database? or should the .sql file have already contained all this information?

3. is this the reason for continually getting the index error because no matter what i did, the index was not there!

such a noob! but im getting there.

your assistance would be much appreciated!

Options: ReplyQuote


Subject
Written By
Posted
MySql Import Questions
June 09, 2016 05:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.