By using phpmyadmin

Discussion in 'MySQL' started by Jalpari, Mar 2, 2007.

  1. #1
    i am new in mysql so that i want to know if i will design my db by using phpmyadmin GUI can my db will working fine
     
    Jalpari, Mar 2, 2007 IP
  2. Your Content

    Your Content Banned

    Messages:
    1,096
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Sure, if you have the basics to write your own database it will work using phpMyAdmin after creating such db and dumping your tables and data.
     
    Your Content, Mar 2, 2007 IP
  3. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #3
    i know how to connect db in dreamweaver but don't know how to make a hyperlink with db....but i know how to make hyperlink in dreamweaver
     
    Jalpari, Mar 4, 2007 IP
  4. Kalyse

    Kalyse Peon

    Messages:
    1,221
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    0
    #4
    What are you talking about?

    You want to make a hyperlink in dreamweaver?

    I dont understand?

    Do you mean you want to connect to the database through dreamweaver?

    I wouldnt know but you could just use the code to do it.

    Is this what you mean?
     
    Kalyse, Mar 4, 2007 IP
  5. Your Content

    Your Content Banned

    Messages:
    1,096
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Strange issue, I have never heard of connecting to mysql through Dreamweaver unless Jalpari is using such program as php editor and he means the connection string instead of link :\
     
    Your Content, Mar 4, 2007 IP
  6. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #6
    actually i am learning mysql so i was not sure it is string or link thanks for making correction
     
    Jalpari, Mar 5, 2007 IP
  7. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #7
    yes i want to connect db in DW ...... wht kind of code
     
    Jalpari, Mar 5, 2007 IP
  8. Kalyse

    Kalyse Peon

    Messages:
    1,221
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Just create a config.php and call it in every file you use.

    <?php
    
    if(isset($link)) {
    mysql_close($link);
    }
    
    
    
    $server = "localhost";	// server to connect to.
    $database = "db";	// the name of the database.
    $db_user = "user";	// mysql username to access the database with.
    $db_pass = "pass";	// mysql password to access the database with.
    
    $prefix_db = "";
    
    
    // connect to the mysql server 
    $link = mysql_pconnect($server, $db_user, $db_pass) 
    or die ("Could not connect to mysql because ".mysql_error()); 
    
    
    
    // select the database 
    mysql_select_db($database) 
    or die ("Could not select database because ".mysql_error()); 
    
    ?>
    PHP:
     
    Kalyse, Mar 8, 2007 IP